Hi,

The stored procedures used in my code is mounting, now I find myself having to create mulitiple recordsets and command objects. Some of these require parameters and a couple do not.

EXECUTE sp_xxxxx for each stored procedure wrapped up in a single stored procedure is what I was looking at so that I could change each sproc as needed and use it in other places in my code.

The question is how would I go about passing parameters to those sprocs wrapped up in the sproc or is there a better way?

This is with vb6 w/sp6 and MSSQL 2k w/sp4.

Thanks
John