merhaba işine yaracak dostlar için paylasıyorum.
SET LANGUAGE Turkish
SELECT *
FROM ( SELECT ISNULL(st.AMOUNT, 0) AS miktar ,
DATENAME(mm, DATE_) AS ay ,
ITM.NAME ,
lc.DEFINITION_
FROM LG_016_01_STLINE AS st
INNER JOIN LG_016_CLCARD lc ON lc.LOGICALREF = st.CLIENTREF
INNER JOIN dbo.LG_016_ITEMS AS ITM ON ITM.LOGICALREF = st.STOCKREF
WHERE st.TRCODE <> 1
) tll PIVOT
( SUM(tll.miktar) FOR ay IN ( [Ocak], [Şubat], [Mart], [Nisan], [Mayıs],
[Haziran], [Temmuz], [Ağustos], [Eylül],
[Ekim], [Kasım], [Aralık] ) ) p;
STORED PROSEDUR
[code]CREATE PROCEDURE SPPİVOT
AS
BEGIN
SELECT *
FROM ( SET LANGUAGE Turkish
SELECT *
FROM ( SELECT ISNULL(st.AMOUNT, 0) AS miktar ,
DATENAME(mm, DATE_) AS ay ,
ITM.NAME ,
lc.DEFINITION_
FROM LG_016_01_STLINE AS st
INNER JOIN LG_016_CLCARD lc ON lc.LOGICALREF = st.CLIENTREF
INNER JOIN dbo.LG_016_ITEMS AS ITM ON ITM.LOGICALREF = st.STOCKREF
WHERE st.TRCODE <> 1
) tll PIVOT
( SUM(tll.miktar) FOR ay IN ( [Ocak], [Şubat], [Mart], [Nisan], [Mayıs],
[Haziran], [Temmuz], [Ağustos], [Eylül],
[Ekim], [Kasım], [Aralık] ) ) p;
END;