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

>Calling a procedure inside a procedure

I'd say yes.

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