Database

SELECT Col1,Col2,Col3, COUNT(*) as DuplicateCount
FROM MyTable
GROUP BY Col1,Col2,Col3
ORDER BY DuplicateCount DESC

SELECT Col1,Col2,Col3, COUNT(*) as DuplicateCount
FROM MyTable
GROUP BY Col1,Col2,Col3
HAVING COUNT(*)>1

insert into newscheme.dbo.mytable
  select * from oldscheme.dbo.mytable

DECLARE @InputValue INT
SET @InputValue=3

DECLARE @PrintValue INT
SET @PrintValue=1



WHILE @InputValue > 0 
BEGIN
	  
		PRINT @PrintValue
		SET @PrintValue=@PrintValue+1
		SET @InputValue=@InputValue-1
END

System.Text.StringBuilder sb = new System.Text.StringBuilder() ;

sb.Append ( PartGroup ) ;
sb.Append ( "-" + Model ) ;
sb.Append ( "-" + Brand ) ;

string sep = "-"

if (sizee != "") { sbAppend ( sep + sizee ) ; sep = "*" ; }

if (sidee != "") { sbAppend ( sep + sidee ) ; sep = "*" ; }

if (color != "") { sbAppend ( sep + color ) ; sep = "*" ; }

sb.Append ( "-" + orgnShortName ) ;

return ( sb.ToString() ) ;