for that you need to take each set of columns you think would make a unique combination and do like
SELECT COL1,COL2,COL3
FROM table
GROUP BY Col1,Col2,Col3
HAVING COUNT(*) >1
if this returns any result then it means combination has duplicates
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
is there a way to find teh unique combination of
Posted - 02/13/2013 : 17:08:37
