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