Viewing 2 posts - 1 through 2 (of 2 total)
Try moving your (print every 1000 rows) code into the WHILE @@FETCH_STATUS = 0 loop, like this:
...
FETCH NEXT FROM ProductCursor
INTO @ProductTopicID
WHILE @@FETCH_STATUS = 0
BEGIN
July 11, 2008 at 12:52 am
#841270
You'll have to use DDL to create the table, constraints, etc...
Most of it is easily generated by right clicking the source table - Script table as - Create to...
Then use...
July 11, 2008 at 12:25 am
#841261