Need a unique gift idea?
A Pastebin account makes a great Christmas gift
SHARE
TWEET

Untitled

a guest Nov 14th, 2017 69 Never
Upgrade to PRO!
ENDING IN00days00hours00mins00secs
 
  1. SELECT TOP 20 *
  2.  FROM (SELECT [t1].[ID] AS [t1_ID],
  3.  [t1].[_stamp] AS [t1__stamp],
  4.  [t1].[Status] AS [t1_Status],
  5.  [t2].[Name] AS [t2_Name],
  6.  [t1].[NotificationNumber] AS [t1_NotificationNumber],
  7.  [t1].[OrderName] AS [t1_OrderName],
  8.  [t1].[Lot] AS [t1_Lot],
  9.  [t3].[StartPrice] AS [t3_StartPrice],
  10.  [t1].[PlacerInfo] AS [t1_PlacerInfo],
  11.  [t4].[FullName] AS [t4_FullName],
  12.  [t1].[PublishedDate] AS [t1_PublishedDate],
  13.  [t1].[p1Date] AS [t1_p1Date],
  14.  [t1].[p2Date] AS [t1_p2Date],
  15.  [t1].[Stage] AS [t1_Stage],
  16.  [t5].[Name] AS [t5_Name],
  17.  [t1].[LastChangeDate] AS [t1_LastChangeDate],
  18.  ROW_NUMBER() OVER ( ORDER BY t1.[ID] DESC)  as ROW_NUMBER
  19.  FROM [NotificationZK] t1 WITH(NOLOCK)
  20.  LEFT
  21.  JOIN [NotificationZKStagees] t5 WITH(NOLOCK) ON t5.[ID] = t1.[Stage]
  22.  LEFT
  23.  JOIN [OrganizationInfos] t4 WITH(NOLOCK) ON t4.[ID] = t1.[PlacerInfo]
  24.  LEFT
  25.  JOIN [NotificationZKLots] t3 WITH(NOLOCK) ON t3.[ID] = t1.[Lot]
  26.  LEFT
  27.  JOIN [NotificationZKStatuses] t2 WITH(NOLOCK) ON t2.[ID] = t1.[Status]
  28.  WHERE (t1.[IsGroupNotificationZK] = 0)
  29.    AND (t1.[IsTemplate] = 0)
  30.    AND ((t1.[ZKType] = 1)
  31.    OR (t1.[ZKType] = 3) )
  32.    AND ((t1.[IsPrivate] = 0)
  33.    OR (t1.[Placer] = 586003)
  34.    OR (t1.[Initiator] = 586003)
  35.    OR (EXISTS (SELECT t6.[NotificationZK]
  36.  FROM [CustomerRequirementZK] t6
  37.  WHERE (t6.[NotificationZK] = t1.[ID])
  38.    AND (t6.[Customer] = 586003) )) )
  39.    AND ((t1.[Placer] = 586003)
  40.    OR (t1.[Initiator] = 586003)
  41.    OR (EXISTS (SELECT t7.[NotificationZK]
  42.  FROM [CustomerRequirementZK] t7
  43.  WHERE (t7.[NotificationZK] = t1.[ID])
  44.    AND (t7.[Customer] = 586003) )) )
  45.    AND (t1.[IsLot] = 0) ) as [QueryRN]
  46.  WHERE ROW_NUMBER BETWEEN 1
  47.    AND 20
RAW Paste Data
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
 
Top