Calling Stored Procedure and retrieving the value in SQL

Question

Calling Stored Procedure and retrieving the value in SQL

david blythner

SSC Rookie

Points: 34
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 3 (of 3 total)

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

Phil Parkin SSC Guru Points: 246979 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

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

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 SSC Rookie Points: 34 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.