0

Hi all,
The problem here is, is there a way in which i call the output of 1 stored procedure inside another and display that in the 2nd procedure results..?
Should we call a stored procedure inside a stored procedure for for this..?
If so, wats the way..?

2
Contributors
3
Replies
4
Views
7 Years
Discussion Span
Last Post by __avd
0

>Calling a procedure inside a procedure

I'd say yes.

hmm hmm, but wats the i wud go abt it...
i tried quite a few stuff,

exec sp_GetColumnList @tablename = 'Users' as @columnlist
exec sp_GetColumnList {@columnlist = DDL ) @tablename = 'Users'
exec sp_GetColumnList {@return_status = @columnlist ) @tablename = 'Users'

but these are not working.

which is the other ways to make it work..?

Edited by __avd: Added [code] tags. Encase your code in: [code] and [/code] tags.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.