Derived table, or Tempdb

Derived table, or Tempdb

 

  

Hi All



I have to produce a report monthly for a customer



Doing so will require producing a few temporary tables.



Is it best practice to use derived tables (nested queries) or to create the
tables in tempdb and then run a query on them







Alec Wood










No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.519 / Virus Database: 269.22.1/1350 - Release Date: 30/03/2008
12:32


MS Sql Server LazyDBA home page