Viewing 3 posts - 1 through 3 (of 3 total)
The before image should have read
WHILE @COUNTER < (SELECT COUNT(*) FROM ##TEMP_TABLE)
January 22, 2008 at 11:53 am
#770598
The before image should have been
January 22, 2008 at 11:51 am
#770595
As written, it doesn't create an INSERT statment for the last row in the table.
I changed
WHILE @COUNTER = (SELECT COUNT(*) FROM ##TEMP_TABLE)
to read
WHILE @COUNTER <= (SELECT COUNT(*) FROM ##TEMP_TABLE)
January 22, 2008 at 11:49 am
#770593