RE: Creating temp table

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Dean (anonymous_at_discussions.microsoft.com)
Date: 05/21/04

Next message: Tom Moreau: "Re: MVP??"
Previous message: Dean: "RE: Inserting into Invoice and Item tables"
In reply to: Bret: "Creating temp table"
Messages sorted by: [ date ] [ thread ]

Date: Thu, 20 May 2004 17:51:07 -0700

If you just need to stack the contents of 3 tables for query purposes then could might decide to use the UNION clause. If those 3 tables have lots of rows then you will beat the hell outta the tempdb by using a temp table.

Dean

Next message: Tom Moreau: "Re: MVP??"
Previous message: Dean: "RE: Inserting into Invoice and Item tables"
In reply to: Bret: "Creating temp table"
Messages sorted by: [ date ] [ thread ]