SHARE
TWEET

Untitled

a guest Dec 19th, 2018 56 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT REPLACE(REPLACE(ptp_cde,'mem',''),'0',''),ptp_cde,f.* FROM dap_ptp_mst m
  2. JOIN dev_att_fil f
  3. ON m.glb_unq_idn = f.ent_glb_unq_idn
  4. WHERE ptp_cde IN(
  5. 'MEM'+replicate('0',10-len('387'))+'387',
  6. 'MEM'+replicate('0',10-len('492'))+'492',
  7. 'MEM'+replicate('0',10-len('522'))+'522',
  8. 'MEM'+replicate('0',10-len('1343'))+'1343',
  9. 'MEM'+replicate('0',10-len('67127'))+'67127',
  10. 'MEM'+replicate('0',10-len('1769'))+'1769',
  11. 'MEM'+replicate('0',10-len('1825'))+'1825',
  12. 'MEM'+replicate('0',10-len('1692'))+'1692',
  13. 'MEM'+replicate('0',10-len('2907'))+'2907',
  14. 'MEM'+replicate('0',10-len('1956'))+'1956',
  15. 'MEM'+replicate('0',10-len('2125'))+'2125',
  16. 'MEM'+replicate('0',10-len('4332'))+'4332',
  17. 'MEM'+replicate('0',10-len('3725'))+'3725',
  18. 'MEM'+replicate('0',10-len('4182'))+'4182',
  19. 'MEM'+replicate('0',10-len('4439'))+'4439',
  20. 'MEM'+replicate('0',10-len('4480'))+'4480',
  21. 'MEM'+replicate('0',10-len('5313'))+'5313',
  22. 'MEM'+replicate('0',10-len('4883'))+'4883',
  23. 'MEM'+replicate('0',10-len('5171'))+'5171',
  24. 'MEM'+replicate('0',10-len('6973'))+'6973',
  25. 'MEM'+replicate('0',10-len('68321'))+'68321',
  26. 'MEM'+replicate('0',10-len('7564'))+'7564',
  27. 'MEM'+replicate('0',10-len('7453'))+'7453',
  28. 'MEM'+replicate('0',10-len('8001'))+'8001',
  29. 'MEM'+replicate('0',10-len('8320'))+'8320',
  30. 'MEM'+replicate('0',10-len('8983'))+'8983',
  31. 'MEM'+replicate('0',10-len('9571'))+'9571',
  32. 'MEM'+replicate('0',10-len('8920'))+'8920',
  33. 'MEM'+replicate('0',10-len('10281'))+'10281',
  34. 'MEM'+replicate('0',10-len('69838'))+'69838',
  35. 'MEM'+replicate('0',10-len('12216'))+'12216',
  36. 'MEM'+replicate('0',10-len('13295'))+'13295',
  37. 'MEM'+replicate('0',10-len('68594'))+'68594',
  38. 'MEM'+replicate('0',10-len('16051'))+'16051',
  39. 'MEM'+replicate('0',10-len('16108'))+'16108',
  40. 'MEM'+replicate('0',10-len('68226'))+'68226',
  41. 'MEM'+replicate('0',10-len('17090'))+'17090',
  42. 'MEM'+replicate('0',10-len('178148'))+'178148',
  43. 'MEM'+replicate('0',10-len('16996'))+'16996',
  44. 'MEM'+replicate('0',10-len('70493'))+'70493',
  45. 'MEM'+replicate('0',10-len('67203'))+'67203',
  46. 'MEM'+replicate('0',10-len('18980'))+'18980',
  47. 'MEM'+replicate('0',10-len('19150'))+'19150',
  48. 'MEM'+replicate('0',10-len('20081'))+'20081',
  49. 'MEM'+replicate('0',10-len('19692'))+'19692',
  50. 'MEM'+replicate('0',10-len('69072'))+'69072',
  51. 'MEM'+replicate('0',10-len('20675'))+'20675',
  52. 'MEM'+replicate('0',10-len('22654'))+'22654',
  53. 'MEM'+replicate('0',10-len('23298'))+'23298',
  54. 'MEM'+replicate('0',10-len('63515'))+'63515',
  55. 'MEM'+replicate('0',10-len('64424'))+'64424',
  56. 'MEM'+replicate('0',10-len('64498'))+'64498')
  57. AND att_typ_cde = 'CERTIFICATE'
  58. AND att_vld_sdt = '2019-01-01 00:00:00.000'
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
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top