Database

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?