SQL Server Error: Common table expression defined but not used

Hi akhter,

Why are you using Common table expression.

Use below query to calculate the difference.

SQL

DECLARE @Iss INT
DECLARE @Ret INT
select @Iss = I_QTY From tbl_Issuance where I_Type='Issue'
select @Ret = I_QTY From tbl_Issuance where I_Type='Return'
select @Iss - @Ret  as difference

Use this.

Create procedure SP_Stk
as begin
	DECLARE @Iss INT
	DECLARE @Ret INT
	select @Iss = SUM(ISNULL(I_QTY,0)) From tbl_Issuance where I_Type='Issue'
	select @Ret = SUM(ISNULL(I_QTY,0)) From tbl_Issuance where I_Type='Return'
	select @Iss - @Ret  as difference
end