How to return single resultset with multiple database queries

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?

Regards,
--Jaffar

.

Relevant Pages

  • Re: TDD and Refactoring
    ... >> exactly one query per temp. ... Perhaps I'm missing something. ... I'm not clear on why you feel that that increases complexity. ...
    (comp.object)
  • Re: How to return single resultset with multiple database queries
    ... This might be the wrong group to post this query, ... My final results are in the temp tables. ... How can I return a single result set from these multiple queries? ... SQL Server Table types OR d) somethine else altogether? ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Informix vs Oracle vs DB2. SQL Query optimization.
    ... but I think you're confused because you don't know Oracle. ... the query chooses to limit TAB_A by the col_id. ... initially we have the collection as geo1. ... case of 270,000 rows in the collection, and 60,000 rows in the temp ...
    (comp.databases.informix)
  • Re: Relationships, back end
    ... query the same, using the linked file directly rather than a temp table. ... |> into tblMovements but into a temp table, ... | adds the EquipmentID field the the temp table". ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Truncation Issue w/ Strings
    ... I was getting the results from an access query, so I ended up having to ... create a temp table, and insert the rows into a memo field in the temp ... "fdhsjak hfdjksh fdshfjkdlsh fjdshfj hdslfh dshfjlshjfhdsjflhdsjlfh ... dsjlkhfjdshfjdha jfdhj f " & _ ...
    (microsoft.public.vb.general.discussion)