Calling a procedure inside a procedure

[arunkumars]

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..?

[__avd]

>Calling a procedure inside a procedure

I'd say yes.

[arunkumars]

>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..?

[__avd]

Take a look at this thread - http://www.aspfree.com/c/a/ASP.NET-Code/Call-Stored-procedure-from-within-another-stored-procedure-return-values/