Guest User

Untitled

a guest
Oct 13th, 2016
209
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.60 KB | None | 0 0
  1. WITH TALLY
  2. AS (
  3. SELECT 1 N
  4. UNION ALL
  5. SELECT 2
  6. UNION ALL
  7. SELECT 3
  8. UNION ALL
  9. SELECT 4
  10. UNION ALL
  11. SELECT 5
  12. UNION ALL
  13. SELECT 6
  14. UNION ALL
  15. SELECT 7
  16. UNION ALL
  17. SELECT 8
  18. UNION ALL
  19. SELECT 9
  20. UNION ALL
  21. SELECT 10
  22. UNION ALL
  23. SELECT 11
  24. UNION ALL
  25. SELECT 12
  26. UNION ALL
  27. SELECT 13
  28. UNION ALL
  29. SELECT 14
  30. UNION ALL
  31. SELECT 15
  32. UNION ALL
  33. SELECT 16
  34. UNION ALL
  35. SELECT 17
  36. UNION ALL
  37. SELECT 18
  38. UNION ALL
  39. SELECT 19
  40. UNION ALL
  41. SELECT 20
  42. UNION ALL
  43. SELECT 21
  44. UNION ALL
  45. SELECT 22
  46. UNION ALL
  47. SELECT 23
  48. UNION ALL
  49. SELECT 24
  50. UNION ALL
  51. SELECT 25
  52. UNION ALL
  53. SELECT 26),
  54. DEUX
  55. AS (SELECT T1.N C1,
  56. T2.N C2
  57. FROM TALLY T1
  58. CROSS JOIN TALLY T2),
  59. TROIS
  60. AS (SELECT T1.C1,
  61. T1.C2 C2,
  62. T2.N C3
  63. FROM DEUX T1
  64. CROSS JOIN TALLY T2),
  65. QUATRE
  66. AS (SELECT T1.C1,
  67. T1.C2 C2,
  68. T1.C3 C3,
  69. T2.N C4
  70. FROM TROIS T1
  71. CROSS JOIN TALLY T2),
  72. T
  73. AS (
  74. SELECT CHAR(64+N) ALPHA
  75. FROM TALLY
  76. UNION ALL
  77. SELECT CHAR(64+C2) + CHAR(64+C1)
  78. FROM DEUX
  79. UNION ALL
  80. SELECT CHAR(64+C3) + CHAR(64+C2) + CHAR(64+C1)
  81. FROM TROIS
  82. UNION ALL
  83. SELECT CHAR(64+C4) + CHAR(64+C3) + CHAR(64+C2) + CHAR(64+C1)
  84. FROM QUATRE)
  85. SELECT *
  86. FROM T AS T1
Advertisement
Add Comment
Please, Sign In to add comment