Just do a select.  The ADO.NET library will populate a DataSet
DataTables with one table for each SELECT statement.  Just make those
select statements come from the temp tables.

Not sure that selecting from temp tables would be good practice though
- they're (re)created in the temp database every time.  Is there no
way you can either populate a "live" scratch table, or maybe even
break your logic down into more simple joins on existing tables?  I'm
guessing you're using cursors to generate the results?

On Nov 5, 7:25 am, jaffar.k...@gmail.com wrote:

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.