Database

gabriel123456 wrote:

I want to select the distinct values from C1

gabriel123456 wrote:

where there is value 'a' in C2 and in C3 the value is NULL

gabriel123456 wrote:

or C2 does not contain value 'a' for the value in C1

SELECT DISTINCT C1 WHERE (C2 = 'a' AND C3 IS NULL) OR (C2 <> 'a')

Steve S wrote:

or has this been moved from the lounge? (I didn't know you could do that)

BEGIN TRANSACTION
CREATE TABLE dbo.Tmp_MyTestingTable
	(
	TestCol varchar(50) NULL
	)  ON [PRIMARY]

INSERT INTO dbo.Tmp_MyTestingTable (TestCol)
		SELECT DISTINCT TestCol FROM dbo.MyTestingTable TABLOCKX

DROP TABLE dbo.MyTestingTable

EXECUTE sp_rename 'dbo.Tmp_MyTestingTable', 'MyTestingTable'

COMMIT

DECLARE @cCol varchar(50)

DECLARE MyCursor CURSOR FOR
    SELECT testcol
    FROM MyTestingTable 

OPEN MyCursor
FETCH NEXT FROM MyCursor INTO @cCol
WHILE @@FETCH_STATUS = 0
BEGIN
	if(SELECT COUNT(*) FROM MyTestingTable WHERE TestCol = @cCol)>1
	BEGIN
		DELETE FROM MyTestingTable
			WHERE CURRENT OF MyCursor
	END
	FETCH NEXT FROM MyCursor INTO @cCol
END
CLOSE MyCursor
DEALLOCATE MyCursor
GO

BalasahebK wrote:

Yes I'm using Varchar in my table
still I would like to know, is there any way to convert such word in some proper format?