Cursor for a local variable

[asmith555]

Can a cursor be declared for a SQL statement that resides in a local variable such as

"DECLARE curUsers CURSOR FOR @sSQL

 

[hmckillop]

Not unless you put all the cursor code in as dynamic SQL
i.e.
DECLARE @v_SQL VARCHAR(2000)
SET @v_SQL = 'DECLARE curUsers CURSOR FOR ' + @sSQL
SET @v_SQL = @v_SQL + 'Other code within cursor'
exec @v_Sql



"I'm living so far beyond my income that we may almost be said to be living apart

 

[asmith555]

Can I still loop through the cursor in any way?

 

[vongrunt]

Insert results given by @sSQL into #temptable, then loop with cursor over it.

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[asmith555]

I guess that would work. Thanks vongrunt.