Advertisement
Guest User

lots of self joins

a guest
Jul 20th, 2017
223
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 9.26 KB | None | 0 0
  1. Create table Test (Id int identity(1,1))
  2. GO
  3.  
  4. SELECT t1.Id
  5. FROM Test t1
  6. JOIN Test t2
  7. ON t1.Id = t2.Id
  8. JOIN Test t3
  9. ON t2.Id = t3.Id
  10. JOIN Test t4
  11. ON t3.Id = t4.Id
  12. JOIN Test t5
  13. ON t4.Id = t5.Id
  14. JOIN Test t6
  15. ON t5.Id = t6.Id
  16. JOIN Test t7
  17. ON t6.Id = t7.Id
  18. JOIN Test t8
  19. ON t7.Id = t8.Id
  20. JOIN Test t9
  21. ON t8.Id = t9.Id
  22. JOIN Test t10
  23. ON t9.Id = t10.Id
  24. JOIN Test t11
  25. ON t10.Id = t11.Id
  26. JOIN Test t12
  27. ON t11.Id = t12.Id
  28. JOIN Test t13
  29. ON t12.Id = t13.Id
  30. JOIN Test t14
  31. ON t13.Id = t14.Id
  32. JOIN Test t15
  33. ON t14.Id = t15.Id
  34. JOIN Test t16
  35. ON t15.Id = t16.Id
  36. JOIN Test t17
  37. ON t16.Id = t17.Id
  38. JOIN Test t18
  39. ON t17.Id = t18.Id
  40. JOIN Test t19
  41. ON t18.Id = t19.Id
  42. JOIN Test t20
  43. ON t19.Id = t20.Id
  44. JOIN Test t21
  45. ON t20.Id = t21.Id
  46. JOIN Test t22
  47. ON t21.Id = t22.Id
  48. JOIN Test t23
  49. ON t22.Id = t23.Id
  50. JOIN Test t24
  51. ON t23.Id = t24.Id
  52. JOIN Test t25
  53. ON t24.Id = t25.Id
  54. JOIN Test t26
  55. ON t25.Id = t26.Id
  56. JOIN Test t27
  57. ON t26.Id = t27.Id
  58. JOIN Test t28
  59. ON t27.Id = t28.Id
  60. JOIN Test t29
  61. ON t28.Id = t29.Id
  62. JOIN Test t30
  63. ON t29.Id = t30.Id
  64. JOIN Test t31
  65. ON t30.Id = t31.Id
  66. JOIN Test t32
  67. ON t31.Id = t32.Id
  68. JOIN Test t33
  69. ON t32.Id = t33.Id
  70. JOIN Test t34
  71. ON t33.Id = t34.Id
  72. JOIN Test t35
  73. ON t34.Id = t35.Id
  74. JOIN Test t36
  75. ON t35.Id = t36.Id
  76. JOIN Test t37
  77. ON t36.Id = t37.Id
  78. JOIN Test t38
  79. ON t37.Id = t38.Id
  80. JOIN Test t39
  81. ON t38.Id = t39.Id
  82. JOIN Test t40
  83. ON t39.Id = t40.Id
  84. JOIN Test t41
  85. ON t40.Id = t41.Id
  86. JOIN Test t42
  87. ON t41.Id = t42.Id
  88. JOIN Test t43
  89. ON t42.Id = t43.Id
  90. JOIN Test t44
  91. ON t43.Id = t44.Id
  92. JOIN Test t45
  93. ON t44.Id = t45.Id
  94. JOIN Test t46
  95. ON t45.Id = t46.Id
  96. JOIN Test t47
  97. ON t46.Id = t47.Id
  98. JOIN Test t48
  99. ON t47.Id = t48.Id
  100. JOIN Test t49
  101. ON t48.Id = t49.Id
  102. JOIN Test t50
  103. ON t49.Id = t50.Id
  104. JOIN Test t51
  105. ON t50.Id = t51.Id
  106. JOIN Test t52
  107. ON t51.Id = t52.Id
  108. JOIN Test t53
  109. ON t52.Id = t53.Id
  110. JOIN Test t54
  111. ON t53.Id = t54.Id
  112. JOIN Test t55
  113. ON t54.Id = t55.Id
  114. JOIN Test t56
  115. ON t55.Id = t56.Id
  116. JOIN Test t57
  117. ON t56.Id = t57.Id
  118. JOIN Test t58
  119. ON t57.Id = t58.Id
  120. JOIN Test t59
  121. ON t58.Id = t59.Id
  122. JOIN Test t60
  123. ON t59.Id = t60.Id
  124. JOIN Test t61
  125. ON t60.Id = t61.Id
  126. JOIN Test t62
  127. ON t61.Id = t62.Id
  128. JOIN Test t63
  129. ON t62.Id = t63.Id
  130. JOIN Test t64
  131. ON t63.Id = t64.Id
  132. JOIN Test t65
  133. ON t64.Id = t65.Id
  134. JOIN Test t66
  135. ON t65.Id = t66.Id
  136. JOIN Test t67
  137. ON t66.Id = t67.Id
  138. JOIN Test t68
  139. ON t67.Id = t68.Id
  140. JOIN Test t69
  141. ON t68.Id = t69.Id
  142. JOIN Test t70
  143. ON t69.Id = t70.Id
  144. JOIN Test t71
  145. ON t70.Id = t71.Id
  146. JOIN Test t72
  147. ON t71.Id = t72.Id
  148. JOIN Test t73
  149. ON t72.Id = t73.Id
  150. JOIN Test t74
  151. ON t73.Id = t74.Id
  152. JOIN Test t75
  153. ON t74.Id = t75.Id
  154. JOIN Test t76
  155. ON t75.Id = t76.Id
  156. JOIN Test t77
  157. ON t76.Id = t77.Id
  158. JOIN Test t78
  159. ON t77.Id = t78.Id
  160. JOIN Test t79
  161. ON t78.Id = t79.Id
  162. JOIN Test t80
  163. ON t79.Id = t80.Id
  164. JOIN Test t81
  165. ON t80.Id = t81.Id
  166. JOIN Test t82
  167. ON t81.Id = t82.Id
  168. JOIN Test t83
  169. ON t82.Id = t83.Id
  170. JOIN Test t84
  171. ON t83.Id = t84.Id
  172. JOIN Test t85
  173. ON t84.Id = t85.Id
  174. JOIN Test t86
  175. ON t85.Id = t86.Id
  176. JOIN Test t87
  177. ON t86.Id = t87.Id
  178. JOIN Test t88
  179. ON t87.Id = t88.Id
  180. JOIN Test t89
  181. ON t88.Id = t89.Id
  182. JOIN Test t90
  183. ON t89.Id = t90.Id
  184. JOIN Test t91
  185. ON t90.Id = t91.Id
  186. JOIN Test t92
  187. ON t91.Id = t92.Id
  188. JOIN Test t93
  189. ON t92.Id = t93.Id
  190. JOIN Test t94
  191. ON t93.Id = t94.Id
  192. JOIN Test t95
  193. ON t94.Id = t95.Id
  194. JOIN Test t96
  195. ON t95.Id = t96.Id
  196. JOIN Test t97
  197. ON t96.Id = t97.Id
  198. JOIN Test t98
  199. ON t97.Id = t98.Id
  200. JOIN Test t99
  201. ON t98.Id = t99.Id
  202. JOIN Test t100
  203. ON t99.Id = t100.Id
  204. JOIN Test t101
  205. ON t100.Id = t101.Id
  206. JOIN Test t102
  207. ON t101.Id = t102.Id
  208. JOIN Test t103
  209. ON t102.Id = t103.Id
  210. JOIN Test t104
  211. ON t103.Id = t104.Id
  212. JOIN Test t105
  213. ON t104.Id = t105.Id
  214. JOIN Test t106
  215. ON t105.Id = t106.Id
  216. JOIN Test t107
  217. ON t106.Id = t107.Id
  218. JOIN Test t108
  219. ON t107.Id = t108.Id
  220. JOIN Test t109
  221. ON t108.Id = t109.Id
  222. JOIN Test t110
  223. ON t109.Id = t110.Id
  224. JOIN Test t111
  225. ON t110.Id = t111.Id
  226. JOIN Test t112
  227. ON t111.Id = t112.Id
  228. JOIN Test t113
  229. ON t112.Id = t113.Id
  230. JOIN Test t114
  231. ON t113.Id = t114.Id
  232. JOIN Test t115
  233. ON t114.Id = t115.Id
  234. JOIN Test t116
  235. ON t115.Id = t116.Id
  236. JOIN Test t117
  237. ON t116.Id = t117.Id
  238. JOIN Test t118
  239. ON t117.Id = t118.Id
  240. JOIN Test t119
  241. ON t118.Id = t119.Id
  242. JOIN Test t120
  243. ON t119.Id = t120.Id
  244. JOIN Test t121
  245. ON t120.Id = t121.Id
  246. JOIN Test t122
  247. ON t121.Id = t122.Id
  248. JOIN Test t123
  249. ON t122.Id = t123.Id
  250. JOIN Test t124
  251. ON t123.Id = t124.Id
  252. JOIN Test t125
  253. ON t124.Id = t125.Id
  254. JOIN Test t126
  255. ON t125.Id = t126.Id
  256. JOIN Test t127
  257. ON t126.Id = t127.Id
  258. JOIN Test t128
  259. ON t127.Id = t128.Id
  260. JOIN Test t129
  261. ON t128.Id = t129.Id
  262. JOIN Test t130
  263. ON t129.Id = t130.Id
  264. JOIN Test t131
  265. ON t130.Id = t131.Id
  266. JOIN Test t132
  267. ON t131.Id = t132.Id
  268. JOIN Test t133
  269. ON t132.Id = t133.Id
  270. JOIN Test t134
  271. ON t133.Id = t134.Id
  272. JOIN Test t135
  273. ON t134.Id = t135.Id
  274. JOIN Test t136
  275. ON t135.Id = t136.Id
  276. JOIN Test t137
  277. ON t136.Id = t137.Id
  278. JOIN Test t138
  279. ON t137.Id = t138.Id
  280. JOIN Test t139
  281. ON t138.Id = t139.Id
  282. JOIN Test t140
  283. ON t139.Id = t140.Id
  284. JOIN Test t141
  285. ON t140.Id = t141.Id
  286. JOIN Test t142
  287. ON t141.Id = t142.Id
  288. JOIN Test t143
  289. ON t142.Id = t143.Id
  290. JOIN Test t144
  291. ON t143.Id = t144.Id
  292. JOIN Test t145
  293. ON t144.Id = t145.Id
  294. JOIN Test t146
  295. ON t145.Id = t146.Id
  296. JOIN Test t147
  297. ON t146.Id = t147.Id
  298. JOIN Test t148
  299. ON t147.Id = t148.Id
  300. JOIN Test t149
  301. ON t148.Id = t149.Id
  302. JOIN Test t150
  303. ON t149.Id = t150.Id
  304. JOIN Test t151
  305. ON t150.Id = t151.Id
  306. JOIN Test t152
  307. ON t151.Id = t152.Id
  308. JOIN Test t153
  309. ON t152.Id = t153.Id
  310. JOIN Test t154
  311. ON t153.Id = t154.Id
  312. JOIN Test t155
  313. ON t154.Id = t155.Id
  314. JOIN Test t156
  315. ON t155.Id = t156.Id
  316. JOIN Test t157
  317. ON t156.Id = t157.Id
  318. JOIN Test t158
  319. ON t157.Id = t158.Id
  320. JOIN Test t159
  321. ON t158.Id = t159.Id
  322. JOIN Test t160
  323. ON t159.Id = t160.Id
  324. JOIN Test t161
  325. ON t160.Id = t161.Id
  326. JOIN Test t162
  327. ON t161.Id = t162.Id
  328. JOIN Test t163
  329. ON t162.Id = t163.Id
  330. JOIN Test t164
  331. ON t163.Id = t164.Id
  332. JOIN Test t165
  333. ON t164.Id = t165.Id
  334. JOIN Test t166
  335. ON t165.Id = t166.Id
  336. JOIN Test t167
  337. ON t166.Id = t167.Id
  338. JOIN Test t168
  339. ON t167.Id = t168.Id
  340. JOIN Test t169
  341. ON t168.Id = t169.Id
  342. JOIN Test t170
  343. ON t169.Id = t170.Id
  344. JOIN Test t171
  345. ON t170.Id = t171.Id
  346. JOIN Test t172
  347. ON t171.Id = t172.Id
  348. JOIN Test t173
  349. ON t172.Id = t173.Id
  350. JOIN Test t174
  351. ON t173.Id = t174.Id
  352. JOIN Test t175
  353. ON t174.Id = t175.Id
  354. JOIN Test t176
  355. ON t175.Id = t176.Id
  356. JOIN Test t177
  357. ON t176.Id = t177.Id
  358. JOIN Test t178
  359. ON t177.Id = t178.Id
  360. JOIN Test t179
  361. ON t178.Id = t179.Id
  362. JOIN Test t180
  363. ON t179.Id = t180.Id
  364. JOIN Test t181
  365. ON t180.Id = t181.Id
  366. JOIN Test t182
  367. ON t181.Id = t182.Id
  368. JOIN Test t183
  369. ON t182.Id = t183.Id
  370. JOIN Test t184
  371. ON t183.Id = t184.Id
  372. JOIN Test t185
  373. ON t184.Id = t185.Id
  374. JOIN Test t186
  375. ON t185.Id = t186.Id
  376. JOIN Test t187
  377. ON t186.Id = t187.Id
  378. JOIN Test t188
  379. ON t187.Id = t188.Id
  380. JOIN Test t189
  381. ON t188.Id = t189.Id
  382. JOIN Test t190
  383. ON t189.Id = t190.Id
  384. JOIN Test t191
  385. ON t190.Id = t191.Id
  386. JOIN Test t192
  387. ON t191.Id = t192.Id
  388. JOIN Test t193
  389. ON t192.Id = t193.Id
  390. JOIN Test t194
  391. ON t193.Id = t194.Id
  392. JOIN Test t195
  393. ON t194.Id = t195.Id
  394. JOIN Test t196
  395. ON t195.Id = t196.Id
  396. JOIN Test t197
  397. ON t196.Id = t197.Id
  398. JOIN Test t198
  399. ON t197.Id = t198.Id
  400. JOIN Test t199
  401. ON t198.Id = t199.Id
  402. JOIN Test t200
  403. ON t199.Id = t200.Id
  404. JOIN Test t201
  405. ON t200.Id = t201.Id
  406. JOIN Test t202
  407. ON t201.Id = t202.Id
  408. JOIN Test t203
  409. ON t202.Id = t203.Id
  410. JOIN Test t204
  411. ON t203.Id = t204.Id
  412. JOIN Test t205
  413. ON t204.Id = t205.Id
  414. JOIN Test t206
  415. ON t205.Id = t206.Id
  416. JOIN Test t207
  417. ON t206.Id = t207.Id
  418. JOIN Test t208
  419. ON t207.Id = t208.Id
  420. JOIN Test t209
  421. ON t208.Id = t209.Id
  422. JOIN Test t210
  423. ON t209.Id = t210.Id
  424. JOIN Test t211
  425. ON t210.Id = t211.Id
  426. JOIN Test t212
  427. ON t211.Id = t212.Id
  428. JOIN Test t213
  429. ON t212.Id = t213.Id
  430. JOIN Test t214
  431. ON t213.Id = t214.Id
  432. JOIN Test t215
  433. ON t214.Id = t215.Id
  434. JOIN Test t216
  435. ON t215.Id = t216.Id
  436. JOIN Test t217
  437. ON t216.Id = t217.Id
  438. JOIN Test t218
  439. ON t217.Id = t218.Id
  440. JOIN Test t219
  441. ON t218.Id = t219.Id
  442. JOIN Test t220
  443. ON t219.Id = t220.Id
  444. JOIN Test t221
  445. ON t220.Id = t221.Id
  446. JOIN Test t222
  447. ON t221.Id = t222.Id
  448. JOIN Test t223
  449. ON t222.Id = t223.Id
  450. JOIN Test t224
  451. ON t223.Id = t224.Id
  452. JOIN Test t225
  453. ON t224.Id = t225.Id
  454. JOIN Test t226
  455. ON t225.Id = t226.Id
  456. JOIN Test t227
  457. ON t226.Id = t227.Id
  458. JOIN Test t228
  459. ON t227.Id = t228.Id
  460. JOIN Test t229
  461. ON t228.Id = t229.Id
  462. JOIN Test t230
  463. ON t229.Id = t230.Id
  464. JOIN Test t231
  465. ON t230.Id = t231.Id
  466. JOIN Test t232
  467. ON t231.Id = t232.Id
  468. JOIN Test t233
  469. ON t232.Id = t233.Id
  470. JOIN Test t234
  471. ON t233.Id = t234.Id
  472. JOIN Test t235
  473. ON t234.Id = t235.Id
  474. JOIN Test t236
  475. ON t235.Id = t236.Id
  476. JOIN Test t237
  477. ON t236.Id = t237.Id
  478. JOIN Test t238
  479. ON t237.Id = t238.Id
  480. JOIN Test t239
  481. ON t238.Id = t239.Id
  482. JOIN Test t240
  483. ON t239.Id = t240.Id
  484. JOIN Test t241
  485. ON t240.Id = t241.Id
  486. JOIN Test t242
  487. ON t241.Id = t242.Id
  488. JOIN Test t243
  489. ON t242.Id = t243.Id
  490. JOIN Test t244
  491. ON t243.Id = t244.Id
  492. JOIN Test t245
  493. ON t244.Id = t245.Id
  494. JOIN Test t246
  495. ON t245.Id = t246.Id
  496. JOIN Test t247
  497. ON t246.Id = t247.Id
  498. JOIN Test t248
  499. ON t247.Id = t248.Id
  500. JOIN Test t249
  501. ON t248.Id = t249.Id
  502. JOIN Test t250
  503. ON t249.Id = t250.Id
  504. JOIN Test t251
  505. ON t250.Id = t251.Id
  506. JOIN Test t252
  507. ON t251.Id = t252.Id
  508. JOIN Test t253
  509. ON t252.Id = t253.Id
  510. JOIN Test t254
  511. ON t253.Id = t254.Id
  512. JOIN Test t255
  513. ON t254.Id = t255.Id
  514. JOIN Test t256
  515. ON t255.Id = t256.Id
  516. JOIN Test t257
  517. ON t256.Id = t257.Id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement