Hi...This is my query I am running:
I am trying to print the row number and I can't see where is my err. Help me

declare @row_count int
SET @row_count = 0
SET @row_count = @row_count + 1
delete from table1 where not exists
(select num,id
from table2 where table1.num = table2.num and
table1.id = table2.id
print "row" + convert(varchar,@row_count))
Thanks