Problem with execution

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Johny (goky2002_at_beograd.com)
Date: 10/24/04 

Date: Sun, 24 Oct 2004 16:05:57 +0200

 have Stored procedure spAdmin_Do And I try to execute it.
 The procedure simply stop at the first EXEC 'delete Do.dbo.Admin_Do' and
don't continue.
 If I delete that line procedure again stop at the first EXEC.

 Is it problem if I have more EXEC in procedure or How can I solve this on
some different way?

The procedure spAdmin_Do:

CREATE PROCEDURE spAdmin_Do
(
 @sFiscalYear varchar(10)
)
AS
   @sQueryPart1 varchar(1000),
   @sQueryPart2 varchar(1000),
   @sQueryPart3 varchar(1000)

SET @sQueryPart1 = " Some query "
SET @sQueryPart2 = " Some query "
SET @sQueryPart3 = " Some query "

SET DATEFORMAT dmy
Exec ('delete Do.dbo.Admin_Do')
EXEC(@sQueryPart1)

EXEC(@sQueryPart2)
EXEC(@sQueryPart3)
GO

Relevant Pages

  • Problem with execution
    ... have Stored procedure spAdmin_Do And I try to execute it from application (I ... can execute it from Query Analyzer). ... If I delete that line procedure again stop at the first EXEC. ...
    (microsoft.public.sqlserver.programming)
  • Problem with execution
    ... I have Stored procedure spAdmin_Do And I try to execute it with ... If I delete that line procedure again stop at the first EXEC. ... SET DATEFORMAT dmy ...
    (borland.public.delphi.database.ado)