bu şekilde kodlarım

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER PROCEDURE [dbo].[stok_durumu]
@T1 NVARCHAR(20)='ithal',
@T2 NVARCHAR(20)='aysan'

AS
BEGIN

DECLARE @SQL NVARCHAR(MAX);

Set @SQL NOCOUNT ON


= ' SELECT dbo.LG_211_ITEMS.CODE AS [kod], dbo.LG_211_ITEMS.NAME AS [aciklama], LG_211_SPECODES.DEFINITION_ AS [turu], LG_211_SPECODES.SPECODE AS [aile],

SUM(CASE WHEN dbo.LG_211_01_STLINE.SOURCEINDEX = 0 THEN CASE WHEN dbo.LG_211_01_STLINE.IOCODE IN (1, 2)
THEN 1.0 ELSE - 1.0 END * dbo.LG_211_01_STLINE.AMOUNT END) AS [MERKEZ_STOK],
SUM(CASE WHEN dbo.LG_211_01_STLINE.SOURCEINDEX = 1 THEN CASE WHEN dbo.LG_211_01_STLINE.IOCODE IN (1, 2)
THEN 1.0 ELSE - 1.0 END * dbo.LG_211_01_STLINE.AMOUNT END) AS [MARKET_STOK],
SUM(CASE WHEN dbo.LG_211_01_STLINE.SOURCEINDEX = 9 THEN CASE WHEN dbo.LG_211_01_STLINE.IOCODE IN (1, 2)
THEN 1.0 ELSE - 1.0 END * dbo.LG_211_01_STLINE.AMOUNT END) AS [SHOWROOM_STOK]
FROM dbo.LG_211_01_STLINE INNER JOIN
dbo.LG_211_ITEMS ON dbo.LG_211_01_STLINE.STOCKREF = dbo.LG_211_ITEMS.LOGICALREF INNER JOIN
dbo.LG_211_SPECODES AS LG_211_SPECODES WITH (NOLOCK) ON dbo.LG_211_ITEMS.STGRPCODE = LG_211_SPECODES.SPECODE

GROUP BY dbo.LG_211_ITEMS.CODE, dbo.LG_211_ITEMS.NAME, LG_211_SPECODES.DEFINITION_,LG_211_SPECODES.SPECODE
HAVING (LG_211_SPECODES.DEFINITION_ IN ('''+@T1+''' ))
ORDER BY kod
';
EXEC sp_executesql @SQL;
PRINT @SQL;
END;