API tools faq
paste
Advertisement
Guest User

12gigi

a guest
Oct 11th, 2019
130
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 9.95 KB | None | 0 0
raw download clone embed print report
  1. SELECT
  2.     [Project11].[C4] AS [C1],
  3.     [Project11].[C5] AS [C2],
  4.     [Project11].[ProductID] AS [ProductID],
  5.     [Project11].[sifra_kalkulacija] AS [sifra_kalkulacija],
  6.     [Project11].[sifra_kalkulacija1] AS [sifra_kalkulacija1],
  7.     [Project11].[ProductID1] AS [ProductID1],
  8.     [Project11].[ProductID2] AS [ProductID2],
  9.     [Project11].[sifra_jedinica1] AS [sifra_jedinica],
  10.     [Project11].[BusinessEntityID] AS [BusinessEntityID],
  11.     [Project11].[sifra_jedinica] AS [sifra_jedinica1],
  12.     [Project11].[sifra_nad_jedinica] AS [sifra_nad_jedinica],
  13.     [Project11].[C1] AS [C3],
  14.     [Project11].[C2] AS [C4],
  15.     [Project11].[sifra_tip_jedinica] AS [sifra_tip_jedinica],
  16.     [Project11].[Name] AS [Name],
  17.     [Project11].[C3] AS [C5],
  18.     [Project11].[C6] AS [C6]
  19.     FROM ( SELECT
  20.         [Project10].[sifra_jedinica] AS [sifra_jedinica],
  21.         [Project10].[sifra_nad_jedinica] AS [sifra_nad_jedinica],
  22.         [Project10].[sifra_tip_jedinica] AS [sifra_tip_jedinica],
  23.         [Project10].[ProductID] AS [ProductID],
  24.         [Project10].[sifra_kalkulacija] AS [sifra_kalkulacija],
  25.         [Project10].[sifra_kalkulacija1] AS [sifra_kalkulacija1],
  26.         [Project10].[ProductID1] AS [ProductID1],
  27.         [Project10].[sifra_jedinica1] AS [sifra_jedinica1],
  28.         [Project10].[ProductID2] AS [ProductID2],
  29.         [Project10].[BusinessEntityID] AS [BusinessEntityID],
  30.         [Project10].[Name] AS [Name],
  31.         [Project10].[C1] AS [C1],
  32.         [Project10].[C2] AS [C2],
  33.         [Project10].[redoslijed] AS [redoslijed],
  34.         CASE WHEN ([Project10].[sifra_destinacija] IS NULL) THEN CAST(NULL AS int) ELSE 1 END AS [C3],
  35.         [Project10].[C3] AS [C4],
  36.         [Project10].[C4] AS [C5],
  37.         [Project10].[C5] AS [C6]
  38.         FROM ( SELECT
  39.             [Project8].[sifra_jedinica] AS [sifra_jedinica],
  40.             [Project8].[sifra_nad_jedinica] AS [sifra_nad_jedinica],
  41.             [Project8].[sifra_tip_jedinica] AS [sifra_tip_jedinica],
  42.             [Project8].[ProductID] AS [ProductID],
  43.             [Project8].[sifra_kalkulacija] AS [sifra_kalkulacija],
  44.             [Project8].[sifra_kalkulacija1] AS [sifra_kalkulacija1],
  45.             [Project8].[ProductID1] AS [ProductID1],
  46.             [Project8].[sifra_jedinica1] AS [sifra_jedinica1],
  47.             [Project8].[ProductID2] AS [ProductID2],
  48.             [Project8].[BusinessEntityID] AS [BusinessEntityID],
  49.             [Project8].[Name] AS [Name],
  50.             [Project8].[C1] AS [C1],
  51.             [Project8].[C2] AS [C2],
  52.             [Project8].[sifra_destinacija] AS [sifra_destinacija],
  53.             [Project8].[redoslijed] AS [redoslijed],
  54.             [Project8].[C3] AS [C3],
  55.             [Project8].[C4] AS [C4],
  56.             CASE WHEN ([Project8].[sifra_destinacija] IS NULL) THEN CAST(NULL AS varchar(1)) ELSE (SELECT TOP (1)
  57.                 [Extent13].[naziv_destinacija] AS [naziv_destinacija]
  58.                 FROM [dbo].[destinacije_jezici] AS [Extent13]
  59.                 WHERE ([Project8].[sifra_destinacija] = [Extent13].[sifra_destinacija]) AND ( CAST( [Extent13].[sifra_jezik] AS int) = @p__linq__0)) END AS [C5]
  60.             FROM ( SELECT
  61.                 [Project7].[sifra_jedinica] AS [sifra_jedinica],
  62.                 [Project7].[sifra_nad_jedinica] AS [sifra_nad_jedinica],
  63.                 [Project7].[sifra_tip_jedinica] AS [sifra_tip_jedinica],
  64.                 [Project7].[ProductID] AS [ProductID],
  65.                 [Project7].[sifra_kalkulacija] AS [sifra_kalkulacija],
  66.                 [Project7].[sifra_kalkulacija1] AS [sifra_kalkulacija1],
  67.                 [Project7].[ProductID1] AS [ProductID1],
  68.                 [Project7].[sifra_jedinica1] AS [sifra_jedinica1],
  69.                 [Project7].[ProductID2] AS [ProductID2],
  70.                 [Project7].[BusinessEntityID] AS [BusinessEntityID],
  71.                 [Project7].[Name] AS [Name],
  72.                 [Project7].[C1] AS [C1],
  73.                 [Project7].[C2] AS [C2],
  74.                 [Filter6].[sifra_destinacija] AS [sifra_destinacija],
  75.                 [Filter6].[redoslijed] AS [redoslijed],
  76.                 [Project7].[C3] AS [C3],
  77.                 [Project7].[C4] AS [C4]
  78.                 FROM   (SELECT
  79.                     @p__linq__0 AS [p__linq__0],
  80.                     [Project4].[sifra_jedinica] AS [sifra_jedinica],
  81.                     [Project4].[sifra_nad_jedinica] AS [sifra_nad_jedinica],
  82.                     [Project4].[sifra_tip_jedinica] AS [sifra_tip_jedinica],
  83.                     [Project4].[ProductID] AS [ProductID],
  84.                     [Limit3].[sifra_kalkulacija] AS [sifra_kalkulacija],
  85.                     [Limit4].[sifra_kalkulacija] AS [sifra_kalkulacija1],
  86.                     [Join3].[ProductID1] AS [ProductID1],
  87.                     [Join3].[sifra_jedinica] AS [sifra_jedinica1],
  88.                     [Join3].[ProductID2] AS [ProductID2],
  89.                     [Extent10].[BusinessEntityID] AS [BusinessEntityID],
  90.                     [Extent10].[Name] AS [Name],
  91.                     CASE WHEN ([Project4].[C1] IS NULL) THEN 0 ELSE [Project4].[C2] END AS [C1],
  92.                     CASE WHEN ([Limit3].[IsPreparedForOperations] IS NULL) THEN cast(0 as bit) ELSE [Limit4].[IsPreparedForOperations] END AS [C2],
  93.                     [Project4].[C1] AS [C3],
  94.                     [Project4].[C2] AS [C4]
  95.                     FROM      (SELECT
  96.                         [Project2].[sifra_jedinica] AS [sifra_jedinica],
  97.                         [Project2].[sifra_nad_jedinica] AS [sifra_nad_jedinica],
  98.                         [Project2].[sifra_tip_jedinica] AS [sifra_tip_jedinica],
  99.                         [Project2].[ProductID] AS [ProductID],
  100.                         [Project2].[C1] AS [C1],
  101.                         (SELECT TOP (1)
  102.                             [Extent4].[sifra_kalkulacija] AS [sifra_kalkulacija]
  103.                             FROM [dbo].[kalkulacija_aranzmana] AS [Extent4]
  104.                             WHERE [Project2].[sifra_jedinica] = [Extent4].[sifra_jedinica]) AS [C2]
  105.                         FROM ( SELECT
  106.                             [Extent1].[sifra_jedinica] AS [sifra_jedinica],
  107.                             [Extent1].[sifra_nad_jedinica] AS [sifra_nad_jedinica],
  108.                             [Extent1].[sifra_tip_jedinica] AS [sifra_tip_jedinica],
  109.                             [Extent2].[ProductID] AS [ProductID],
  110.                             (SELECT TOP (1)
  111.                                 [Extent3].[sifra_kalkulacija] AS [sifra_kalkulacija]
  112.                                 FROM [dbo].[kalkulacija_aranzmana] AS [Extent3]
  113.                                 WHERE [Extent1].[sifra_jedinica] = [Extent3].[sifra_jedinica]) AS [C1]
  114.                             FROM  [dbo].[jedinice] AS [Extent1]
  115.                             LEFT OUTER JOIN [dbo].[ProductBusinessEntities] AS [Extent2] ON [Extent1].[sifra_jedinica] = [Extent2].[ProductID]
  116.                             WHERE [Extent1].[sifra_jedinica] IN (2084461, 2078956, 2078446, 2075774, 2075347, 2061975, 2041916, 2036489, 2036467, 1838918, 1706535, 1706533, 1706531, 1701226, 1691226, 1690648, 1686342, 1475516, 1475514, 1475505, 1454911, 1454909, 1454907, 1454897, 1454895, 1454893, 817397, 817383, 801977, 801975, 801973, 772190, 553678, 546642, 546349, 546040, 546021, 545765, 545749, 545596, 545156)
  117.                         )  AS [Project2] ) AS [Project4]
  118.                     OUTER APPLY  (SELECT TOP (1)
  119.                         [Extent5].[sifra_kalkulacija] AS [sifra_kalkulacija],
  120.                         [Extent5].[IsPreparedForOperations] AS [IsPreparedForOperations]
  121.                         FROM [dbo].[kalkulacija_aranzmana] AS [Extent5]
  122.                         WHERE [Project4].[sifra_jedinica] = [Extent5].[sifra_jedinica] ) AS [Limit3]
  123.                     OUTER APPLY  (SELECT TOP (1)
  124.                         [Extent6].[sifra_kalkulacija] AS [sifra_kalkulacija],
  125.                         [Extent6].[IsPreparedForOperations] AS [IsPreparedForOperations]
  126.                         FROM [dbo].[kalkulacija_aranzmana] AS [Extent6]
  127.                         WHERE [Project4].[sifra_jedinica] = [Extent6].[sifra_jedinica] ) AS [Limit4]
  128.                     LEFT OUTER JOIN  (SELECT [Extent7].[ProductID] AS [ProductID1], [Extent7].[BusinessEntityID] AS [BusinessEntityID1], [Join2].[sifra_jedinica], [Join2].[ProductID2]
  129.                         FROM  [dbo].[ProductBusinessEntities] AS [Extent7]
  130.                         INNER JOIN  (SELECT [Extent8].[sifra_jedinica] AS [sifra_jedinica], [Extent9].[ProductID] AS [ProductID2]
  131.                             FROM  [dbo].[jedinice] AS [Extent8]
  132.                             LEFT OUTER JOIN [dbo].[ProductBusinessEntities] AS [Extent9] ON [Extent8].[sifra_jedinica] = [Extent9].[ProductID] ) AS [Join2] ON [Join2].[sifra_jedinica] = [Extent7].[ProductID] ) AS [Join3] ON [Project4].[sifra_nad_jedinica] = [Join3].[sifra_jedinica]
  133.                     LEFT OUTER JOIN [dbo].[BusinessEntities] AS [Extent10] ON [Join3].[BusinessEntityID1] = [Extent10].[BusinessEntityID] ) AS [Project7]
  134.                 OUTER APPLY  (SELECT [Extent12].[sifra_destinacija] AS [sifra_destinacija], [Extent12].[redoslijed] AS [redoslijed]
  135.                     FROM  [dbo].[jedinice] AS [Extent11]
  136.                     INNER JOIN [dbo].[jedinice_destinacije] AS [Extent12] ON (CASE WHEN (168 =  CAST( [Project7].[sifra_tip_jedinica] AS int)) THEN [Project7].[sifra_jedinica] ELSE [Extent11].[sifra_jedinica] END) = [Extent12].[sifra_jedinica]
  137.                     WHERE [Project7].[sifra_nad_jedinica] = [Extent11].[sifra_jedinica] ) AS [Filter6]
  138.             )  AS [Project8]
  139.         )  AS [Project10]
  140.     )  AS [Project11]
  141.     ORDER BY [Project11].[C4] ASC, [Project11].[C5] ASC, [Project11].[ProductID] ASC, [Project11].[sifra_kalkulacija] ASC, [Project11].[sifra_kalkulacija1] ASC, [Project11].[ProductID1] ASC, [Project11].[ProductID2] ASC, [Project11].[sifra_jedinica1] ASC, [Project11].[BusinessEntityID] ASC, [Project11].[sifra_jedinica] ASC, [Project11].[C3] ASC, [Project11].[redoslijed] ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!