Geeks With Blogs

News
Employers
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 MyGooglePageRank.com

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

i.e.

Select field1 From tableA
UNION
EXEC MySP

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

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

UNION

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: GeeksWithBlogs.net