API tools faq
paste
Veikedo

Untitled

Veikedo
Apr 8th, 2016
193
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 21.71 KB | None | 0 0
raw download clone embed print report
  1. exec sp_executesql N'SELECT
  2.    [Project2].[Id] AS [Id],
  3.    [Project2].[C2] AS [C1],
  4.    [Project2].[C1] AS [C2],
  5.    [Project2].[Id1] AS [Id1],
  6.    [Project2].[Code] AS [Code],
  7.    [Project2].[Description] AS [Description],
  8.    [Project2].[TimeStamp] AS [TimeStamp],
  9.    [Project2].[ModifierID] AS [ModifierID],
  10.    [Project2].[LastModifiedTime] AS [LastModifiedTime],
  11.    [Project2].[IsInactive] AS [IsInactive],
  12.    [Project2].[ListNameId] AS [ListNameId]
  13.    FROM ( SELECT
  14.        [Limit1].[Id] AS [Id],
  15.        [Extent2].[Id] AS [Id1],
  16.        [Extent2].[Code] AS [Code],
  17.        [Extent2].[Description] AS [Description],
  18.        [Extent2].[TimeStamp] AS [TimeStamp],
  19.        [Extent2].[ModifierID] AS [ModifierID],
  20.        [Extent2].[LastModifiedTime] AS [LastModifiedTime],
  21.        [Extent2].[IsInactive] AS [IsInactive],
  22.        [Extent2].[ListNameId] AS [ListNameId],
  23.        CASE WHEN ([Extent2].[Id] IS NULL) THEN CAST(NULL AS varchar(1)) WHEN (((CASE WHEN ([Extent2].[Discriminator] = 39) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 65) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 64) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 66) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 143) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 67) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 144) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 5) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 38) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 83) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 79) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 238) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 310) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 316) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 309) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 308) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 314) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 315) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 313) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 311) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 312) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 162) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 1) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 317) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 105) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 152) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 44) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 45) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 43) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 405) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 232) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 305) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 76) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 171) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 6) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 2) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 88) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 87) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 121) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 116) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 34) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 84) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 7) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 102) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 93) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 289) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 89) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 59) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 11) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 9) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 10) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 242) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 151) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 60) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 32) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 31) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 210) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 26) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 29) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 30) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 27) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 209) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 28) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 132) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 205) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 149) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 101) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 248) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 249) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 213) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 15) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 146) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 206) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 207) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 402) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 401) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 400) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 111) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 212) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 142) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 408) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 409) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 406) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 404) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 407) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 13) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 120) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 16) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 131) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 156) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 160) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 161) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 296) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 158) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 159) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 110) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 163) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 403) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 103) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 8) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 222) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 231) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 230) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 228) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 226) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 229) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 223) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 224) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 227) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 225) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 125) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 25) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 124) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 129) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 217) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 123) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 122) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 154) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 218) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 134) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 216) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 126) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 153) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 211) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 37) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 33) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 100) THEN cast(1 as bit) ELSE
  24. cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 306) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND
  25. ((CASE WHEN ([Extent2].[Discriminator] = 251) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN
  26. ([Extent2].[Discriminator] = 304) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] =
  27. 117) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 86) THEN cast(1 as bit) ELSE
  28. cast(0 as bit) END) <> 1) AND ((CASE WHEN ([Extent2].[Discriminator] = 307) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1) AND
  29. ((CASE WHEN ([Extent2].[Discriminator] = 214) THEN cast(1 as bit) ELSE cast(0 as bit) END) <> 1)) THEN ''2X'' WHEN
  30. ([Extent2].[Discriminator] = 211) THEN ''2X0X'' WHEN ([Extent2].[Discriminator] = 79) THEN ''2X1X'' WHEN
  31. ([Extent2].[Discriminator] = 162) THEN ''2X2X'' WHEN ([Extent2].[Discriminator] = 76) THEN ''2X3X'' WHEN
  32. ([Extent2].[Discriminator] = 102) THEN ''2X4X'' WHEN ([Extent2].[Discriminator] = 11) THEN ''2X5X'' WHEN
  33. ([Extent2].[Discriminator] = 9) THEN ''2X6X'' WHEN ([Extent2].[Discriminator] = 10) THEN ''2X7X'' WHEN ([Extent2].[Discriminator]
  34. = 242) THEN ''2X8X'' WHEN ([Extent2].[Discriminator] = 151) THEN ''2X9X'' WHEN ([Extent2].[Discriminator] = 60) THEN ''2X10X''
  35. WHEN ([Extent2].[Discriminator] = 32) THEN ''2X11X'' WHEN ([Extent2].[Discriminator] = 31) THEN ''2X12X'' WHEN
  36. ([Extent2].[Discriminator] = 210) THEN ''2X13X'' WHEN ([Extent2].[Discriminator] = 26) THEN ''2X14X'' WHEN
  37. ([Extent2].[Discriminator] = 29) THEN ''2X15X'' WHEN ([Extent2].[Discriminator] = 30) THEN ''2X16X'' WHEN
  38. ([Extent2].[Discriminator] = 27) THEN ''2X17X'' WHEN ([Extent2].[Discriminator] = 209) THEN ''2X18X'' WHEN
  39. ([Extent2].[Discriminator] = 28) THEN ''2X19X'' WHEN ([Extent2].[Discriminator] = 132) THEN ''2X20X'' WHEN
  40. ([Extent2].[Discriminator] = 205) THEN ''2X21X'' WHEN ([Extent2].[Discriminator] = 149) THEN ''2X22X'' WHEN ([Extent2].[Discriminator] = 101) THEN ''2X23X'' WHEN ([Extent2].[Discriminator] = 248) THEN ''2X24X'' WHEN ([Extent2].[Discriminator] = 249) THEN ''2X25X'' WHEN ([Extent2].[Discriminator] = 213) THEN ''2X26X'' WHEN ([Extent2].[Discriminator] = 15) THEN ''2X27X'' WHEN ([Extent2].[Discriminator] = 146) THEN ''2X28X'' WHEN ([Extent2].[Discriminator] = 206) THEN ''2X29X'' WHEN ([Extent2].[Discriminator] = 207) THEN ''2X30X'' WHEN ([Extent2].[Discriminator] = 402) THEN ''2X31X'' WHEN ([Extent2].[Discriminator] = 401) THEN ''2X32X'' WHEN ([Extent2].[Discriminator] = 400) THEN ''2X33X'' WHEN ([Extent2].[Discriminator] = 111) THEN ''2X34X'' WHEN ([Extent2].[Discriminator] = 212) THEN ''2X35X'' WHEN ([Extent2].[Discriminator] = 142) THEN ''2X36X'' WHEN ([Extent2].[Discriminator] = 408) THEN ''2X37X'' WHEN ([Extent2].[Discriminator] = 409) THEN ''2X38X'' WHEN ([Extent2].[Discriminator] = 406) THEN ''2X39X'' WHEN ([Extent2].[Discriminator] = 404) THEN ''2X40X'' WHEN ([Extent2].[Discriminator] = 407) THEN ''2X41X'' WHEN ([Extent2].[Discriminator] = 13) THEN ''2X42X'' WHEN ([Extent2].[Discriminator] = 120) THEN ''2X43X'' WHEN ([Extent2].[Discriminator] = 16) THEN ''2X44X'' WHEN ([Extent2].[Discriminator] = 131) THEN ''2X45X'' WHEN ([Extent2].[Discriminator] = 156) THEN ''2X46X'' WHEN ([Extent2].[Discriminator] = 160) THEN ''2X47X'' WHEN ([Extent2].[Discriminator] = 161) THEN ''2X48X'' WHEN ([Extent2].[Discriminator] = 296) THEN ''2X49X'' WHEN ([Extent2].[Discriminator] = 158) THEN ''2X50X'' WHEN ([Extent2].[Discriminator] = 159) THEN ''2X51X'' WHEN ([Extent2].[Discriminator] = 110) THEN ''2X52X'' WHEN ([Extent2].[Discriminator] = 163) THEN ''2X53X'' WHEN ([Extent2].[Discriminator] = 403) THEN ''2X54X'' WHEN ([Extent2].[Discriminator] = 103) THEN ''2X55X'' WHEN ([Extent2].[Discriminator] = 8) THEN ''2X56X'' WHEN ([Extent2].[Discriminator] = 222) THEN ''2X57X'' WHEN ([Extent2].[Discriminator] = 231) THEN ''2X58X'' WHEN ([Extent2].[Discriminator] = 230) THEN ''2X59X'' WHEN ([Extent2].[Discriminator] = 228) THEN ''2X60X'' WHEN
  41. ([Extent2].[Discriminator] = 226) THEN ''2X61X'' WHEN ([Extent2].[Discriminator] = 229) THEN ''2X62X'' WHEN
  42. ([Extent2].[Discriminator] = 223) THEN ''2X63X'' WHEN ([Extent2].[Discriminator] = 224) THEN ''2X64X'' WHEN
  43. ([Extent2].[Discriminator] = 227) THEN ''2X65X'' WHEN ([Extent2].[Discriminator] = 225) THEN ''2X66X'' WHEN
  44. ([Extent2].[Discriminator] = 125) THEN ''2X67X'' WHEN ([Extent2].[Discriminator] = 25) THEN ''2X68X'' WHEN
  45. ([Extent2].[Discriminator] = 124) THEN ''2X69X'' WHEN ([Extent2].[Discriminator] = 129) THEN ''2X70X'' WHEN
  46. ([Extent2].[Discriminator] = 217) THEN ''2X71X'' WHEN ([Extent2].[Discriminator] = 123) THEN ''2X72X'' WHEN
  47. ([Extent2].[Discriminator] = 122) THEN ''2X73X'' WHEN ([Extent2].[Discriminator] = 154) THEN ''2X74X'' WHEN
  48. ([Extent2].[Discriminator] = 218) THEN ''2X75X'' WHEN ([Extent2].[Discriminator] = 134) THEN ''2X76X'' WHEN
  49. ([Extent2].[Discriminator] = 216) THEN ''2X77X'' WHEN ([Extent2].[Discriminator] = 126) THEN ''2X78X'' WHEN
  50. ([Extent2].[Discriminator] = 153) THEN ''2X79X'' WHEN ([Extent2].[Discriminator] = 37) THEN ''2X80X'' WHEN
  51. ([Extent2].[Discriminator] = 33) THEN ''2X81X'' WHEN ([Extent2].[Discriminator] = 100) THEN ''2X82X'' WHEN
  52. ([Extent2].[Discriminator] = 306) THEN ''2X83X'' WHEN ([Extent2].[Discriminator] = 251) THEN ''2X84X'' WHEN
  53. ([Extent2].[Discriminator] = 304) THEN ''2X85X'' WHEN ([Extent2].[Discriminator] = 117) THEN ''2X86X'' WHEN
  54. ([Extent2].[Discriminator] = 86) THEN ''2X87X'' WHEN ([Extent2].[Discriminator] = 307) THEN ''2X88X'' WHEN
  55. ([Extent2].[Discriminator] = 214) THEN ''2X89X'' WHEN ([Extent2].[Discriminator] = 39) THEN ''2X90X'' WHEN
  56. ([Extent2].[Discriminator] = 65) THEN ''2X91X'' WHEN ([Extent2].[Discriminator] = 64) THEN ''2X92X'' WHEN
  57. ([Extent2].[Discriminator] = 66) THEN ''2X93X'' WHEN ([Extent2].[Discriminator] = 143) THEN ''2X94X'' WHEN
  58. ([Extent2].[Discriminator] = 67) THEN ''2X95X'' WHEN ([Extent2].[Discriminator] = 144) THEN ''2X96X'' WHEN
  59. ([Extent2].[Discriminator] = 5) THEN ''2X97X'' WHEN ([Extent2].[Discriminator] = 38) THEN ''2X98X'' WHEN ([Extent2].[Discriminator] = 83) THEN ''2X99X'' WHEN ([Extent2].[Discriminator] = 238) THEN ''2X100X'' WHEN ([Extent2].[Discriminator] = 310) THEN ''2X101X'' WHEN ([Extent2].[Discriminator] = 316) THEN ''2X102X'' WHEN ([Extent2].[Discriminator] = 309) THEN ''2X103X'' WHEN ([Extent2].[Discriminator] = 308) THEN ''2X104X'' WHEN ([Extent2].[Discriminator] = 314) THEN ''2X105X'' WHEN ([Extent2].[Discriminator] = 315) THEN ''2X106X'' WHEN ([Extent2].[Discriminator] = 313) THEN ''2X107X'' WHEN ([Extent2].[Discriminator] = 311) THEN ''2X108X'' WHEN ([Extent2].[Discriminator] = 312) THEN ''2X109X'' WHEN ([Extent2].[Discriminator] = 1) THEN ''2X110X'' WHEN
  60. ([Extent2].[Discriminator] = 317) THEN ''2X111X'' WHEN ([Extent2].[Discriminator] = 105) THEN ''2X112X'' WHEN ([Extent2].[Discriminator] = 152) THEN ''2X113X'' WHEN ([Extent2].[Discriminator] = 44) THEN ''2X114X'' WHEN ([Extent2].[Discriminator] = 45) THEN ''2X115X'' WHEN ([Extent2].[Discriminator] = 43) THEN ''2X116X'' WHEN ([Extent2].[Discriminator] = 405) THEN ''2X117X'' WHEN ([Extent2].[Discriminator] = 232) THEN ''2X118X'' WHEN ([Extent2].[Discriminator] = 305) THEN ''2X119X'' WHEN ([Extent2].[Discriminator] = 171) THEN ''2X120X'' WHEN ([Extent2].[Discriminator] = 6) THEN ''2X121X'' WHEN ([Extent2].[Discriminator] = 2) THEN ''2X122X'' WHEN ([Extent2].[Discriminator] = 88) THEN ''2X123X'' WHEN ([Extent2].[Discriminator] = 87) THEN ''2X124X'' WHEN ([Extent2].[Discriminator] = 121) THEN ''2X125X'' WHEN ([Extent2].[Discriminator] = 116) THEN ''2X126X'' WHEN ([Extent2].[Discriminator] = 34) THEN ''2X127X'' WHEN ([Extent2].[Discriminator] = 84) THEN ''2X128X'' WHEN ([Extent2].[Discriminator] = 7) THEN ''2X129X'' WHEN ([Extent2].[Discriminator] = 93) THEN ''2X130X'' WHEN ([Extent2].[Discriminator] = 289) THEN ''2X131X'' WHEN ([Extent2].[Discriminator] = 89) THEN ''2X132X'' ELSE ''2X133X'' END AS [C1],
  61.        CASE WHEN ([Extent2].[Id] IS NULL) THEN CAST(NULL AS int) ELSE 1 END AS [C2]
  62.        FROM   (SELECT TOP (1)
  63.            [Extent1].[Id] AS [Id]
  64.            FROM [dbo].[ListNames] AS [Extent1]
  65.            WHERE [Extent1].[Id] = @p__linq__0 ) AS [Limit1]
  66.        LEFT OUTER JOIN [v1].[ListValue] AS [Extent2] ON [Limit1].[Id] = [Extent2].[ListNameId]
  67.    )  AS [Project2]
  68.    ORDER BY [Project2].[Id] ASC, [Project2].[C2] ASC',N'@p__linq__0 int',@p__linq__0=1
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
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!