Stored procedures with recordset as parameter:
Posted on 2003-11-08
I have a stored procedure that is calculating prices on products.
I would like to call that stored procedure from other stored procedures,
with a recordset of products as parameter.
I know that you can't do that in sql server.
Therefore I'm thinking of letting the first stored procedure
insert the productid's together with an unique id into a table
and then call the price procedure with that unique id as parameter.
I would like to have comments on this approach.