Viewing 2 posts - 1 through 2 (of 2 total)
use IF EXISTS condition befor the update statement inside the cursor
IF EXISTS(Employeeid in the updating table)
THEN
UPDATE
ELSE
INSERT in to some other table
March 8, 2005 at 9:34 am
#545913
good material. looking forward for more enhanced feature in sql 2005
March 2, 2005 at 6:12 am
#544848