Viewing 2 posts - 1 through 2 (of 2 total)
What is LEAD(Date1) ??? 'LEAD' is not a recognized built-in function name.
January 30, 2014 at 11:04 am
#1684788
Try executing this query ;
UPDATE a
SET
a.Status = CASE WHEN b.action IN(1,3,4,5,6) THEN 'Y' ELSE 'N' END
FROM
TableA a
JOIN
TableB b
ON
a.SID = b.SID
January 29, 2014 at 10:23 pm
#1684524