Monday, March 12, 2012

Quick SQL Question?

Hi Everyone:

I am trying to create the following SP, but get an Error stating "Must Declare the scalar variable "@.LoanApplicationID" eventhough I think I am declaring it. I am not sure what am I doing incorrect here, but a prompt solution would be appreciated. Thanks.

Here is the code:

CREATE PROCEDURE [LAFProcess].[uspUpdateProcessList]

AS

DECLARE @.LoanApplicationID int

SET NOCOUNT ON

SET TRANSACTION ISOLATION LEVEL READ COMMITTED

SET @.LoanApplicationID = (SELECT TOP 1 LoanApplicationID FROM LAFPRocess.WorkList WHERE Status = 2)

INSERT INTO LAFProcess.ProcessList (WorkListID, CreatedOn, ProcessStartedOn, Status)

SELECT TOP 1 WorkListID, GetDate(), NULL, 2

FROM LAFProcess.WorkList

WHERE Status = 2;

GO

UPDATE LAFProcess.WorkList

SET Status = 1

WHERE LoanApplicationID = @.LoanApplicationID

GO

GRANT EXEC ON [LAFProcess].[uspUpdateProcessList] TO PUBLIC

GO

The "GO" keyword causes this error. More information can be found at:

http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1161826,00.html

|||Thanks.

No comments:

Post a Comment