Creating temp table

From: Bret (anonymous_at_discussions.microsoft.com)
Date: 05/20/04 

Date: Thu, 20 May 2004 14:11:05 -0700

Please, I want to create a stored procedure that does the following:
* Creates a temporary table
* Selects data from a table and appends to this temp table
* Selects data from a second table and appends to this temp table
* Selects data from a third table and appends to this temp table

All 3 source tables have exact design and format.a
thank you.

Relevant Pages

  • Re: Creating temp table
    ... union all ... "Bret" wrote in message ... > * Selects data from a second table and appends to this temp table ...
    (microsoft.public.sqlserver.programming)
  • Re: Creating temp table
    ... > * Selects data from a second table and appends to this temp table ... The only odd bit being that you have to provide a ... or else you get some syntax error. ...
    (microsoft.public.sqlserver.programming)
  • Condition for No Data
    ... I have a macro which appends a temp table to a SQL table and then deletes ...
    (microsoft.public.access.macros)
  • Re: SQLserver and the WHERE x IN y
    ... to a stored procedure - that would only work if you introduced subtyping into ... the temp table from the calling procedure (the temp table is still in scope, ... INSERT INTO #MyTempTable EXECUTE YourPopulateProc 123 ... INSERT INTO @MyTableVar VALUES ...
    (microsoft.public.sqlserver.programming)
  • Re: Stored Procedures in SE 7.3
    ... My end goal to write a stored procedure to be used by Lotus Enterprise ... Integrator (LEI). ... into temp t1; ... from bmdata, t1 ...
    (comp.databases.informix)