Referring to Parameter/Variable names in stored proc

[philmck]

I want to loop through a small piece of code for each parameter @p1 to @pn passed into my stored procedure. Is there a way I refer to the parameters indirectly? e.g. in a local variable which will change on each loop iteration?

Thanks

 

[nigelrivett]

You can create a temp table, insert all the parameters into it then loop through that - create an identity on the temp table and use that to loop through the rows.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[philmck]

Thanks. Please forgive my ignorance here - Can I insert into a temp table without encountering the same problem?