Home Forums SQL Server 7,2000 T-SQL DECLARING CURSOR FOR WITH A VARIABLE RE: DECLARING CURSOR FOR WITH A VARIABLE
paulhumphris
Hall of Fame
Points: 3496
More actions
June 12, 2003 at 2:25 am
#460990
You cannot specific the sql statement as a variable for the cursor.
The easiest was around this is to include the whole cursor operation into your dynamic sql statement.