khushbu - Friday, April 21, 2017 3:22 AM

Can someone help me in writing this query. Doing some silly mistake but not able to recognize.
for testing purpose commented actual delete clause

if DB_name () = N'MyDB'
begin

IF( EXISTS( SELECT 1 FROM sch1.table1 WHERE guid= N'05172A47' and IntId=12 ))

print 'im deleting 1';

--DELETE FROM sch1.table1 where Guid = N'05172A47' and IntId=12

print 'im deleting 2';

IF( EXISTS( SELECT 1 FROM sch1.table1 WHERE Guid = N'3DFB856F' and IntId=13 ))

--DELETE FROM sch1.table1 where Guid = N'3DFB856F' and IntId=13

end
ELSE PRINT 'Nothing deleted'

end