Member Avatar for 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..?

  • 2 Contributors
  • 3 Replies
  • 145 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by kvprajapati
Member Avatar for kvprajapati

>Calling a procedure inside a procedure

I'd say yes.

Member Avatar for 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..?

Edited by kvprajapati because: Added [code] tags. Encase your code in: [code] and [/code] tags.
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.