Guest User

Untitled

a guest
Jan 19th, 2018
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 33.32 KB | None | 0 0
  1. DECLARE @Ids TABLE (
  2. Id VARCHAR(50)
  3. )
  4. INSERT INTO @Ids (Id)
  5. SELECT
  6. '5-14724'
  7. INSERT INTO @Ids (Id)
  8. SELECT
  9. '5-14726'
  10. INSERT INTO @Ids (Id)
  11. SELECT
  12. '5-14730'
  13. INSERT INTO @Ids (Id)
  14. SELECT
  15. '5-14732'
  16. INSERT INTO @Ids (Id)
  17. SELECT
  18. '5-14733'
  19. INSERT INTO @Ids (Id)
  20. SELECT
  21. '5-14734'
  22. INSERT INTO @Ids (Id)
  23. SELECT
  24. '5-14735'
  25. INSERT INTO @Ids (Id)
  26. SELECT
  27. '5-14739'
  28. INSERT INTO @Ids (Id)
  29. SELECT
  30. '5-14748'
  31. INSERT INTO @Ids (Id)
  32. SELECT
  33. '5-14750'
  34. INSERT INTO @Ids (Id)
  35. SELECT
  36. '5-14752'
  37. INSERT INTO @Ids (Id)
  38. SELECT
  39. '5-14765'
  40. INSERT INTO @Ids (Id)
  41. SELECT
  42. '5-14771'
  43. INSERT INTO @Ids (Id)
  44. SELECT
  45. '5-14773'
  46. INSERT INTO @Ids (Id)
  47. SELECT
  48. '5-14774'
  49. INSERT INTO @Ids (Id)
  50. SELECT
  51. '5-14775'
  52. INSERT INTO @Ids (Id)
  53. SELECT
  54. '5-14777'
  55. INSERT INTO @Ids (Id)
  56. SELECT
  57. '5-14778'
  58. INSERT INTO @Ids (Id)
  59. SELECT
  60. '5-14779'
  61. INSERT INTO @Ids (Id)
  62. SELECT
  63. '5-14781'
  64. INSERT INTO @Ids (Id)
  65. SELECT
  66. '5-14782'
  67. INSERT INTO @Ids (Id)
  68. SELECT
  69. '5-14784'
  70. INSERT INTO @Ids (Id)
  71. SELECT
  72. '5-14785'
  73. INSERT INTO @Ids (Id)
  74. SELECT
  75. '5-14787'
  76. INSERT INTO @Ids (Id)
  77. SELECT
  78. '5-14790'
  79. INSERT INTO @Ids (Id)
  80. SELECT
  81. '5-14793'
  82. INSERT INTO @Ids (Id)
  83. SELECT
  84. '5-14794'
  85. INSERT INTO @Ids (Id)
  86. SELECT
  87. '5-14799'
  88. INSERT INTO @Ids (Id)
  89. SELECT
  90. '5-14800'
  91. INSERT INTO @Ids (Id)
  92. SELECT
  93. '5-14803'
  94. INSERT INTO @Ids (Id)
  95. SELECT
  96. '5-14809'
  97. INSERT INTO @Ids (Id)
  98. SELECT
  99. '5-14812'
  100. INSERT INTO @Ids (Id)
  101. SELECT
  102. '5-14816'
  103. INSERT INTO @Ids (Id)
  104. SELECT
  105. '5-14818'
  106. INSERT INTO @Ids (Id)
  107. SELECT
  108. '5-14820'
  109. INSERT INTO @Ids (Id)
  110. SELECT
  111. '5-14821'
  112. INSERT INTO @Ids (Id)
  113. SELECT
  114. '5-14825'
  115. INSERT INTO @Ids (Id)
  116. SELECT
  117. '5-14828'
  118. INSERT INTO @Ids (Id)
  119. SELECT
  120. '5-14830'
  121. INSERT INTO @Ids (Id)
  122. SELECT
  123. '5-14835'
  124. INSERT INTO @Ids (Id)
  125. SELECT
  126. '5-14836'
  127. INSERT INTO @Ids (Id)
  128. SELECT
  129. '5-14837'
  130. INSERT INTO @Ids (Id)
  131. SELECT
  132. '5-14838'
  133. INSERT INTO @Ids (Id)
  134. SELECT
  135. '5-14841'
  136. INSERT INTO @Ids (Id)
  137. SELECT
  138. '5-14842'
  139. INSERT INTO @Ids (Id)
  140. SELECT
  141. '5-14844'
  142. INSERT INTO @Ids (Id)
  143. SELECT
  144. '5-14845'
  145. INSERT INTO @Ids (Id)
  146. SELECT
  147. '5-14846'
  148. INSERT INTO @Ids (Id)
  149. SELECT
  150. '5-14848'
  151. INSERT INTO @Ids (Id)
  152. SELECT
  153. '5-14849'
  154. INSERT INTO @Ids (Id)
  155. SELECT
  156. '5-14850'
  157. INSERT INTO @Ids (Id)
  158. SELECT
  159. '5-14851'
  160. INSERT INTO @Ids (Id)
  161. SELECT
  162. '5-14853'
  163. INSERT INTO @Ids (Id)
  164. SELECT
  165. '5-14857'
  166. INSERT INTO @Ids (Id)
  167. SELECT
  168. '5-14859'
  169. INSERT INTO @Ids (Id)
  170. SELECT
  171. '5-14860'
  172. INSERT INTO @Ids (Id)
  173. SELECT
  174. '5-14862'
  175. INSERT INTO @Ids (Id)
  176. SELECT
  177. '5-14863'
  178. INSERT INTO @Ids (Id)
  179. SELECT
  180. '5-14864'
  181. INSERT INTO @Ids (Id)
  182. SELECT
  183. '5-14868'
  184. INSERT INTO @Ids (Id)
  185. SELECT
  186. '5-14870'
  187. INSERT INTO @Ids (Id)
  188. SELECT
  189. '5-14876'
  190. INSERT INTO @Ids (Id)
  191. SELECT
  192. '5-14877'
  193. INSERT INTO @Ids (Id)
  194. SELECT
  195. '5-14878'
  196. INSERT INTO @Ids (Id)
  197. SELECT
  198. '5-14888'
  199. INSERT INTO @Ids (Id)
  200. SELECT
  201. '5-14889'
  202. INSERT INTO @Ids (Id)
  203. SELECT
  204. '5-14890'
  205. INSERT INTO @Ids (Id)
  206. SELECT
  207. '5-14892'
  208. INSERT INTO @Ids (Id)
  209. SELECT
  210. '5-14893'
  211. INSERT INTO @Ids (Id)
  212. SELECT
  213. '5-14895'
  214. INSERT INTO @Ids (Id)
  215. SELECT
  216. '5-14899'
  217. INSERT INTO @Ids (Id)
  218. SELECT
  219. '5-14903'
  220. INSERT INTO @Ids (Id)
  221. SELECT
  222. '5-14906'
  223. INSERT INTO @Ids (Id)
  224. SELECT
  225. '5-14914'
  226. INSERT INTO @Ids (Id)
  227. SELECT
  228. '5-14915'
  229. INSERT INTO @Ids (Id)
  230. SELECT
  231. '5-14917'
  232. INSERT INTO @Ids (Id)
  233. SELECT
  234. '5-14918'
  235. INSERT INTO @Ids (Id)
  236. SELECT
  237. '5-14919'
  238. INSERT INTO @Ids (Id)
  239. SELECT
  240. '5-14922'
  241. INSERT INTO @Ids (Id)
  242. SELECT
  243. '5-14930'
  244. INSERT INTO @Ids (Id)
  245. SELECT
  246. '5-14931'
  247. INSERT INTO @Ids (Id)
  248. SELECT
  249. '5-14938'
  250. INSERT INTO @Ids (Id)
  251. SELECT
  252. '5-14939'
  253. INSERT INTO @Ids (Id)
  254. SELECT
  255. '5-14940'
  256. INSERT INTO @Ids (Id)
  257. SELECT
  258. '5-14952'
  259. INSERT INTO @Ids (Id)
  260. SELECT
  261. '5-14954'
  262. INSERT INTO @Ids (Id)
  263. SELECT
  264. '5-14957'
  265. INSERT INTO @Ids (Id)
  266. SELECT
  267. '5-14958'
  268. INSERT INTO @Ids (Id)
  269. SELECT
  270. '5-14960'
  271. INSERT INTO @Ids (Id)
  272. SELECT
  273. '5-14962'
  274. INSERT INTO @Ids (Id)
  275. SELECT
  276. '5-14965'
  277. INSERT INTO @Ids (Id)
  278. SELECT
  279. '5-14966'
  280. INSERT INTO @Ids (Id)
  281. SELECT
  282. '5-14967'
  283. INSERT INTO @Ids (Id)
  284. SELECT
  285. '5-14968'
  286. INSERT INTO @Ids (Id)
  287. SELECT
  288. '5-14970'
  289. INSERT INTO @Ids (Id)
  290. SELECT
  291. '5-14971'
  292. INSERT INTO @Ids (Id)
  293. SELECT
  294. '5-14972'
  295. INSERT INTO @Ids (Id)
  296. SELECT
  297. '5-14973'
  298. INSERT INTO @Ids (Id)
  299. SELECT
  300. '5-14974'
  301. INSERT INTO @Ids (Id)
  302. SELECT
  303. '5-14977'
  304. INSERT INTO @Ids (Id)
  305. SELECT
  306. '5-14979'
  307. INSERT INTO @Ids (Id)
  308. SELECT
  309. '5-14980'
  310. INSERT INTO @Ids (Id)
  311. SELECT
  312. '5-14983'
  313. INSERT INTO @Ids (Id)
  314. SELECT
  315. '5-14986'
  316. INSERT INTO @Ids (Id)
  317. SELECT
  318. '5-14991'
  319. INSERT INTO @Ids (Id)
  320. SELECT
  321. '5-14992'
  322. INSERT INTO @Ids (Id)
  323. SELECT
  324. '5-14993'
  325. INSERT INTO @Ids (Id)
  326. SELECT
  327. '5-14994'
  328. INSERT INTO @Ids (Id)
  329. SELECT
  330. '5-14995'
  331. INSERT INTO @Ids (Id)
  332. SELECT
  333. '5-14996'
  334. INSERT INTO @Ids (Id)
  335. SELECT
  336. '5-14997'
  337. INSERT INTO @Ids (Id)
  338. SELECT
  339. '5-14998'
  340. INSERT INTO @Ids (Id)
  341. SELECT
  342. '5-14999'
  343. INSERT INTO @Ids (Id)
  344. SELECT
  345. '5-15000'
  346. INSERT INTO @Ids (Id)
  347. SELECT
  348. '5-15001'
  349. INSERT INTO @Ids (Id)
  350. SELECT
  351. '5-15002'
  352. INSERT INTO @Ids (Id)
  353. SELECT
  354. '5-15003'
  355. INSERT INTO @Ids (Id)
  356. SELECT
  357. '5-15004'
  358. INSERT INTO @Ids (Id)
  359. SELECT
  360. '5-15005'
  361. INSERT INTO @Ids (Id)
  362. SELECT
  363. '5-15006'
  364. INSERT INTO @Ids (Id)
  365. SELECT
  366. '5-15007'
  367. INSERT INTO @Ids (Id)
  368. SELECT
  369. '5-15008'
  370. INSERT INTO @Ids (Id)
  371. SELECT
  372. '5-15009'
  373. INSERT INTO @Ids (Id)
  374. SELECT
  375. '5-15010'
  376. INSERT INTO @Ids (Id)
  377. SELECT
  378. '5-15011'
  379. INSERT INTO @Ids (Id)
  380. SELECT
  381. '5-15012'
  382. INSERT INTO @Ids (Id)
  383. SELECT
  384. '5-15013'
  385. INSERT INTO @Ids (Id)
  386. SELECT
  387. '5-15014'
  388. INSERT INTO @Ids (Id)
  389. SELECT
  390. '5-15015'
  391. INSERT INTO @Ids (Id)
  392. SELECT
  393. '5-15016'
  394. INSERT INTO @Ids (Id)
  395. SELECT
  396. '5-15017'
  397. INSERT INTO @Ids (Id)
  398. SELECT
  399. '5-15486'
  400. INSERT INTO @Ids (Id)
  401. SELECT
  402. '5-15487'
  403. INSERT INTO @Ids (Id)
  404. SELECT
  405. '5-15492'
  406. INSERT INTO @Ids (Id)
  407. SELECT
  408. '5-15494'
  409. INSERT INTO @Ids (Id)
  410. SELECT
  411. '5-15495'
  412. INSERT INTO @Ids (Id)
  413. SELECT
  414. '5-15496'
  415. INSERT INTO @Ids (Id)
  416. SELECT
  417. '5-15498'
  418. INSERT INTO @Ids (Id)
  419. SELECT
  420. '5-15502'
  421. INSERT INTO @Ids (Id)
  422. SELECT
  423. '5-15504'
  424. INSERT INTO @Ids (Id)
  425. SELECT
  426. '5-15505'
  427. INSERT INTO @Ids (Id)
  428. SELECT
  429. '5-15507'
  430. INSERT INTO @Ids (Id)
  431. SELECT
  432. '5-15509'
  433. INSERT INTO @Ids (Id)
  434. SELECT
  435. '5-15513'
  436. INSERT INTO @Ids (Id)
  437. SELECT
  438. '5-15521'
  439. INSERT INTO @Ids (Id)
  440. SELECT
  441. '5-15523'
  442. INSERT INTO @Ids (Id)
  443. SELECT
  444. '5-15526'
  445. INSERT INTO @Ids (Id)
  446. SELECT
  447. '5-15527'
  448. INSERT INTO @Ids (Id)
  449. SELECT
  450. '5-15529'
  451. INSERT INTO @Ids (Id)
  452. SELECT
  453. '5-15530'
  454. INSERT INTO @Ids (Id)
  455. SELECT
  456. '5-15533'
  457. INSERT INTO @Ids (Id)
  458. SELECT
  459. '5-15536'
  460. INSERT INTO @Ids (Id)
  461. SELECT
  462. '5-15537'
  463. INSERT INTO @Ids (Id)
  464. SELECT
  465. '5-15538'
  466. INSERT INTO @Ids (Id)
  467. SELECT
  468. '5-15540'
  469. INSERT INTO @Ids (Id)
  470. SELECT
  471. '5-15543'
  472. INSERT INTO @Ids (Id)
  473. SELECT
  474. '5-15547'
  475. INSERT INTO @Ids (Id)
  476. SELECT
  477. '5-15548'
  478. INSERT INTO @Ids (Id)
  479. SELECT
  480. '5-15549'
  481. INSERT INTO @Ids (Id)
  482. SELECT
  483. '5-15551'
  484. INSERT INTO @Ids (Id)
  485. SELECT
  486. '5-15552'
  487. INSERT INTO @Ids (Id)
  488. SELECT
  489. '5-15554'
  490. INSERT INTO @Ids (Id)
  491. SELECT
  492. '5-15558'
  493. INSERT INTO @Ids (Id)
  494. SELECT
  495. '5-15559'
  496. INSERT INTO @Ids (Id)
  497. SELECT
  498. '5-15560'
  499. INSERT INTO @Ids (Id)
  500. SELECT
  501. '5-15561'
  502. INSERT INTO @Ids (Id)
  503. SELECT
  504. '5-15562'
  505. INSERT INTO @Ids (Id)
  506. SELECT
  507. '5-15563'
  508. INSERT INTO @Ids (Id)
  509. SELECT
  510. '5-15564'
  511. INSERT INTO @Ids (Id)
  512. SELECT
  513. '5-15568'
  514. INSERT INTO @Ids (Id)
  515. SELECT
  516. '5-15569'
  517. INSERT INTO @Ids (Id)
  518. SELECT
  519. '5-15571'
  520. INSERT INTO @Ids (Id)
  521. SELECT
  522. '5-15572'
  523. INSERT INTO @Ids (Id)
  524. SELECT
  525. '5-15573'
  526. INSERT INTO @Ids (Id)
  527. SELECT
  528. '5-15574'
  529. INSERT INTO @Ids (Id)
  530. SELECT
  531. '5-15575'
  532. INSERT INTO @Ids (Id)
  533. SELECT
  534. '5-15579'
  535. INSERT INTO @Ids (Id)
  536. SELECT
  537. '5-15580'
  538. INSERT INTO @Ids (Id)
  539. SELECT
  540. '5-15581'
  541. INSERT INTO @Ids (Id)
  542. SELECT
  543. '5-15583'
  544. INSERT INTO @Ids (Id)
  545. SELECT
  546. '5-15584'
  547. INSERT INTO @Ids (Id)
  548. SELECT
  549. '5-15585'
  550. INSERT INTO @Ids (Id)
  551. SELECT
  552. '5-15586'
  553. INSERT INTO @Ids (Id)
  554. SELECT
  555. '5-15587'
  556. INSERT INTO @Ids (Id)
  557. SELECT
  558. '5-15588'
  559. INSERT INTO @Ids (Id)
  560. SELECT
  561. '5-15591'
  562. INSERT INTO @Ids (Id)
  563. SELECT
  564. '5-15592'
  565. INSERT INTO @Ids (Id)
  566. SELECT
  567. '5-15593'
  568. INSERT INTO @Ids (Id)
  569. SELECT
  570. '5-15595'
  571. INSERT INTO @Ids (Id)
  572. SELECT
  573. '5-15596'
  574. INSERT INTO @Ids (Id)
  575. SELECT
  576. '5-15597'
  577. INSERT INTO @Ids (Id)
  578. SELECT
  579. '5-15599'
  580. INSERT INTO @Ids (Id)
  581. SELECT
  582. '5-15600'
  583. INSERT INTO @Ids (Id)
  584. SELECT
  585. '5-15601'
  586. INSERT INTO @Ids (Id)
  587. SELECT
  588. '5-15603'
  589. INSERT INTO @Ids (Id)
  590. SELECT
  591. '5-15604'
  592. INSERT INTO @Ids (Id)
  593. SELECT
  594. '5-15607'
  595. INSERT INTO @Ids (Id)
  596. SELECT
  597. '5-15608'
  598. INSERT INTO @Ids (Id)
  599. SELECT
  600. '5-15611'
  601. INSERT INTO @Ids (Id)
  602. SELECT
  603. '5-15612'
  604. INSERT INTO @Ids (Id)
  605. SELECT
  606. '5-15614'
  607. INSERT INTO @Ids (Id)
  608. SELECT
  609. '5-15615'
  610. INSERT INTO @Ids (Id)
  611. SELECT
  612. '5-15617'
  613. INSERT INTO @Ids (Id)
  614. SELECT
  615. '5-15619'
  616. INSERT INTO @Ids (Id)
  617. SELECT
  618. '5-15621'
  619. INSERT INTO @Ids (Id)
  620. SELECT
  621. '5-15628'
  622. INSERT INTO @Ids (Id)
  623. SELECT
  624. '5-15630'
  625. INSERT INTO @Ids (Id)
  626. SELECT
  627. '5-15640'
  628. INSERT INTO @Ids (Id)
  629. SELECT
  630. '5-15642'
  631. INSERT INTO @Ids (Id)
  632. SELECT
  633. '5-15645'
  634. INSERT INTO @Ids (Id)
  635. SELECT
  636. '5-15647'
  637. INSERT INTO @Ids (Id)
  638. SELECT
  639. '5-15651'
  640. INSERT INTO @Ids (Id)
  641. SELECT
  642. '5-15662'
  643. INSERT INTO @Ids (Id)
  644. SELECT
  645. '5-15664'
  646. INSERT INTO @Ids (Id)
  647. SELECT
  648. '5-15666'
  649. INSERT INTO @Ids (Id)
  650. SELECT
  651. '5-15668'
  652. INSERT INTO @Ids (Id)
  653. SELECT
  654. '5-15671'
  655. INSERT INTO @Ids (Id)
  656. SELECT
  657. '5-15673'
  658. INSERT INTO @Ids (Id)
  659. SELECT
  660. '5-15675'
  661. INSERT INTO @Ids (Id)
  662. SELECT
  663. '5-15677'
  664. INSERT INTO @Ids (Id)
  665. SELECT
  666. '5-15678'
  667. INSERT INTO @Ids (Id)
  668. SELECT
  669. '5-15680'
  670. INSERT INTO @Ids (Id)
  671. SELECT
  672. '5-16038'
  673. INSERT INTO @Ids (Id)
  674. SELECT
  675. '5-16040'
  676. INSERT INTO @Ids (Id)
  677. SELECT
  678. '5-16041'
  679. INSERT INTO @Ids (Id)
  680. SELECT
  681. '5-16042'
  682. INSERT INTO @Ids (Id)
  683. SELECT
  684. '5-16044'
  685. INSERT INTO @Ids (Id)
  686. SELECT
  687. '5-16045'
  688. INSERT INTO @Ids (Id)
  689. SELECT
  690. '5-16047'
  691. INSERT INTO @Ids (Id)
  692. SELECT
  693. '5-16049'
  694. INSERT INTO @Ids (Id)
  695. SELECT
  696. '5-16050'
  697. INSERT INTO @Ids (Id)
  698. SELECT
  699. '5-16057'
  700. INSERT INTO @Ids (Id)
  701. SELECT
  702. '5-16062'
  703. INSERT INTO @Ids (Id)
  704. SELECT
  705. '5-16063'
  706. INSERT INTO @Ids (Id)
  707. SELECT
  708. '5-16065'
  709. INSERT INTO @Ids (Id)
  710. SELECT
  711. '5-16067'
  712. INSERT INTO @Ids (Id)
  713. SELECT
  714. '5-16069'
  715. INSERT INTO @Ids (Id)
  716. SELECT
  717. '5-16070'
  718. INSERT INTO @Ids (Id)
  719. SELECT
  720. '5-16074'
  721. INSERT INTO @Ids (Id)
  722. SELECT
  723. '5-16075'
  724. INSERT INTO @Ids (Id)
  725. SELECT
  726. '5-16080'
  727. INSERT INTO @Ids (Id)
  728. SELECT
  729. '5-16082'
  730. INSERT INTO @Ids (Id)
  731. SELECT
  732. '5-16083'
  733. INSERT INTO @Ids (Id)
  734. SELECT
  735. '5-16084'
  736. INSERT INTO @Ids (Id)
  737. SELECT
  738. '5-16085'
  739. INSERT INTO @Ids (Id)
  740. SELECT
  741. '5-16086'
  742. INSERT INTO @Ids (Id)
  743. SELECT
  744. '5-16087'
  745. INSERT INTO @Ids (Id)
  746. SELECT
  747. '5-16089'
  748. INSERT INTO @Ids (Id)
  749. SELECT
  750. '5-16092'
  751. INSERT INTO @Ids (Id)
  752. SELECT
  753. '5-16093'
  754. INSERT INTO @Ids (Id)
  755. SELECT
  756. '5-16098'
  757. INSERT INTO @Ids (Id)
  758. SELECT
  759. '5-16099'
  760. INSERT INTO @Ids (Id)
  761. SELECT
  762. '5-16100'
  763. INSERT INTO @Ids (Id)
  764. SELECT
  765. '5-16101'
  766. INSERT INTO @Ids (Id)
  767. SELECT
  768. '5-16105'
  769. INSERT INTO @Ids (Id)
  770. SELECT
  771. '5-16106'
  772. INSERT INTO @Ids (Id)
  773. SELECT
  774. '5-16108'
  775. INSERT INTO @Ids (Id)
  776. SELECT
  777. '5-16109'
  778. INSERT INTO @Ids (Id)
  779. SELECT
  780. '5-16110'
  781. INSERT INTO @Ids (Id)
  782. SELECT
  783. '5-16111'
  784. INSERT INTO @Ids (Id)
  785. SELECT
  786. '5-16112'
  787. INSERT INTO @Ids (Id)
  788. SELECT
  789. '5-16113'
  790. INSERT INTO @Ids (Id)
  791. SELECT
  792. '5-16116'
  793. INSERT INTO @Ids (Id)
  794. SELECT
  795. '5-16117'
  796. INSERT INTO @Ids (Id)
  797. SELECT
  798. '5-16118'
  799. INSERT INTO @Ids (Id)
  800. SELECT
  801. '5-16119'
  802. INSERT INTO @Ids (Id)
  803. SELECT
  804. '5-16120'
  805. INSERT INTO @Ids (Id)
  806. SELECT
  807. '5-16121'
  808. INSERT INTO @Ids (Id)
  809. SELECT
  810. '5-16122'
  811. INSERT INTO @Ids (Id)
  812. SELECT
  813. '5-16124'
  814. INSERT INTO @Ids (Id)
  815. SELECT
  816. '5-16125'
  817. INSERT INTO @Ids (Id)
  818. SELECT
  819. '5-16126'
  820. INSERT INTO @Ids (Id)
  821. SELECT
  822. '5-16127'
  823. INSERT INTO @Ids (Id)
  824. SELECT
  825. '5-16128'
  826. INSERT INTO @Ids (Id)
  827. SELECT
  828. '5-16129'
  829. INSERT INTO @Ids (Id)
  830. SELECT
  831. '5-16130'
  832. INSERT INTO @Ids (Id)
  833. SELECT
  834. '5-16134'
  835. INSERT INTO @Ids (Id)
  836. SELECT
  837. '5-16136'
  838. INSERT INTO @Ids (Id)
  839. SELECT
  840. '5-16137'
  841. INSERT INTO @Ids (Id)
  842. SELECT
  843. '5-16138'
  844. INSERT INTO @Ids (Id)
  845. SELECT
  846. '5-16139'
  847. INSERT INTO @Ids (Id)
  848. SELECT
  849. '5-16147'
  850. INSERT INTO @Ids (Id)
  851. SELECT
  852. '5-16149'
  853. INSERT INTO @Ids (Id)
  854. SELECT
  855. '5-16150'
  856. INSERT INTO @Ids (Id)
  857. SELECT
  858. '5-16152'
  859. INSERT INTO @Ids (Id)
  860. SELECT
  861. '5-16155'
  862. INSERT INTO @Ids (Id)
  863. SELECT
  864. '5-16156'
  865. INSERT INTO @Ids (Id)
  866. SELECT
  867. '5-16157'
  868. INSERT INTO @Ids (Id)
  869. SELECT
  870. '5-16158'
  871. INSERT INTO @Ids (Id)
  872. SELECT
  873. '5-16160'
  874. INSERT INTO @Ids (Id)
  875. SELECT
  876. '5-16161'
  877. INSERT INTO @Ids (Id)
  878. SELECT
  879. '5-16162'
  880. INSERT INTO @Ids (Id)
  881. SELECT
  882. '5-16163'
  883. INSERT INTO @Ids (Id)
  884. SELECT
  885. '5-16171'
  886. INSERT INTO @Ids (Id)
  887. SELECT
  888. '5-16172'
  889. INSERT INTO @Ids (Id)
  890. SELECT
  891. '5-16173'
  892. INSERT INTO @Ids (Id)
  893. SELECT
  894. '5-16174'
  895. INSERT INTO @Ids (Id)
  896. SELECT
  897. '5-16176'
  898. INSERT INTO @Ids (Id)
  899. SELECT
  900. '5-16177'
  901. INSERT INTO @Ids (Id)
  902. SELECT
  903. '5-16178'
  904. INSERT INTO @Ids (Id)
  905. SELECT
  906. '5-16179'
  907. INSERT INTO @Ids (Id)
  908. SELECT
  909. '5-16180'
  910. INSERT INTO @Ids (Id)
  911. SELECT
  912. '5-16182'
  913. INSERT INTO @Ids (Id)
  914. SELECT
  915. '5-16183'
  916. INSERT INTO @Ids (Id)
  917. SELECT
  918. '5-16185'
  919. INSERT INTO @Ids (Id)
  920. SELECT
  921. '5-16187'
  922. INSERT INTO @Ids (Id)
  923. SELECT
  924. '5-16188'
  925. INSERT INTO @Ids (Id)
  926. SELECT
  927. '5-16189'
  928. INSERT INTO @Ids (Id)
  929. SELECT
  930. '5-16190'
  931. INSERT INTO @Ids (Id)
  932. SELECT
  933. '5-16191'
  934. INSERT INTO @Ids (Id)
  935. SELECT
  936. '5-16195'
  937. INSERT INTO @Ids (Id)
  938. SELECT
  939. '5-16196'
  940. INSERT INTO @Ids (Id)
  941. SELECT
  942. '5-16197'
  943. INSERT INTO @Ids (Id)
  944. SELECT
  945. '5-16198'
  946. INSERT INTO @Ids (Id)
  947. SELECT
  948. '5-16201'
  949. INSERT INTO @Ids (Id)
  950. SELECT
  951. '5-16205'
  952. INSERT INTO @Ids (Id)
  953. SELECT
  954. '5-16209'
  955. INSERT INTO @Ids (Id)
  956. SELECT
  957. '5-16210'
  958. INSERT INTO @Ids (Id)
  959. SELECT
  960. '5-16211'
  961. INSERT INTO @Ids (Id)
  962. SELECT
  963. '5-16212'
  964. INSERT INTO @Ids (Id)
  965. SELECT
  966. '5-16214'
  967. INSERT INTO @Ids (Id)
  968. SELECT
  969. '5-16215'
  970. INSERT INTO @Ids (Id)
  971. SELECT
  972. '5-16216'
  973. INSERT INTO @Ids (Id)
  974. SELECT
  975. '5-16217'
  976. INSERT INTO @Ids (Id)
  977. SELECT
  978. '5-16218'
  979. INSERT INTO @Ids (Id)
  980. SELECT
  981. '5-16220'
  982. INSERT INTO @Ids (Id)
  983. SELECT
  984. '5-16221'
  985. INSERT INTO @Ids (Id)
  986. SELECT
  987. '5-16222'
  988. INSERT INTO @Ids (Id)
  989. SELECT
  990. '5-16223'
  991. INSERT INTO @Ids (Id)
  992. SELECT
  993. '5-16230'
  994. INSERT INTO @Ids (Id)
  995. SELECT
  996. '5-16231'
  997. INSERT INTO @Ids (Id)
  998. SELECT
  999. '5-16232'
  1000. INSERT INTO @Ids (Id)
  1001. SELECT
  1002. '5-16233'
  1003. INSERT INTO @Ids (Id)
  1004. SELECT
  1005. '5-16563'
  1006. INSERT INTO @Ids (Id)
  1007. SELECT
  1008. '5-16565'
  1009. INSERT INTO @Ids (Id)
  1010. SELECT
  1011. '5-16568'
  1012. INSERT INTO @Ids (Id)
  1013. SELECT
  1014. '5-16569'
  1015. INSERT INTO @Ids (Id)
  1016. SELECT
  1017. '5-16571'
  1018. INSERT INTO @Ids (Id)
  1019. SELECT
  1020. '5-16572'
  1021. INSERT INTO @Ids (Id)
  1022. SELECT
  1023. '5-16573'
  1024. INSERT INTO @Ids (Id)
  1025. SELECT
  1026. '5-16574'
  1027. INSERT INTO @Ids (Id)
  1028. SELECT
  1029. '5-16581'
  1030. INSERT INTO @Ids (Id)
  1031. SELECT
  1032. '5-16583'
  1033. INSERT INTO @Ids (Id)
  1034. SELECT
  1035. '5-16587'
  1036. INSERT INTO @Ids (Id)
  1037. SELECT
  1038. '5-16588'
  1039. INSERT INTO @Ids (Id)
  1040. SELECT
  1041. '5-16591'
  1042. INSERT INTO @Ids (Id)
  1043. SELECT
  1044. '5-16596'
  1045. INSERT INTO @Ids (Id)
  1046. SELECT
  1047. '5-16597'
  1048. INSERT INTO @Ids (Id)
  1049. SELECT
  1050. '5-16599'
  1051. INSERT INTO @Ids (Id)
  1052. SELECT
  1053. '5-16602'
  1054. INSERT INTO @Ids (Id)
  1055. SELECT
  1056. '5-16604'
  1057. INSERT INTO @Ids (Id)
  1058. SELECT
  1059. '5-16605'
  1060. INSERT INTO @Ids (Id)
  1061. SELECT
  1062. '5-16611'
  1063. INSERT INTO @Ids (Id)
  1064. SELECT
  1065. '5-16617'
  1066. INSERT INTO @Ids (Id)
  1067. SELECT
  1068. '5-16618'
  1069. INSERT INTO @Ids (Id)
  1070. SELECT
  1071. '5-16620'
  1072. INSERT INTO @Ids (Id)
  1073. SELECT
  1074. '5-16621'
  1075. INSERT INTO @Ids (Id)
  1076. SELECT
  1077. '5-16624'
  1078. INSERT INTO @Ids (Id)
  1079. SELECT
  1080. '5-16625'
  1081. INSERT INTO @Ids (Id)
  1082. SELECT
  1083. '5-16627'
  1084. INSERT INTO @Ids (Id)
  1085. SELECT
  1086. '5-16630'
  1087. INSERT INTO @Ids (Id)
  1088. SELECT
  1089. '5-16631'
  1090. INSERT INTO @Ids (Id)
  1091. SELECT
  1092. '5-16632'
  1093. INSERT INTO @Ids (Id)
  1094. SELECT
  1095. '5-16635'
  1096. INSERT INTO @Ids (Id)
  1097. SELECT
  1098. '5-16636'
  1099. INSERT INTO @Ids (Id)
  1100. SELECT
  1101. '5-16637'
  1102. INSERT INTO @Ids (Id)
  1103. SELECT
  1104. '5-16638'
  1105. INSERT INTO @Ids (Id)
  1106. SELECT
  1107. '5-16642'
  1108. INSERT INTO @Ids (Id)
  1109. SELECT
  1110. '5-16644'
  1111. INSERT INTO @Ids (Id)
  1112. SELECT
  1113. '5-16645'
  1114. INSERT INTO @Ids (Id)
  1115. SELECT
  1116. '5-16646'
  1117. INSERT INTO @Ids (Id)
  1118. SELECT
  1119. '5-16647'
  1120. INSERT INTO @Ids (Id)
  1121. SELECT
  1122. '5-16648'
  1123. INSERT INTO @Ids (Id)
  1124. SELECT
  1125. '5-16649'
  1126. INSERT INTO @Ids (Id)
  1127. SELECT
  1128. '5-16651'
  1129. INSERT INTO @Ids (Id)
  1130. SELECT
  1131. '5-16652'
  1132. INSERT INTO @Ids (Id)
  1133. SELECT
  1134. '5-16655'
  1135. INSERT INTO @Ids (Id)
  1136. SELECT
  1137. '5-16658'
  1138. INSERT INTO @Ids (Id)
  1139. SELECT
  1140. '5-16660'
  1141. INSERT INTO @Ids (Id)
  1142. SELECT
  1143. '5-16661'
  1144. INSERT INTO @Ids (Id)
  1145. SELECT
  1146. '5-16662'
  1147. INSERT INTO @Ids (Id)
  1148. SELECT
  1149. '5-16665'
  1150. INSERT INTO @Ids (Id)
  1151. SELECT
  1152. '5-16666'
  1153. INSERT INTO @Ids (Id)
  1154. SELECT
  1155. '5-16670'
  1156. INSERT INTO @Ids (Id)
  1157. SELECT
  1158. '5-16671'
  1159. INSERT INTO @Ids (Id)
  1160. SELECT
  1161. '5-16672'
  1162. INSERT INTO @Ids (Id)
  1163. SELECT
  1164. '5-16674'
  1165. INSERT INTO @Ids (Id)
  1166. SELECT
  1167. '5-16675'
  1168. INSERT INTO @Ids (Id)
  1169. SELECT
  1170. '5-16677'
  1171. INSERT INTO @Ids (Id)
  1172. SELECT
  1173. '5-16679'
  1174. INSERT INTO @Ids (Id)
  1175. SELECT
  1176. '5-16681'
  1177. INSERT INTO @Ids (Id)
  1178. SELECT
  1179. '5-16690'
  1180. INSERT INTO @Ids (Id)
  1181. SELECT
  1182. '5-16694'
  1183. INSERT INTO @Ids (Id)
  1184. SELECT
  1185. '5-16699'
  1186. INSERT INTO @Ids (Id)
  1187. SELECT
  1188. '5-16701'
  1189. INSERT INTO @Ids (Id)
  1190. SELECT
  1191. '5-16702'
  1192. INSERT INTO @Ids (Id)
  1193. SELECT
  1194. '5-16704'
  1195. INSERT INTO @Ids (Id)
  1196. SELECT
  1197. '5-16707'
  1198. INSERT INTO @Ids (Id)
  1199. SELECT
  1200. '5-16712'
  1201. INSERT INTO @Ids (Id)
  1202. SELECT
  1203. '5-16713'
  1204. INSERT INTO @Ids (Id)
  1205. SELECT
  1206. '5-16715'
  1207. INSERT INTO @Ids (Id)
  1208. SELECT
  1209. '5-16717'
  1210. INSERT INTO @Ids (Id)
  1211. SELECT
  1212. '5-16720'
  1213. INSERT INTO @Ids (Id)
  1214. SELECT
  1215. '5-16723'
  1216. INSERT INTO @Ids (Id)
  1217. SELECT
  1218. '5-16724'
  1219. INSERT INTO @Ids (Id)
  1220. SELECT
  1221. '5-16725'
  1222. INSERT INTO @Ids (Id)
  1223. SELECT
  1224. '5-16726'
  1225. INSERT INTO @Ids (Id)
  1226. SELECT
  1227. '5-16729'
  1228. INSERT INTO @Ids (Id)
  1229. SELECT
  1230. '5-16731'
  1231. INSERT INTO @Ids (Id)
  1232. SELECT
  1233. '5-16732'
  1234. INSERT INTO @Ids (Id)
  1235. SELECT
  1236. '5-16734'
  1237. INSERT INTO @Ids (Id)
  1238. SELECT
  1239. '5-16735'
  1240. INSERT INTO @Ids (Id)
  1241. SELECT
  1242. '5-16740'
  1243. INSERT INTO @Ids (Id)
  1244. SELECT
  1245. '5-16741'
  1246. INSERT INTO @Ids (Id)
  1247. SELECT
  1248. '5-16745'
  1249. INSERT INTO @Ids (Id)
  1250. SELECT
  1251. '5-16753'
  1252. INSERT INTO @Ids (Id)
  1253. SELECT
  1254. '5-16754'
  1255. INSERT INTO @Ids (Id)
  1256. SELECT
  1257. '5-16756'
  1258. INSERT INTO @Ids (Id)
  1259. SELECT
  1260. '5-16757'
  1261. INSERT INTO @Ids (Id)
  1262. SELECT
  1263. '5-16761'
  1264. INSERT INTO @Ids (Id)
  1265. SELECT
  1266. '5-17083'
  1267. INSERT INTO @Ids (Id)
  1268. SELECT
  1269. '5-17086'
  1270. INSERT INTO @Ids (Id)
  1271. SELECT
  1272. '5-17087'
  1273. INSERT INTO @Ids (Id)
  1274. SELECT
  1275. '5-17090'
  1276. INSERT INTO @Ids (Id)
  1277. SELECT
  1278. '5-17091'
  1279. INSERT INTO @Ids (Id)
  1280. SELECT
  1281. '5-17092'
  1282. INSERT INTO @Ids (Id)
  1283. SELECT
  1284. '5-17093'
  1285. INSERT INTO @Ids (Id)
  1286. SELECT
  1287. '5-17096'
  1288. INSERT INTO @Ids (Id)
  1289. SELECT
  1290. '5-17097'
  1291. INSERT INTO @Ids (Id)
  1292. SELECT
  1293. '5-17098'
  1294. INSERT INTO @Ids (Id)
  1295. SELECT
  1296. '5-17099'
  1297. INSERT INTO @Ids (Id)
  1298. SELECT
  1299. '5-17103'
  1300. INSERT INTO @Ids (Id)
  1301. SELECT
  1302. '5-17104'
  1303. INSERT INTO @Ids (Id)
  1304. SELECT
  1305. '5-17105'
  1306. INSERT INTO @Ids (Id)
  1307. SELECT
  1308. '5-17108'
  1309. INSERT INTO @Ids (Id)
  1310. SELECT
  1311. '5-17110'
  1312. INSERT INTO @Ids (Id)
  1313. SELECT
  1314. '5-17113'
  1315. INSERT INTO @Ids (Id)
  1316. SELECT
  1317. '5-17114'
  1318. INSERT INTO @Ids (Id)
  1319. SELECT
  1320. '5-17120'
  1321. INSERT INTO @Ids (Id)
  1322. SELECT
  1323. '5-17124'
  1324. INSERT INTO @Ids (Id)
  1325. SELECT
  1326. '5-17126'
  1327. INSERT INTO @Ids (Id)
  1328. SELECT
  1329. '5-17130'
  1330. INSERT INTO @Ids (Id)
  1331. SELECT
  1332. '5-17131'
  1333. INSERT INTO @Ids (Id)
  1334. SELECT
  1335. '5-17132'
  1336. INSERT INTO @Ids (Id)
  1337. SELECT
  1338. '5-17139'
  1339. INSERT INTO @Ids (Id)
  1340. SELECT
  1341. '5-17140'
  1342. INSERT INTO @Ids (Id)
  1343. SELECT
  1344. '5-17141'
  1345. INSERT INTO @Ids (Id)
  1346. SELECT
  1347. '5-17144'
  1348. INSERT INTO @Ids (Id)
  1349. SELECT
  1350. '5-17145'
  1351. INSERT INTO @Ids (Id)
  1352. SELECT
  1353. '5-17156'
  1354. INSERT INTO @Ids (Id)
  1355. SELECT
  1356. '5-17160'
  1357. INSERT INTO @Ids (Id)
  1358. SELECT
  1359. '5-17166'
  1360. INSERT INTO @Ids (Id)
  1361. SELECT
  1362. '5-17168'
  1363. INSERT INTO @Ids (Id)
  1364. SELECT
  1365. '5-17175'
  1366. INSERT INTO @Ids (Id)
  1367. SELECT
  1368. '5-17180'
  1369. INSERT INTO @Ids (Id)
  1370. SELECT
  1371. '5-17185'
  1372. INSERT INTO @Ids (Id)
  1373. SELECT
  1374. '5-17187'
  1375. INSERT INTO @Ids (Id)
  1376. SELECT
  1377. '5-17188'
  1378. INSERT INTO @Ids (Id)
  1379. SELECT
  1380. '5-17191'
  1381. INSERT INTO @Ids (Id)
  1382. SELECT
  1383. '5-17193'
  1384. INSERT INTO @Ids (Id)
  1385. SELECT
  1386. '5-17197'
  1387. INSERT INTO @Ids (Id)
  1388. SELECT
  1389. '5-17199'
  1390. INSERT INTO @Ids (Id)
  1391. SELECT
  1392. '5-17200'
  1393. INSERT INTO @Ids (Id)
  1394. SELECT
  1395. '5-17201'
  1396. INSERT INTO @Ids (Id)
  1397. SELECT
  1398. '5-17204'
  1399. INSERT INTO @Ids (Id)
  1400. SELECT
  1401. '5-17205'
  1402. INSERT INTO @Ids (Id)
  1403. SELECT
  1404. '5-17206'
  1405. INSERT INTO @Ids (Id)
  1406. SELECT
  1407. '5-17207'
  1408. INSERT INTO @Ids (Id)
  1409. SELECT
  1410. '5-17208'
  1411. INSERT INTO @Ids (Id)
  1412. SELECT
  1413. '5-17209'
  1414. INSERT INTO @Ids (Id)
  1415. SELECT
  1416. '5-17210'
  1417. INSERT INTO @Ids (Id)
  1418. SELECT
  1419. '5-17211'
  1420. INSERT INTO @Ids (Id)
  1421. SELECT
  1422. '5-17212'
  1423. INSERT INTO @Ids (Id)
  1424. SELECT
  1425. '5-17213'
  1426. INSERT INTO @Ids (Id)
  1427. SELECT
  1428. '5-17214'
  1429. INSERT INTO @Ids (Id)
  1430. SELECT
  1431. '5-17215'
  1432. INSERT INTO @Ids (Id)
  1433. SELECT
  1434. '5-17216'
  1435. INSERT INTO @Ids (Id)
  1436. SELECT
  1437. '5-17217'
  1438. INSERT INTO @Ids (Id)
  1439. SELECT
  1440. '5-17218'
  1441. INSERT INTO @Ids (Id)
  1442. SELECT
  1443. '5-17220'
  1444. INSERT INTO @Ids (Id)
  1445. SELECT
  1446. '5-17221'
  1447. INSERT INTO @Ids (Id)
  1448. SELECT
  1449. '5-17222'
  1450. INSERT INTO @Ids (Id)
  1451. SELECT
  1452. '5-17223'
  1453. INSERT INTO @Ids (Id)
  1454. SELECT
  1455. '5-17224'
  1456. INSERT INTO @Ids (Id)
  1457. SELECT
  1458. '5-17225'
  1459. INSERT INTO @Ids (Id)
  1460. SELECT
  1461. '5-17226'
  1462. INSERT INTO @Ids (Id)
  1463. SELECT
  1464. '5-17227'
  1465. INSERT INTO @Ids (Id)
  1466. SELECT
  1467. '5-17228'
  1468. INSERT INTO @Ids (Id)
  1469. SELECT
  1470. '5-17229'
  1471. INSERT INTO @Ids (Id)
  1472. SELECT
  1473. '5-17230'
  1474. INSERT INTO @Ids (Id)
  1475. SELECT
  1476. '5-17232'
  1477. INSERT INTO @Ids (Id)
  1478. SELECT
  1479. '5-17233'
  1480. INSERT INTO @Ids (Id)
  1481. SELECT
  1482. '5-17234'
  1483. INSERT INTO @Ids (Id)
  1484. SELECT
  1485. '5-17236'
  1486. INSERT INTO @Ids (Id)
  1487. SELECT
  1488. '5-17238'
  1489. INSERT INTO @Ids (Id)
  1490. SELECT
  1491. '5-17239'
  1492. INSERT INTO @Ids (Id)
  1493. SELECT
  1494. '5-17243'
  1495. INSERT INTO @Ids (Id)
  1496. SELECT
  1497. '5-17245'
  1498. INSERT INTO @Ids (Id)
  1499. SELECT
  1500. '5-17248'
  1501. INSERT INTO @Ids (Id)
  1502. SELECT
  1503. '5-17251'
  1504. INSERT INTO @Ids (Id)
  1505. SELECT
  1506. '5-17261'
  1507. INSERT INTO @Ids (Id)
  1508. SELECT
  1509. '5-17265'
  1510. INSERT INTO @Ids (Id)
  1511. SELECT
  1512. '5-17271'
  1513. INSERT INTO @Ids (Id)
  1514. SELECT
  1515. '5-17272'
  1516. INSERT INTO @Ids (Id)
  1517. SELECT
  1518. '5-17275'
  1519. INSERT INTO @Ids (Id)
  1520. SELECT
  1521. '5-17276'
  1522. INSERT INTO @Ids (Id)
  1523. SELECT
  1524. '5-17277'
  1525. INSERT INTO @Ids (Id)
  1526. SELECT
  1527. '5-17279'
  1528. INSERT INTO @Ids (Id)
  1529. SELECT
  1530. '5-17622'
  1531. INSERT INTO @Ids (Id)
  1532. SELECT
  1533. '5-17626'
  1534. INSERT INTO @Ids (Id)
  1535. SELECT
  1536. '5-17628'
  1537. INSERT INTO @Ids (Id)
  1538. SELECT
  1539. '5-17629'
  1540. INSERT INTO @Ids (Id)
  1541. SELECT
  1542. '5-17630'
  1543. INSERT INTO @Ids (Id)
  1544. SELECT
  1545. '5-17633'
  1546. INSERT INTO @Ids (Id)
  1547. SELECT
  1548. '5-17635'
  1549. INSERT INTO @Ids (Id)
  1550. SELECT
  1551. '5-17642'
  1552. INSERT INTO @Ids (Id)
  1553. SELECT
  1554. '5-17643'
  1555. INSERT INTO @Ids (Id)
  1556. SELECT
  1557. '5-17644'
  1558. INSERT INTO @Ids (Id)
  1559. SELECT
  1560. '5-17645'
  1561. INSERT INTO @Ids (Id)
  1562. SELECT
  1563. '5-17647'
  1564. INSERT INTO @Ids (Id)
  1565. SELECT
  1566. '5-17648'
  1567. INSERT INTO @Ids (Id)
  1568. SELECT
  1569. '5-17651'
  1570. INSERT INTO @Ids (Id)
  1571. SELECT
  1572. '5-17653'
  1573. INSERT INTO @Ids (Id)
  1574. SELECT
  1575. '5-17663'
  1576. INSERT INTO @Ids (Id)
  1577. SELECT
  1578. '5-17736'
  1579. INSERT INTO @Ids (Id)
  1580. SELECT
  1581. '5-17737'
  1582. INSERT INTO @Ids (Id)
  1583. SELECT
  1584. '5-17741'
  1585. INSERT INTO @Ids (Id)
  1586. SELECT
  1587. '5-17744'
  1588. INSERT INTO @Ids (Id)
  1589. SELECT
  1590. '5-19375'
  1591. INSERT INTO @Ids (Id)
  1592. SELECT
  1593. '5-19400'
  1594. INSERT INTO @Ids (Id)
  1595. SELECT
  1596. '5-19450'
  1597. INSERT INTO @Ids (Id)
  1598. SELECT
  1599. '5-19715'
  1600. INSERT INTO @Ids (Id)
  1601. SELECT
  1602. '5-19761'
  1603. INSERT INTO @Ids (Id)
  1604. SELECT
  1605. '5-19762'
  1606. INSERT INTO @Ids (Id)
  1607. SELECT
  1608. '5-20077'
  1609. INSERT INTO @Ids (Id)
  1610. SELECT
  1611. '5-20200'
  1612. INSERT INTO @Ids (Id)
  1613. SELECT
  1614. '5-20203'
  1615. INSERT INTO @Ids (Id)
  1616. SELECT
  1617. '5-20945'
  1618. INSERT INTO @Ids (Id)
  1619. SELECT
  1620. '5-20954'
  1621. INSERT INTO @Ids (Id)
  1622. SELECT
  1623. '5-20955'
  1624. INSERT INTO @Ids (Id)
  1625. SELECT
  1626. '5-20956'
  1627. INSERT INTO @Ids (Id)
  1628. SELECT
  1629. '5-21208'
  1630. INSERT INTO @Ids (Id)
  1631. SELECT
  1632. '5-21242'
  1633. INSERT INTO @Ids (Id)
  1634. SELECT
  1635. '5-21273'
  1636. INSERT INTO @Ids (Id)
  1637. SELECT
  1638. '5-21699'
  1639. INSERT INTO @Ids (Id)
  1640. SELECT
  1641. '5-21857'
  1642. INSERT INTO @Ids (Id)
  1643. SELECT
  1644. '5-21859'
  1645. INSERT INTO @Ids (Id)
  1646. SELECT
  1647. '5-22025'
  1648. INSERT INTO @Ids (Id)
  1649. SELECT
  1650. '5-22159'
  1651. INSERT INTO @Ids (Id)
  1652. SELECT
  1653. '5-22437'
  1654. INSERT INTO @Ids (Id)
  1655. SELECT
  1656. '5-22660'
  1657. INSERT INTO @Ids (Id)
  1658. SELECT
  1659. '5-22840'
  1660. INSERT INTO @Ids (Id)
  1661. SELECT
  1662. '5-22841'
  1663. INSERT INTO @Ids (Id)
  1664. SELECT
  1665. '5-22842'
  1666. INSERT INTO @Ids (Id)
  1667. SELECT
  1668. '5-22923'
  1669. INSERT INTO @Ids (Id)
  1670. SELECT
  1671. '5-22933'
  1672. INSERT INTO @Ids (Id)
  1673. SELECT
  1674. '5-23475'
  1675. INSERT INTO @Ids (Id)
  1676. SELECT
  1677. '5-23479'
  1678. INSERT INTO @Ids (Id)
  1679. SELECT
  1680. '5-24829'
  1681. INSERT INTO @Ids (Id)
  1682. SELECT
  1683. '5-25077'
  1684. INSERT INTO @Ids (Id)
  1685. SELECT
  1686. '5-25084'
  1687. INSERT INTO @Ids (Id)
  1688. SELECT
  1689. '5-25088'
  1690. INSERT INTO @Ids (Id)
  1691. SELECT
  1692. '5-25092'
  1693. INSERT INTO @Ids (Id)
  1694. SELECT
  1695. '5-25383'
  1696. INSERT INTO @Ids (Id)
  1697. SELECT
  1698. '5-25764'
  1699. INSERT INTO @Ids (Id)
  1700. SELECT
  1701. '5-25772'
  1702. INSERT INTO @Ids (Id)
  1703. SELECT
  1704. '5-25787'
  1705. INSERT INTO @Ids (Id)
  1706. SELECT
  1707. '5-26251'
  1708. INSERT INTO @Ids (Id)
  1709. SELECT
  1710. '5-26448'
  1711. INSERT INTO @Ids (Id)
  1712. SELECT
  1713. '5-26801'
  1714. INSERT INTO @Ids (Id)
  1715. SELECT
  1716. '5-27605'
  1717. INSERT INTO @Ids (Id)
  1718. SELECT
  1719. '5-28394'
  1720. INSERT INTO @Ids (Id)
  1721. SELECT
  1722. '5-28446'
  1723. INSERT INTO @Ids (Id)
  1724. SELECT
  1725. '5-28481'
  1726. INSERT INTO @Ids (Id)
  1727. SELECT
  1728. '5-28549'
  1729. INSERT INTO @Ids (Id)
  1730. SELECT
  1731. '5-28981'
  1732. INSERT INTO @Ids (Id)
  1733. SELECT
  1734. '5-29173'
  1735. INSERT INTO @Ids (Id)
  1736. SELECT
  1737. '5-29276'
  1738. INSERT INTO @Ids (Id)
  1739. SELECT
  1740. '5-29345'
  1741. INSERT INTO @Ids (Id)
  1742. SELECT
  1743. '5-29346'
  1744. INSERT INTO @Ids (Id)
  1745. SELECT
  1746. '5-29495'
  1747. INSERT INTO @Ids (Id)
  1748. SELECT
  1749. '5-29500'
  1750. INSERT INTO @Ids (Id)
  1751. SELECT
  1752. '5-29551'
  1753. INSERT INTO @Ids (Id)
  1754. SELECT
  1755. '5-29560'
  1756. INSERT INTO @Ids (Id)
  1757. SELECT
  1758. '5-30037'
  1759. INSERT INTO @Ids (Id)
  1760. SELECT
  1761. '5-30677'
  1762. INSERT INTO @Ids (Id)
  1763. SELECT
  1764. '5-30906'
  1765. INSERT INTO @Ids (Id)
  1766. SELECT
  1767. '5-31355'
  1768. INSERT INTO @Ids (Id)
  1769. SELECT
  1770. '5-31361'
  1771. INSERT INTO @Ids (Id)
  1772. SELECT
  1773. '5-31380'
  1774. INSERT INTO @Ids (Id)
  1775. SELECT
  1776. '5-31383'
  1777. INSERT INTO @Ids (Id)
  1778. SELECT
  1779. '5-31386'
  1780. INSERT INTO @Ids (Id)
  1781. SELECT
  1782. '5-31734'
  1783. INSERT INTO @Ids (Id)
  1784. SELECT
  1785. '5-31887'
  1786. INSERT INTO @Ids (Id)
  1787. SELECT
  1788. '5-31911'
  1789. INSERT INTO @Ids (Id)
  1790. SELECT
  1791. '5-31913'
  1792. INSERT INTO @Ids (Id)
  1793. SELECT
  1794. '5-31916'
  1795. INSERT INTO @Ids (Id)
  1796. SELECT
  1797. '5-32504'
  1798. INSERT INTO @Ids (Id)
  1799. SELECT
  1800. '5-34056'
  1801. INSERT INTO @Ids (Id)
  1802. SELECT
  1803. '5-34061'
  1804. INSERT INTO @Ids (Id)
  1805. SELECT
  1806. '5-37668'
  1807. INSERT INTO @Ids (Id)
  1808. SELECT
  1809. '5-37699'
  1810. INSERT INTO @Ids (Id)
  1811. SELECT
  1812. '5-37734'
  1813. INSERT INTO @Ids (Id)
  1814. SELECT
  1815. '5-37747'
  1816. INSERT INTO @Ids (Id)
  1817. SELECT
  1818. '5-37752'
  1819. INSERT INTO @Ids (Id)
  1820. SELECT
  1821. '5-37764'
  1822. INSERT INTO @Ids (Id)
  1823. SELECT
  1824. '5-37902'
  1825. INSERT INTO @Ids (Id)
  1826. SELECT
  1827. '5-38845'
  1828. INSERT INTO @Ids (Id)
  1829. SELECT
  1830. '5-38851'
  1831. INSERT INTO @Ids (Id)
  1832. SELECT
  1833. '5-41669'
  1834. INSERT INTO @Ids (Id)
  1835. SELECT
  1836. '5-41671'
  1837. INSERT INTO @Ids (Id)
  1838. SELECT
  1839. '5-41672'
  1840. INSERT INTO @Ids (Id)
  1841. SELECT
  1842. '5-41679'
  1843. INSERT INTO @Ids (Id)
  1844. SELECT
  1845. '5-41682'
  1846. INSERT INTO @Ids (Id)
  1847. SELECT
  1848. '5-41875'
  1849. INSERT INTO @Ids (Id)
  1850. SELECT
  1851. '5-41877'
  1852. INSERT INTO @Ids (Id)
  1853. SELECT
  1854. '5-41938'
  1855. INSERT INTO @Ids (Id)
  1856. SELECT
  1857. '5-41947'
  1858. INSERT INTO @Ids (Id)
  1859. SELECT
  1860. '5-41949'
  1861. INSERT INTO @Ids (Id)
  1862. SELECT
  1863. '5-41951'
  1864. INSERT INTO @Ids (Id)
  1865. SELECT
  1866. '5-41952'
  1867. INSERT INTO @Ids (Id)
  1868. SELECT
  1869. '5-42018'
  1870. INSERT INTO @Ids (Id)
  1871. SELECT
  1872. '5-42047'
  1873. INSERT INTO @Ids (Id)
  1874. SELECT
  1875. '5-42048'
  1876. INSERT INTO @Ids (Id)
  1877. SELECT
  1878. '5-42049'
  1879. INSERT INTO @Ids (Id)
  1880. SELECT
  1881. '5-42050'
  1882. INSERT INTO @Ids (Id)
  1883. SELECT
  1884. '5-42052'
  1885. INSERT INTO @Ids (Id)
  1886. SELECT
  1887. '5-42053'
  1888. INSERT INTO @Ids (Id)
  1889. SELECT
  1890. '5-42054'
  1891. INSERT INTO @Ids (Id)
  1892. SELECT
  1893. '5-42057'
  1894. INSERT INTO @Ids (Id)
  1895. SELECT
  1896. '5-42058'
  1897. INSERT INTO @Ids (Id)
  1898. SELECT
  1899. '5-42104'
  1900. INSERT INTO @Ids (Id)
  1901. SELECT
  1902. '5-42106'
  1903. INSERT INTO @Ids (Id)
  1904. SELECT
  1905. '5-42107'
  1906. INSERT INTO @Ids (Id)
  1907. SELECT
  1908. '5-42111'
  1909. INSERT INTO @Ids (Id)
  1910. SELECT
  1911. '5-42123'
  1912. INSERT INTO @Ids (Id)
  1913. SELECT
  1914. '5-42125'
  1915. INSERT INTO @Ids (Id)
  1916. SELECT
  1917. '5-42127'
  1918. INSERT INTO @Ids (Id)
  1919. SELECT
  1920. '5-42128'
  1921. INSERT INTO @Ids (Id)
  1922. SELECT
  1923. '5-42129'
  1924. INSERT INTO @Ids (Id)
  1925. SELECT
  1926. '5-42131'
  1927. INSERT INTO @Ids (Id)
  1928. SELECT
  1929. '5-42149'
  1930. INSERT INTO @Ids (Id)
  1931. SELECT
  1932. '5-42200'
  1933. INSERT INTO @Ids (Id)
  1934. SELECT
  1935. '5-42201'
  1936. INSERT INTO @Ids (Id)
  1937. SELECT
  1938. '5-42218'
  1939. INSERT INTO @Ids (Id)
  1940. SELECT
  1941. '5-42241'
  1942. INSERT INTO @Ids (Id)
  1943. SELECT
  1944. '5-42242'
  1945. INSERT INTO @Ids (Id)
  1946. SELECT
  1947. '5-42246'
  1948. INSERT INTO @Ids (Id)
  1949. SELECT
  1950. '5-42316'
  1951. INSERT INTO @Ids (Id)
  1952. SELECT
  1953. '5-42465'
  1954. INSERT INTO @Ids (Id)
  1955. SELECT
  1956. '5-42467'
  1957. INSERT INTO @Ids (Id)
  1958. SELECT
  1959. '5-42514'
  1960. INSERT INTO @Ids (Id)
  1961. SELECT
  1962. '5-42573'
  1963. INSERT INTO @Ids (Id)
  1964. SELECT
  1965. '5-42577'
  1966. INSERT INTO @Ids (Id)
  1967. SELECT
  1968. '5-42597'
  1969. INSERT INTO @Ids (Id)
  1970. SELECT
  1971. '5-42598'
  1972. INSERT INTO @Ids (Id)
  1973. SELECT
  1974. '5-42615'
  1975. INSERT INTO @Ids (Id)
  1976. SELECT
  1977. '5-42622'
  1978. INSERT INTO @Ids (Id)
  1979. SELECT
  1980. '5-42624'
  1981. INSERT INTO @Ids (Id)
  1982. SELECT
  1983. '5-42625'
  1984. INSERT INTO @Ids (Id)
  1985. SELECT
  1986. '5-42628'
  1987. INSERT INTO @Ids (Id)
  1988. SELECT
  1989. '5-42660'
  1990. INSERT INTO @Ids (Id)
  1991. SELECT
  1992. '5-42668'
  1993. INSERT INTO @Ids (Id)
  1994. SELECT
  1995. '5-42671'
  1996. INSERT INTO @Ids (Id)
  1997. SELECT
  1998. '5-42697'
  1999. INSERT INTO @Ids (Id)
  2000. SELECT
  2001. '5-42698'
  2002. INSERT INTO @Ids (Id)
  2003. SELECT
  2004. '5-42700'
  2005. INSERT INTO @Ids (Id)
  2006. SELECT
  2007. '5-42717'
  2008. INSERT INTO @Ids (Id)
  2009. SELECT
  2010. '5-42721'
  2011. INSERT INTO @Ids (Id)
  2012. SELECT
  2013. '5-42734'
  2014. INSERT INTO @Ids (Id)
  2015. SELECT
  2016. '5-42797'
  2017. INSERT INTO @Ids (Id)
  2018. SELECT
  2019. '5-42798'
  2020. INSERT INTO @Ids (Id)
  2021. SELECT
  2022. '5-42813'
  2023. INSERT INTO @Ids (Id)
  2024. SELECT
  2025. '5-42815'
  2026. INSERT INTO @Ids (Id)
  2027. SELECT
  2028. '5-42816'
  2029. INSERT INTO @Ids (Id)
  2030. SELECT
  2031. '5-42831'
  2032. INSERT INTO @Ids (Id)
  2033. SELECT
  2034. '5-42835'
  2035. INSERT INTO @Ids (Id)
  2036. SELECT
  2037. '5-42844'
  2038. INSERT INTO @Ids (Id)
  2039. SELECT
  2040. '5-42845'
  2041. INSERT INTO @Ids (Id)
  2042. SELECT
  2043. '5-42850'
  2044. INSERT INTO @Ids (Id)
  2045. SELECT
  2046. '5-42851'
  2047. INSERT INTO @Ids (Id)
  2048. SELECT
  2049. '5-42867'
  2050. INSERT INTO @Ids (Id)
  2051. SELECT
  2052. '5-42871'
  2053. INSERT INTO @Ids (Id)
  2054. SELECT
  2055. '5-42921'
  2056. INSERT INTO @Ids (Id)
  2057. SELECT
  2058. '5-42965'
  2059. INSERT INTO @Ids (Id)
  2060. SELECT
  2061. '5-43208'
  2062. INSERT INTO @Ids (Id)
  2063. SELECT
  2064. '5-43212'
  2065. INSERT INTO @Ids (Id)
  2066. SELECT
  2067. '5-43218'
  2068. INSERT INTO @Ids (Id)
  2069. SELECT
  2070. '5-43219'
  2071. INSERT INTO @Ids (Id)
  2072. SELECT
  2073. '5-43221'
  2074. INSERT INTO @Ids (Id)
  2075. SELECT
  2076. '5-43246'
  2077. INSERT INTO @Ids (Id)
  2078. SELECT
  2079. '5-43248'
  2080. INSERT INTO @Ids (Id)
  2081. SELECT
  2082. '5-43255'
  2083. INSERT INTO @Ids (Id)
  2084. SELECT
  2085. '5-43257'
  2086. INSERT INTO @Ids (Id)
  2087. SELECT
  2088. '5-43259'
  2089. INSERT INTO @Ids (Id)
  2090. SELECT
  2091. '5-43339'
  2092. INSERT INTO @Ids (Id)
  2093. SELECT
  2094. '5-43357'
  2095. INSERT INTO @Ids (Id)
  2096. SELECT
  2097. '5-43358'
  2098. INSERT INTO @Ids (Id)
  2099. SELECT
  2100. '5-43366'
  2101. INSERT INTO @Ids (Id)
  2102. SELECT
  2103. '5-43561'
  2104. INSERT INTO @Ids (Id)
  2105. SELECT
  2106. '5-43589'
  2107. INSERT INTO @Ids (Id)
  2108. SELECT
  2109. '5-43590'
  2110. INSERT INTO @Ids (Id)
  2111. SELECT
  2112. '5-43591'
  2113. INSERT INTO @Ids (Id)
  2114. SELECT
  2115. '5-43592'
  2116. INSERT INTO @Ids (Id)
  2117. SELECT
  2118. '5-43593'
  2119. INSERT INTO @Ids (Id)
  2120. SELECT
  2121. '5-43705'
  2122. INSERT INTO @Ids (Id)
  2123. SELECT
  2124. '5-43750'
  2125. INSERT INTO @Ids (Id)
  2126. SELECT
  2127. '5-43812'
  2128. INSERT INTO @Ids (Id)
  2129. SELECT
  2130. '5-43980'
  2131. INSERT INTO @Ids (Id)
  2132. SELECT
  2133. '5-44028'
  2134. INSERT INTO @Ids (Id)
  2135. SELECT
  2136. '5-44126'
  2137. INSERT INTO @Ids (Id)
  2138. SELECT
  2139. '5-44144'
  2140. INSERT INTO @Ids (Id)
  2141. SELECT
  2142. '5-44191'
  2143. INSERT INTO @Ids (Id)
  2144. SELECT
  2145. '5-44211'
  2146. INSERT INTO @Ids (Id)
  2147. SELECT
  2148. '5-44213'
  2149. INSERT INTO @Ids (Id)
  2150. SELECT
  2151. '5-44215'
  2152. INSERT INTO @Ids (Id)
  2153. SELECT
  2154. '5-44220'
  2155. INSERT INTO @Ids (Id)
  2156. SELECT
  2157. '5-44329'
  2158. INSERT INTO @Ids (Id)
  2159. SELECT
  2160. '5-44330'
  2161. INSERT INTO @Ids (Id)
  2162. SELECT
  2163. '5-44544'
  2164. INSERT INTO @Ids (Id)
  2165. SELECT
  2166. '5-44553'
  2167. INSERT INTO @Ids (Id)
  2168. SELECT
  2169. '5-44582'
  2170. INSERT INTO @Ids (Id)
  2171. SELECT
  2172. '5-44583'
  2173. INSERT INTO @Ids (Id)
  2174. SELECT
  2175. '5-44704'
  2176. INSERT INTO @Ids (Id)
  2177. SELECT
  2178. '5-44790'
  2179. INSERT INTO @Ids (Id)
  2180. SELECT
  2181. '5-44796'
  2182. INSERT INTO @Ids (Id)
  2183. SELECT
  2184. '5-45182'
  2185. INSERT INTO @Ids (Id)
  2186. SELECT
  2187. '5-45214'
  2188. INSERT INTO @Ids (Id)
  2189. SELECT
  2190. '5-45261'
  2191. INSERT INTO @Ids (Id)
  2192. SELECT
  2193. '5-45384'
  2194. INSERT INTO @Ids (Id)
  2195. SELECT
  2196. '5-45388'
  2197. INSERT INTO @Ids (Id)
  2198. SELECT
  2199. '5-45582'
  2200. INSERT INTO @Ids (Id)
  2201. SELECT
  2202. '5-45602'
  2203. INSERT INTO @Ids (Id)
  2204. SELECT
  2205. '5-45756'
  2206. INSERT INTO @Ids (Id)
  2207. SELECT
  2208. '5-45757'
  2209. INSERT INTO @Ids (Id)
  2210. SELECT
  2211. '5-45885'
  2212. INSERT INTO @Ids (Id)
  2213. SELECT
  2214. '5-45891'
  2215. INSERT INTO @Ids (Id)
  2216. SELECT
  2217. '5-45900'
  2218. INSERT INTO @Ids (Id)
  2219. SELECT
  2220. '5-45975'
  2221. INSERT INTO @Ids (Id)
  2222. SELECT
  2223. '5-46117'
  2224. INSERT INTO @Ids (Id)
  2225. SELECT
  2226. '5-46253'
  2227. INSERT INTO @Ids (Id)
  2228. SELECT
  2229. '5-46255'
  2230. INSERT INTO @Ids (Id)
  2231. SELECT
  2232. '5-46259'
  2233. INSERT INTO @Ids (Id)
  2234. SELECT
  2235. '5-46272'
  2236. INSERT INTO @Ids (Id)
  2237. SELECT
  2238. '5-46273'
  2239. INSERT INTO @Ids (Id)
  2240. SELECT
  2241. '5-46340'
  2242. INSERT INTO @Ids (Id)
  2243. SELECT
  2244. '5-46471'
  2245. INSERT INTO @Ids (Id)
  2246. SELECT
  2247. '5-46482'
  2248. INSERT INTO @Ids (Id)
  2249. SELECT
  2250. '5-46497'
  2251. INSERT INTO @Ids (Id)
  2252. SELECT
  2253. '5-46633'
  2254. INSERT INTO @Ids (Id)
  2255. SELECT
  2256. '5-46634'
  2257. INSERT INTO @Ids (Id)
  2258. SELECT
  2259. '5-46635'
  2260. INSERT INTO @Ids (Id)
  2261. SELECT
  2262. '5-46636'
  2263. INSERT INTO @Ids (Id)
  2264. SELECT
  2265. '5-46703'
  2266. INSERT INTO @Ids (Id)
  2267. SELECT
  2268. '5-46706'
  2269. INSERT INTO @Ids (Id)
  2270. SELECT
  2271. '5-46727'
  2272. INSERT INTO @Ids (Id)
  2273. SELECT
  2274. '5-46755'
  2275. INSERT INTO @Ids (Id)
  2276. SELECT
  2277. '5-46895'
  2278. INSERT INTO @Ids (Id)
  2279. SELECT
  2280. '5-46942'
  2281. INSERT INTO @Ids (Id)
  2282. SELECT
  2283. '5-47004'
  2284. INSERT INTO @Ids (Id)
  2285. SELECT
  2286. '5-47007'
  2287. INSERT INTO @Ids (Id)
  2288. SELECT
  2289. '5-47049'
  2290. INSERT INTO @Ids (Id)
  2291. SELECT
  2292. '5-47096'
  2293. INSERT INTO @Ids (Id)
  2294. SELECT
  2295. '5-47098'
  2296. INSERT INTO @Ids (Id)
  2297. SELECT
  2298. '5-47130'
  2299. INSERT INTO @Ids (Id)
  2300. SELECT
  2301. '5-47131'
  2302. INSERT INTO @Ids (Id)
  2303. SELECT
  2304. '5-47259'
  2305. INSERT INTO @Ids (Id)
  2306. SELECT
  2307. '5-47260'
  2308. INSERT INTO @Ids (Id)
  2309. SELECT
  2310. '5-47517'
  2311. INSERT INTO @Ids (Id)
  2312. SELECT
  2313. '5-47519'
  2314. INSERT INTO @Ids (Id)
  2315. SELECT
  2316. '5-47520'
  2317. INSERT INTO @Ids (Id)
  2318. SELECT
  2319. '5-47523'
  2320. INSERT INTO @Ids (Id)
  2321. SELECT
  2322. '5-47553'
  2323. INSERT INTO @Ids (Id)
  2324. SELECT
  2325. '5-47555'
  2326. INSERT INTO @Ids (Id)
  2327. SELECT
  2328. '5-47570'
  2329. INSERT INTO @Ids (Id)
  2330. SELECT
  2331. '5-47578'
  2332. INSERT INTO @Ids (Id)
  2333. SELECT
  2334. '5-47615'
  2335. INSERT INTO @Ids (Id)
  2336. SELECT
  2337. '5-47617'
  2338. INSERT INTO @Ids (Id)
  2339. SELECT
  2340. '5-47618'
  2341. INSERT INTO @Ids (Id)
  2342. SELECT
  2343. '5-47651'
  2344. INSERT INTO @Ids (Id)
  2345. SELECT
  2346. '5-47669'
  2347. INSERT INTO @Ids (Id)
  2348. SELECT
  2349. '5-47690'
  2350. INSERT INTO @Ids (Id)
  2351. SELECT
  2352. '5-47691'
  2353. INSERT INTO @Ids (Id)
  2354. SELECT
  2355. '5-47740'
  2356. INSERT INTO @Ids (Id)
  2357. SELECT
  2358. '5-47781'
  2359. INSERT INTO @Ids (Id)
  2360. SELECT
  2361. '5-47782'
  2362. INSERT INTO @Ids (Id)
  2363. SELECT
  2364. '5-47811'
  2365. INSERT INTO @Ids (Id)
  2366. SELECT
  2367. '5-47818'
  2368. INSERT INTO @Ids (Id)
  2369. SELECT
  2370. '5-47907'
  2371. INSERT INTO @Ids (Id)
  2372. SELECT
  2373. '5-47910'
  2374. INSERT INTO @Ids (Id)
  2375. SELECT
  2376. '5-47912'
  2377. INSERT INTO @Ids (Id)
  2378. SELECT
  2379. '5-47969'
  2380. INSERT INTO @Ids (Id)
  2381. SELECT
  2382. '5-47970'
  2383. INSERT INTO @Ids (Id)
  2384. SELECT
  2385. '5-47971'
  2386. INSERT INTO @Ids (Id)
  2387. SELECT
  2388. '5-47972'
  2389. INSERT INTO LocationStatus (LocationId, WreathsYearId, StatusId, StatusById, StatusNote)
  2390. SELECT
  2391. wlp.LocationId
  2392. ,wlp.WreathsDayId
  2393. ,8
  2394. ,'0fa57843-d743-4397-b032-00df9b091c95'
  2395. ,NULL
  2396. FROM wh_LogisticsPlanning wlp
  2397. JOIN (SELECT
  2398. Id
  2399. FROM @Ids
  2400. GROUP BY Id) ids
  2401. ON wlp.Id = ids.Id
  2402. UPDATE wlp
  2403. SET wlp.LastStatusId = ls.Id
  2404. FROM wh_LogisticsPlanning wlp
  2405. JOIN (SELECT
  2406. Id
  2407. FROM @Ids
  2408. GROUP BY Id) ids
  2409. ON wlp.Id = ids.Id
  2410. JOIN (SELECT
  2411. MaxId = MAX(Id)
  2412. ,LocationId
  2413. ,WreathsYearId
  2414. FROM LocationStatus ls
  2415. GROUP BY LocationId
  2416. ,WreathsYearId) ls_max
  2417. ON wlp.LocationId = ls_max.LocationId
  2418. AND wlp.WreathsDayId = ls_max.WreathsYearId
  2419. JOIN LocationStatus ls
  2420. ON ls_max.MaxId = ls.Id
Add Comment
Please, Sign In to add comment