Cursor with parameters

Hi everybody!
I need your help.
I want to do a store procedure with a cursor that looks like this
CREATE PROCEDURE dbo.stp_JubiiTopDubletter @pr varchar(255)
AS
DECLARE
cur_Dubletter
CURSOR FOR
SELECT * FROM discounts where id in (@pr)
OPEN cur_Dubletter
FETCH
cur_Dubletter
INTO
@pr
CLOSE cur_Dubletter
DEALLOCATE cur_Dubletter

for instance @pr='1,2,3'

Somebody know how make the cursor variable??
thank you for help
Regards
Zoraya

YES ! :))
And can you guess maximum number of possible values in the @pr variable ?
I guess that there is max. 88 integer values, if there are no spaces.
So you could create up to 88 variables and write a little primitive parser to fill it, or create 88 parameters of stored procedure :))


------------
Zoraya at 7/30/01 3:06:21 PM

Hi everybody!
I need your help.
I want to do a store procedure with a cursor that looks like this
CREATE PROCEDURE dbo.stp_JubiiTopDubletter @pr varchar(255)
AS
DECLARE
cur_Dubletter
CURSOR FOR
SELECT * FROM discounts where id in (@pr)
OPEN cur_Dubletter
FETCH
cur_Dubletter
INTO
@pr
CLOSE cur_Dubletter
DEALLOCATE cur_Dubletter

for instance @pr='1,2,3'

Somebody know how make the cursor variable??
thank you for help
Regards
Zoraya