Parameters to Cursor !

[fixthebug2003]

Hi
Is it possible to pass a Parameter to a Cursor and then open it dynamically. Can someone point to the right resource for this?

Thanks
Fixthebug2003

 

[hmscott]

Unless I am much mistaken, parameters (or local variables) that are declared outside the CURSOR are still valid inside the cursor.

So:

DECLARE @MyParam1 varchar(10), @MyParam2 varchar(10)

DECLARE MyCursor CURSOR FOR
SELECT Column1, Column2
FROM MyTable

OPEN MyCursor

FETCH NEXT FROM MyCursor INTO @MyParam1, @MyParam2

WHILE @@FETCH_STATUS <> -1
BEGIN

IF @@FETCH_STATUS <> -2
BEGIN
' You can do whatever you want with @MyParam1, @MyParam2
...Code
END

FETCH NEXT FROM MyCursor INTO @MyParam1, @MyParam2
END

CLOSE MyCursor
DEALLOCATE MyCursor