a select statement to pass parameters to a stored procedure
Posted on 2006-05-30
I call a stored procedure by using 'execute' into an another stored procedure.
I would like pass some parameters with a select statement.
Something like that :
exec stp_order_insert (select param1,param2 from table3 where x=@param3 and Y=@Param4)
My stp_order_insert needs 2 parameters are integers.
I think my select statement returns a string and that's why my execute failed .