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