ALTER VIEW dbo.[01_SON_SATISLAR]
AS
SELECT        STOCKREF, AMOUNT, DATE_, ROW_NUMBER() OVER (PARTITION BY STOCKREF
ORDER BY DATE_ DESC) AS [ORDER_]
FROM            ((SELECT        STL.STOCKREF, STL.AMOUNT, INV.DATE_
                            FROM            LG_011_09_STLINE AS STL WITH (NOLOCK)
                         UNION ALL
                         (SELECT        STL.STOCKREF, STL.AMOUNT, INV.DATE_
                            FROM            LG_011_08_STLINE AS STL WITH (NOLOCK) LEFT OUTER JOIN
                                                     LG_011_08_INVOICE AS INV WITH (NOLOCK) ON INV.LOGICALREF = STL.INVOICEREF
                            WHERE        STL.TRCODE = 8 AND STL.CANCELLED = 0 AND STL.LINETYPE = 0 AND STL.INVOICEREF <> 0)
                         UNION ALL
                         (SELECT        STL.STOCKREF, STL.AMOUNT, INV.DATE_
                          FROM            LG_011_07_STLINE AS STL WITH (NOLOCK) LEFT OUTER JOIN
                                                   LG_011_07_INVOICE AS INV WITH (NOLOCK) ON INV.LOGICALREF = STL.INVOICEREF
                          WHERE        STL.TRCODE = 8 AND STL.CANCELLED = 0 AND STL.LINETYPE = 0 AND STL.INVOICEREF <> 0)
UNION ALL
(SELECT        STL.STOCKREF, STL.AMOUNT, INV.DATE_
 FROM            LG_011_06_STLINE AS STL WITH (NOLOCK) LEFT OUTER JOIN
                          LG_011_06_INVOICE AS INV WITH (NOLOCK) ON INV.LOGICALREF = STL.INVOICEREF
 WHERE        STL.TRCODE = 8 AND STL.CANCELLED = 0 AND STL.LINETYPE = 0 AND STL.INVOICEREF <> 0)
UNION ALL
(SELECT        STL.STOCKREF, STL.AMOUNT, INV.DATE_
 FROM            LG_011_05_STLINE AS STL WITH (NOLOCK) LEFT OUTER JOIN
                          LG_011_05_INVOICE AS INV WITH (NOLOCK) ON INV.LOGICALREF = STL.INVOICEREF
 WHERE        STL.TRCODE = 8 AND STL.CANCELLED = 0 AND STL.LINETYPE = 0 AND STL.INVOICEREF <> 0)) QQ