Member Avatar for deepas

I have a store procedure in which i need to get values from another procedure, so i called it and tried to insert in table variable. but i got the "An INSERT EXEC statement cannot be nested."
error message. anyone please give solution as i've already spent 2 days searching solution for this...
Thanks anyway

  • 3 Contributors
  • 2 Replies
  • 79 Views
  • 9 Hours Discussion Span
  • Latest Post Latest Post by sknake
Member Avatar for VIeditorlover

Have you already considered put results into temporary table?

Member Avatar for sknake

Can you post the offending queries? Please use code tags when posting code on daniweb:

A workaround for the problem you have described has been posted on MSDN

Edited by happygeek because: fixed formatting
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.