Execute a stored procedure and place results in a temporary table

From: Alastair Bell (anonymous_at_discussions.microsoft.com)
Date: 02/24/04 

Date: Tue, 24 Feb 2004 09:26:05 -0800

Could someone please advise me on the syntax in Transact SQL to execute a stored procedure (that returns records) and then place the results in a temporary table.

Thankyou - Alastair

Relevant Pages

  • Re: DELETE Trigger
    ... There is no THEN in transact SQL either, unless I am mistaken, but: ... > changed data to another table from where you extract the data using a ... > procedure to execute the script. ... You could schedule this stored procedure ...
    (microsoft.public.sqlserver.programming)
  • syntax incorect for sql statements?
    ... When I choose select statement or stored procedure it always gives me a ... Failed to execute statement, ensure the sql syntax is correct, I execute ...
    (microsoft.public.biztalk.general)
  • RE: SQL stored procedure executing twice
    ... I wasn't aware that DLookupwould execute the "domain" more than once. ... caused the stored procedure to execute twice. ... Dim stDocName As String ... My pass-thru query properties ...
    (microsoft.public.access.modulesdaovba)
  • 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: SQL stored procedure executing twice
    ... caused the stored procedure to execute twice. ... from one parent record to another. ... Dim stDocName As String ... The table tempCount does not change until I execute the VBA code line: ...
    (microsoft.public.access.modulesdaovba)