-
How do I use a table for parameters to a stored procedure
For 6.5
I need a way to use a table to input values into a stored procedure.
I tried writing a general procedure that would take the TableName and the Procedure Name and (using a table that has the Tables fields that has a field that allows parameter order) would execute the procedure with the parameters using a Cursor. My problem was that I couldn't use a variable like this
" Create Cursor For select @RestOfSQLQuery"
Then when I tried to Declare @variable @datatype without specifying, it really bombed.
Does anyone have anything like this? Am I going the wrong direction?
Thanks for your help,
Dona Mason
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|