CODEWITHSUNDEEP
t-sql
PositiveGuy
PositiveGuy

Reputation: 47773

Set Stored Proc variable to result of a call to another Proc

This is why I hate T-SQL. How the hell do you simply call another proc within a proc. All I want to do is declare a variable of type varchar(100) and set it to the value returned by executing another stored proc which is returning simply a varchar(100). I've tried to use EXEC but obviously you can't do that inside a proc and set the result to a variable?

Upvotes: 0

Views: 115

Answers (1)

Chriseyre2000
Chriseyre2000

Reputation: 2053

This guy expalains how to do what you want:

http://www.sqlteam.com/article/stored-procedures-returning-data

Upvotes: 2

Related Questions