Hi
I have in issue in update @temp table column from another table column value.
Once run Stored procedure, below is error
" Msg 137, Level 16, State 1, Procedure usp_Report_Statement, Line 43 [Batch Start Line 7] Must declare the scalar variable "@Statement".
Pls advice me
Thank you in advance
Maideen
What I have tried:
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[usp_Report_Statement]
@Action VARCHAR(50)=NULL,@sid varchar(25) = NULL,@nric varchar(30) = NULL,@NAME VARCHAR(100) NULL
AS
BEGIN
SET NOCOUNT ON;
DECLARE @Statement TABLE
(
[id] [bigint] IDENTITY(1,1) NOT NULL,
[RCNO] VARCHAR(10) NULL,
[RCDATE] DATE NULL,
[SID] [varchar](25) NULL,
[NAME] [varchar](50) NULL,
[NRIC] [varchar](25) NULL,
[COURSECODE] [varchar](20) NULL,
[COURSEFEEORI] [varchar](10) NULL,
[AMOUNT] NUMERIC (18,2) NULL,
[MODE] VARCHAR(20) NULL,
[RCVDFOR] VARCHAR(50) NULL,
[CHQAMT] NUMERIC(18,2) NULL,
[STATUS] VARCHAR(15) NULL,
[LOCATION] VARCHAR(10) NULL,
[TAGID] VARCHAR(5) NULL,
[INTAKEM] VARCHAR(25) NULL,
[INTAKEY] VARCHAR(5) NULL
)
INSERT INTO @Statement (RCNO,RCDATE,SID,NAME,COURSECODE,AMOUNT,RCVDFOR,STATUS,LOCATION,TAGID)
SELECT RCNO,RCDATE,SID,NAME,COURSECODE,AMOUNT,RCVDFOR,STATUS,LOCATION,'A'
FROM [dbo].[US_ReceiptDetails] where [sid]=@sid AND [NAME] = @NAME
INSERT INTO @Statement (RCNO,RCDATE,SID,NAME,COURSECODE,AMOUNT,RCVDFOR,STATUS,LOCATION,TAGID)
SELECT RCNO,RCDATE,SID,NAME,COURSECODE,AMOUNT,RCVDFOR,STATUS,LOCATION,'A'
FROM [dbo].[US_RefundDetails] where [sid]=@sid AND [NAME] = @NAME
UPDATE @Statement SET INTAKEM = A.INTAKEM, INTAKEY = A.INTAKEY FROM [dbo].[AD_StudentRecord] A
WHERE @Statement.SID = A.SID
SELECT * FROM @Statement
END