Calling Stored Procedure and retrieving the value in SQL

Question

Calling Stored Procedure and retrieving the value in SQL

david blythner

Valued Member

Points: 54
More actions
September 25, 2004 at 7:08 am

#162286

hello i need something like this
select

Hello I need af function that creates a sql stored procedure, gets the output from the stored procedure

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 247158 More actions · Answer 1

David, please clarify what you're trying to do. I cannot think of a situation where you would need to create a stored procedure as part of a function call, so you may be on the wrong track.

Regards

Phil

Sarah Dutkiewicz SSCommitted Points: 1870 More actions · Answer 2

Is there a reason why you need a function to create the stored procedure rather than have the stored procedure already made?

What are you trying to do?

david blythner Valued Member Points: 54 More actions · Answer 3

hello there

I am trying to obtain a return value from a sp_sqlexecute....

I found another answer and will try it tomorrow, and if it works i will post the solution here.

Calling Stored Procedure and retrieving the value in SQL

Cookies on SQLServerCentral