📄 Tam SQL Kodu (Referans)

Analiz eklerken buradan kod parçalarını kopyalayabilirsiniz

CREATE VIEW dbo.[00001_SON_ALIM_LISTESI]
AS
SELECT        STOCKREF, AMOUNT, DATE_, ROW_NUMBER() OVER (PARTITION BY STOCKREF
ORDER BY DATE_ DESC) AS [ORDER_], ROW_NUMBER() OVER (PARTITION BY STOCKREF
ORDER BY DATE_ ASC) AS [ORDER2_]
FROM            ((SELECT        STL.STOCKREF, STL.AMOUNT, INV.DATE_
                            FROM            LG_011_08_STLINE AS STL WITH (NOLOCK) LEFT OUTER JOIN
                                                     LG_011_08_STFICHE AS INV WITH (NOLOCK) ON INV.LOGICALREF = STL.STFICHEREF
                            WHERE        STL.TRCODE = 1 AND STL.CANCELLED = 0 AND STL.LINETYPE = 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_STFICHE AS INV WITH (NOLOCK) ON INV.LOGICALREF = STL.STFICHEREF
                          WHERE        STL.TRCODE = 1 AND STL.CANCELLED = 0 AND STL.LINETYPE = 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_STFICHE AS INV WITH (NOLOCK) ON INV.LOGICALREF = STL.STFICHEREF
 WHERE        STL.TRCODE = 1 AND STL.CANCELLED = 0 AND STL.LINETYPE = 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_STFICHE AS INV WITH (NOLOCK) ON INV.LOGICALREF = STL.STFICHEREF
 WHERE        STL.TRCODE = 1 AND STL.CANCELLED = 0 AND STL.LINETYPE = 0)
UNION ALL
(SELECT        STL.STOCKREF, STL.AMOUNT, INV.DATE_
 FROM            LG_011_04_STLINE AS STL WITH (NOLOCK) LEFT OUTER JOIN
                          LG_011_04_STFICHE AS INV WITH (NOLOCK) ON INV.LOGICALREF = STL.STFICHEREF
 WHERE        STL.TRCODE = 1 AND STL.CANCELLED = 0 AND STL.LINETYPE = 0)
UNION ALL
(SELECT        STL.STOCKREF, STL.AMOUNT, INV.DATE_
 FROM            LG_011_03_STLINE AS STL WITH (NOLOCK) LEFT OUTER JOIN
                          LG_011_03_STFICHE AS INV WITH (NOLOCK) ON INV.LOGICALREF = STL.STFICHEREF
 WHERE        STL.TRCODE = 1 AND STL.CANCELLED = 0 AND STL.LINETYPE = 0)
UNION ALL
(SELECT        STL.STOCKREF, STL.AMOUNT, INV.DATE_
 FROM            LG_011_02_STLINE AS STL WITH (NOLOCK) LEFT OUTER JOIN
                          LG_011_02_STFICHE AS INV WITH (NOLOCK) ON INV.LOGICALREF = STL.STFICHEREF
 WHERE        STL.TRCODE = 1 AND STL.CANCELLED = 0 AND STL.LINETYPE = 0)
UNION ALL
(SELECT        STL.STOCKREF, STL.AMOUNT, INV.DATE_
 FROM            LG_011_01_STLINE AS STL WITH (NOLOCK) LEFT OUTER JOIN
                          LG_011_01_STFICHE AS INV WITH (NOLOCK) ON INV.LOGICALREF = STL.STFICHEREF
 WHERE        STL.TRCODE = 1 AND STL.CANCELLED = 0 AND STL.LINETYPE = 0)) QQ

➕ Yeni Kod Analizi Ekle

📋 Mevcut Analizler (3)

Adım 1 
SELECT STL.STOCKREF, STL.AMOUNT, INV.DATE_
FROM LG_011_08_STLINE AS STL WITH (NOLOCK)
LEFT OUTER JOIN LG_011_08_STFICHE AS INV WITH (NOLOCK)
  ON I...

Bu blok şu mantıkla çalışır: Kaynak tablo: LG_011_08_STLINE → Logo’da stok hareket satırları / f ...

Adım 2 
... (08 dönemi)
UNION ALL
... (07 dönemi)
UNION ALL
... (06 dönemi)
...
UNION ALL
... (01 dönemi)

Burada olan şey: Her dönemden gelen satırlar tek bir büyük liste gibi alt alta ekleniyor. Te ...

Adım 3 
ROW_NUMBER() OVER (PARTITION BY STOCKREF ORDER BY DATE_ DESC) AS [ORDER_],
ROW_NUMBER() OVER (PARTITION BY STOCKREF ORDER BY DATE_ ASC)  AS [ORDER2_]

3A) PARTITION BY STOCKREF SQL Server tüm listeyi alıyor, her stok için ayrı bir grup oluştur ...