Inexplicable error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Inexplicable error

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-08-08 : 07:41:17

Bill writes "Can you possibly tell me why this works (it's a very long proc but I've chopped a lot out)

*****************************************************************
ALTER PROCEDURE [spUPDATEdtaAppeals]
@CORefNum AS varchar(15),

AS
IF (@DateConsentLodged IS NOT NULL)
BEGIN
IF @DateConsentLodged='08/02/1950'
BEGIN
UPDATE dbo.dtaAppeals SET DateConsentLodged = NULL WHERE CORefNum = @CORefNum
END
ELSE
BEGIN
UPDATE dbo.dtaAppeals SET DateConsentLodged = @DateConsentLodged WHERE CORefNum = @CORefNum
END
END
*****************************************************************

BUT this gives me the error

Server: Msg 208, Level 16, State 3, Procedure spINSERTdtaAppeal, Line 23
Invalid object name 'dbo.dtaAppeals'.

*****************************************************************

ALTER PROCEDURE [spINSERTdtaAppeal]
(
@AppealID int,
@AppealType nvarCHAR(3),
@AppealYear smallINT,
@CORefNum varCHAR(15),
@Type nvarCHAR(8),
@Topic nvarCHAR(8),
@Status nvarCHAR(5),
@MajorType smallint,
@Bowman bit,
@DateLodged DateTime
)

AS

INSERT INTO dbo.dtaAppeals
(
@AppealID,
@AppealType,
@AppealYear,
@CORefNum,
@Type,
@Topic,
@Status,
@MajorType,
@Bowman,
@DateLodged
)

VALUES
(
@AppealType,
@AppealYear,
@CORefNum,
@Type,
@Topic,
@Status,
@MajorType,
@Bowman,
@DateLodged
)

AND THIS WORKS!!

INSERT INTO "dbo"."dtaAppeals" ("AppealID","AppealType","AppealYear","CORefNum","MajorType","Bowman","DateLodged","MotionTime")
VALUES (5440,N'CO', 2006, N'CO/5440/2006', 0,1, 'Jul 16 2006 12:00:00:000AM',35)"

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2006-08-08 : 14:11:28

change this:
INSERT INTO dbo.dtaAppeals
(
@AppealID,
@AppealType,
@AppealYear,
@CORefNum,
@Type,
@Topic,
@Status,
@MajorType,
@Bowman,
@DateLodged
)

to this:
INSERT INTO dbo.dtaAppeals
(
AppealID,
AppealType,
AppealYear,
CORefNum,
Type,
Topic,
Status,
MajorType,
Bowman,
DateLodged
)

Be One with the Optimizer
TG

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources