InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 17:42:29 GMT20http://www.sqlservercentral.com/Forums/Topic579287-338-1.aspx[quote][b]Daryl Smith (10/1/2008)[/b][hr]if exists(SELECT material_code FROM MATERIAL_UPDATES GROUP BY material_code HAVING count(*) > 1)BEGIN select "Table has Duplicates" RETURNENDelseselect "No Duplicates"-- your query here[/quote]little nice stuff here ...!!! :hehe:Thu, 02 Oct 2008 12:46:32 GMTDugihttp://www.sqlservercentral.com/Forums/Topic579287-338-1.aspxTHANKS SMITH FOR THE HELPITS WORKING FINE FOR ME ONCE AGAIN THANK YOUThu, 02 Oct 2008 11:05:29 GMTcherekuhttp://www.sqlservercentral.com/Forums/Topic579287-338-1.aspxif exists(SELECT material_code FROM MATERIAL_UPDATES GROUP BY material_code HAVING count(*) > 1)BEGIN select "Table has Duplicates" RETURNENDelseselect "No Duplicates"-- your query hereWed, 01 Oct 2008 17:13:48 GMTDaryl AZhttp://www.sqlservercentral.com/Forums/Topic579287-338-1.aspxhi iam having this problem with duplicate records, I want a query which will check the table for any duplicate records if there are any duplicates it should print "table has duplicates and quit the query and if there ae no duplicates it should print "no duplicates" and executethe query, i tried to use the below query but iam getting some errors could some one helpSELECT count(*) ,material_code FROM MATERIAL_UPDATES GROUP BY material_code HAVING count(*) > 1IF count(*) > 1 BEGIN[color=1001][/color]BEGINCOMMIT PRINT ' SUCCESS - no duplicate rows'ENDELSEBEGINROLLBACK print ' Failed - duplicate rows found'ENDCOMMIT ENDWed, 01 Oct 2008 11:57:36 GMTchereku