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 December 2006 Entries
UNION cant works on Execute SPs
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 tableAUNIONEXEC MySP ...will not work. Thanks to Geetali, for the following workaround. create table #temptable(field1 int )insert #temptable exec MySPselect * from #temptableUNIONSelect num1 From tableA ......

Posted On Thursday, December 7, 2006 11:28 AM

Copyright © Narendra Tiwari | Powered by: