<ja*********@gmail.comwrote in message
news:11**********************@d55g2000hsg.googlegr oups.com...
Hi All.
This might be the wrong group to post this query, since it is ADO.NET
related, but I couldn't find any ADO.NET group.
My problem is that I want to write some queries, which use temp table
because of their complexity. My final results are in the temp tables.
How can I return a single result set from these multiple queries?
It would help if you specified the DB you are using. Its easy for use to
draw a whole bunch of assumptions from what you posted which may be wildly
inaccurate. Its not east to tell your level of skill with SQL.
For example by temp table do you mean a) Tables you've created in the DB to
temporarily receive results, b) #temp SQL server tables, c) DECLARE @Temp
TABLE ... SQL Server Table types OR d) somethine else altogether?
It may be that all you need is to understand how to use JOINS and UNIONS in
SQL better.
--
Anthony Jones - MVP ASP/ASP.NET