Hi
I am trying to run a stored procedure that requires four value be fed into it, but I don't want to use fixed values, but use values from a table instead and am not sure how to write this out.
what I have written is:
select value1, value2, value3, value4 from #TEMP1
EXEC stored_procedure value1, value2, value3, value4
The values in the select don't seem to flow into the EXEC statement. what am I missing?? Do I need to assign the the fields to the parameters?
Thanks
Anna
I am trying to run a stored procedure that requires four value be fed into it, but I don't want to use fixed values, but use values from a table instead and am not sure how to write this out.
what I have written is:
select value1, value2, value3, value4 from #TEMP1
EXEC stored_procedure value1, value2, value3, value4
The values in the select don't seem to flow into the EXEC statement. what am I missing?? Do I need to assign the the fields to the parameters?
Thanks
Anna