Hi!,
insert into #saldo_alimento
exec IFMX_FeedInventory @inicio, @termino
IFMX_FeedInventory is procedure then its ok. so it means you
will pass two parameter to the stored proc.
But Your Insert into command was not properly ended. that's
why it will give you this error. OR if you have plan to use
Exec in Insert into command then it's not allowed. So change
the Query.
Regards,
Milind Amin
Software Professional
TechProcess Solution Ltd
Direct: +91-22-66528612 (M-F Firstly)
Cell: +91-9819916106 (M-S Secondly)
------------------------------------
TEAMWORK...
Coming together is a beginning;
Keeping together is progress;
Working together is a success;
-------------------------------------
-----Original Message-----
From: Heraclio Cejas Corrales
[mailto:mssqldba-ezmlmshield-x77951495.[Email address protected]
om]
Sent: Tuesday, December 26, 2006 9:21 PM
To: LazyDBA Discussion
Subject: Urgent Help
Hi All:
When I execute under Sql Server 2000 the following:
create table #saldo_alimento (
OperationUnitdID int ,
InternalCode varchar(20),
OperationUnitTypeID int,
OperationUnitTypeName varchar (30),
BirdType varchar(50),
Lotcode varchar(30),
FeedStorageID int,
Description varchar (50),
HourFeedDelivery int,
Active bit,
BalanceDate datetime,
FeedtypeID int,
FeedType varchar(50),
CloseBalance float,
TransportSheet int
)
declare @inicio varchar(8)
declare @termino varchar(8)
SELECT @inicio = CONVERT(char(8), Current_Timestamp, 112) +
Replace(Convert(char(5), Current_Timestamp, 114), ':','')
SELECT @termino = CONVERT( char(8), Current_Timestamp, 112)
+
Replace(Convert(char(5), Current_Timestamp, 114),':','')
insert into #saldo_alimento
exec IFMX_FeedInventory @inicio, @termino
I receive the message:
Server: Msg 8164, Level 16, State 1, Procedure
IFMX_FeedInventory, Line 35
An INSERT EXEC statement cannot be nested.
Server: Msg 8164, Level 16, State 1, Procedure
IFMX_FeedInventory, Line 35
An INSERT EXEC statement cannot be nested.
Server: Msg 8164, Level 16, State 1, Procedure
IFMX_FeedInventory, Line 35
An INSERT EXEC statement cannot be nested.
Server: Msg 8164, Level 16, State 1, Procedure
IFMX_FeedInventory, Line 35
An INSERT EXEC statement cannot be nested.
Server: Msg 8164, Level 16, State 1, Procedure
IFMX_FeedInventory, Line 35
An INSERT EXEC statement cannot be nested.
(0 row(s) affected)
Thanks in advance.
Heraclio Cejas Corrales.
DBA Chile
------------------------------------------------------------
---------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST
REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
--
"This e-mail message may contain confidential, proprietary or legally privileged information. It
should not be used by anyone who is not the original intended recipient. If you have erroneously
received this message, please delete it immediately and notify the sender. The recipient
acknowledges that ICICI Bank or its subsidiaries and associated companies, (collectively "ICICI
Group"), are unable to exercise control or ensure or guarantee the integrity of/over the contents of the information contained in e-mail transmissions and further acknowledges that any views
expressed in this message are those of the individual sender and no binding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of ICICI Group.Before opening any attachments please check them for viruses and defects."
MS Sql Server LazyDBA home page