Geeks With Blogs

Soppa Group India
iSmart Panache Inc
R Systems Internationals Ltd
Technovate eSolutions Pvt Ltd
The contents of this blog are my personal opinion and do not represent in any way the view of my employer.
These postings are provided "AS IS" with no warranties, and confer no rights.

Google PR™ - Post your Page Rank with

Narendra Tiwari

I had a problem in UNION the data from two resultsets in which one resultset suppose to be the result of a SP, unfortunately UNION does not support this..


Select field1 From tableA

...will not work. Thanks to Geetali, for the following workaround.

create table #temptable
(field1 int )
insert #temptable exec MySP
select * from #temptable


Select num1 From tableA

Posted on Thursday, December 7, 2006 11:28 AM .Net | Back to top

Comments on this post: UNION cant works on Execute SPs

No comments posted yet.
Your comment:
 (will show your gravatar)

Copyright © Narendra Tiwari | Powered by: