InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 09:52:43 GMT20http://www.sqlservercentral.com/Forums/Topic1370269-21-1.aspxHi thereMy database table is as below with two columns and with no primary keyEmployee (EmpNo, IsDummy)eg.1,Y2,Y3,N4,N5,YMy updategram is as below<SendRequest xmlns:updg="urn:schemas-microsoft-com:xml-updategram"> <updg:sync> <before> <Employee IsDummy="N" /> </before> </updg:sync></SendRequest>Now I want this updategram to delete all records where IsDummy=N.Please find me the best way to do it as I have been trying to achieve it for long time.ThanksTue, 09 Oct 2012 03:48:30 GMTmanibest