Dear ALL,

I am using SQL Server 2000 and Visual Basic. I need to generate an summary Report. The Data for the report are taken from 12 tables. I cant retriew data from a single SQL Statement. There are about 60,000 average records in each table.

I try to do it with temp Tables.

It was successfull. But when I generate report it seams to be very slow.
and also I saw in several wesites, "Dont use Temp Tables in SQL Server"

Is there any way of doing above.

In this kind of cases What can I Do?

Pl help me.

Thank you.