I need to select some data (surprise) from several tables in a linked database which is running SQL Server 2000.Now the resulting data set will be about 10,000 records taken from ~ 8 tables.I can ...

I have concluded that the easiest way may be to create a temporary table that I can generate the report from and do my queries.<BR><BR>So - here is what I'd like to do:<BR><BR>1.

When your SQL query is ready, you can run the query immediately or you can add a title, change its options, limit its output, and so on, to make the report look better. See Viewing the SQL Code, ...