Viewing 2 posts - 1 through 3 (of 3 total)
this update statement is working
UPDATE TableA
SET Value = isnull((select top 1 Value from #tmpcopylibrary
where dataid = tempquerydataid), 0).
however this is not working
SET Value = isnull((select top 1 Value...
August 1, 2014 at 8:52 am
#1734466
Hi Eric,
it is setting all value to zero on a setup, where the temp table having matching dataid
July 24, 2014 at 2:36 am
#1732031