CREATE VIEW dbo.SON_SATIS_MIKTARLARI
AS
SELECT        STOCKREF, SUM(UC) AS UC, SUM(ALTI) AS ALTI, SUM(DOKUZ) AS DOKUZ
FROM            ((SELECT        QQ.STOCKREF, SUM(QQ.AMOUNT) AS UC, 0 AS ALTI, 0 AS DOKUZ
                            FROM            ((SELECT        STOCKREF, AMOUNT, DATE_
                                                        FROM            [UNIVERSALDB].[dbo].LG_011_08_STLINE
                                                        WHERE        TRCODE = 8 AND CANCELLED = 0)
                                                     UNION ALL
                                                     (SELECT        STOCKREF, AMOUNT, DATE_
                                                      FROM            [UNIVERSALDB].[dbo].LG_011_07_STLINE
                                                      WHERE        TRCODE = 8 AND CANCELLED = 0)) QQ
WHERE        QQ.DATE_ > CAST(DATEADD(DAY, - 90, GETDATE()) AS DATE)
GROUP BY QQ.STOCKREF
HAVING        SUM(QQ.AMOUNT) > 0)
UNION ALL
(SELECT        QQ.STOCKREF, 0 AS UC, SUM(QQ.AMOUNT) AS ALTI, 0 AS DOKUZ
 FROM            ((SELECT        STOCKREF, AMOUNT, DATE_
                             FROM            [UNIVERSALDB].[dbo].LG_011_08_STLINE
                             WHERE        TRCODE = 8 AND CANCELLED = 0)
                          UNION ALL
                          (SELECT        STOCKREF, AMOUNT, DATE_
                           FROM            [UNIVERSALDB].[dbo].LG_011_07_STLINE
                           WHERE        TRCODE = 8 AND CANCELLED = 0)) QQ
WHERE        QQ.DATE_ > CAST(DATEADD(DAY, - 180, GETDATE()) AS DATE)
GROUP BY QQ.STOCKREF
HAVING        SUM(QQ.AMOUNT) > 0)
UNION ALL
(SELECT        QQ.STOCKREF, 0 AS UC, 0 AS ALTI, SUM(QQ.AMOUNT) AS DOKUZ
 FROM            ((SELECT        STOCKREF, AMOUNT, DATE_
                             FROM            [UNIVERSALDB].[dbo].LG_011_08_STLINE
                             WHERE        TRCODE = 8 AND CANCELLED = 0)
                          UNION ALL
                          (SELECT        STOCKREF, AMOUNT, DATE_
                           FROM            [UNIVERSALDB].[dbo].LG_011_07_STLINE
                           WHERE        TRCODE = 8 AND CANCELLED = 0)) QQ
WHERE        QQ.DATE_ > CAST(DATEADD(DAY, - 270, GETDATE()) AS DATE)
GROUP BY QQ.STOCKREF
HAVING        SUM(QQ.AMOUNT) > 0)) KK
GROUP BY KK.STOCKREF