Problem with execution
From: Johny (goky2002_at_beograd.com)
Date: 10/24/04
- Next message: Ivan Debono: "ADO Stream error"
- Previous message: Mr. B: "Re: VB.Net (ADO): Thoughts on Copying 7 tables to 1 table"
- Messages sorted by: [ date ] [ thread ]
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
- Next message: Ivan Debono: "ADO Stream error"
- Previous message: Mr. B: "Re: VB.Net (ADO): Thoughts on Copying 7 tables to 1 table"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
