procedure with temp tables

From: Subbaiahd (subbaiahd_at_hotmail.com)
Date: 07/09/04 

Date: Fri, 9 Jul 2004 14:12:52 -0400

I wrote a stored procedure which uses temp tables in its logic, tested it in
query analyser it is executed without errors, when i try to execute it in
DTS activex script, it is failing. If i remove temp tables usage inside
procedure i am able to execute in the same activex script, can someone get
me more insight of it. is it really a problem ?, if it is how to avoid it.

Thanks,
Subbu.

Relevant Pages

  • 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: Error running Stored Procedures
    ... If ASP makes two separate calls to these stored procedures, ... temp tables only exist until all things that touch it go out of scope, ... have ASP call one stored procedure, ... > At line 43 is the command line to execute the recordset that will ...
    (microsoft.public.sqlserver.programming)
  • Re: Stored Procedure as part of SELECT?
    ... temp table variable and then execute a stored procedure that would populate ...
    (microsoft.public.sqlserver.programming)
  • Re: procedure with temp tables
    ... NOCOUNT ON at the begining of your stored procedure? ... > DTS activex script, it is failing. ... > procedure i am able to execute in the same activex script, ...
    (microsoft.public.sqlserver.dts)
  • 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)