PanProduct.sql 3.2 KB

1234567891011121314151617181920212223242526
  1. DELETE FROM [DataAccessLayer].[PanProduct] WHERE TokenisedPan IN (3161298874256,1751144528024763,2469036722636631,3173040045066091,3178042060841493,3186762710517944,3187007310413960,3187009719671308,3187157797424494,3187669174638864,3187674948643514,3188217694541622,3189555214291380,3211927544494378,3421000591551411,3425138996040927,5179762040643138,6771083486022888,6771096490339182,6905342138769450,7591229857767875,7598406073257928,8068355351794216,8068355707321776);
  2. INSERT INTO [DataAccessLayer].[PanProduct] (TokenisedPan,ProductId,CardNetwork) VALUES ( 3161298874256,441,0 );
  3. INSERT INTO [DataAccessLayer].[PanProduct] (TokenisedPan,ProductId,CardNetwork) VALUES ( 1751144528024763,60,0 );
  4. INSERT INTO [DataAccessLayer].[PanProduct] (TokenisedPan,ProductId,CardNetwork) VALUES ( 2469036722636631,186,0 );
  5. INSERT INTO [DataAccessLayer].[PanProduct] (TokenisedPan,ProductId,CardNetwork) VALUES ( 3173040045066091,592,0 );
  6. INSERT INTO [DataAccessLayer].[PanProduct] (TokenisedPan,ProductId,CardNetwork) VALUES ( 3178042060841493,592,0 );
  7. INSERT INTO [DataAccessLayer].[PanProduct] (TokenisedPan,ProductId,CardNetwork) VALUES ( 3186762710517944,443,0 );
  8. INSERT INTO [DataAccessLayer].[PanProduct] (TokenisedPan,ProductId,CardNetwork) VALUES ( 3187007310413960,443,0 );
  9. INSERT INTO [DataAccessLayer].[PanProduct] (TokenisedPan,ProductId,CardNetwork) VALUES ( 3187009719671308,443,0 );
  10. INSERT INTO [DataAccessLayer].[PanProduct] (TokenisedPan,ProductId,CardNetwork) VALUES ( 3187157797424494,443,0 );
  11. INSERT INTO [DataAccessLayer].[PanProduct] (TokenisedPan,ProductId,CardNetwork) VALUES ( 3187669174638864,443,0 );
  12. INSERT INTO [DataAccessLayer].[PanProduct] (TokenisedPan,ProductId,CardNetwork) VALUES ( 3187674948643514,443,0 );
  13. INSERT INTO [DataAccessLayer].[PanProduct] (TokenisedPan,ProductId,CardNetwork) VALUES ( 3188217694541622,443,0 );
  14. INSERT INTO [DataAccessLayer].[PanProduct] (TokenisedPan,ProductId,CardNetwork) VALUES ( 3189555214291380,443,0 );
  15. INSERT INTO [DataAccessLayer].[PanProduct] (TokenisedPan,ProductId,CardNetwork) VALUES ( 3211927544494378,452,0 );
  16. INSERT INTO [DataAccessLayer].[PanProduct] (TokenisedPan,ProductId,CardNetwork) VALUES ( 3421000591551411,588,1 );
  17. INSERT INTO [DataAccessLayer].[PanProduct] (TokenisedPan,ProductId,CardNetwork) VALUES ( 3425138996040927,588,1 );
  18. INSERT INTO [DataAccessLayer].[PanProduct] (TokenisedPan,ProductId,CardNetwork) VALUES ( 5179762040643138,1545,0 );
  19. INSERT INTO [DataAccessLayer].[PanProduct] (TokenisedPan,ProductId,CardNetwork) VALUES ( 6771083486022888,1902,0 );
  20. INSERT INTO [DataAccessLayer].[PanProduct] (TokenisedPan,ProductId,CardNetwork) VALUES ( 6771096490339182,1902,0 );
  21. INSERT INTO [DataAccessLayer].[PanProduct] (TokenisedPan,ProductId,CardNetwork) VALUES ( 6905342138769450,45671722,0 );
  22. INSERT INTO [DataAccessLayer].[PanProduct] (TokenisedPan,ProductId,CardNetwork) VALUES ( 7591229857767875,9009,0 );
  23. INSERT INTO [DataAccessLayer].[PanProduct] (TokenisedPan,ProductId,CardNetwork) VALUES ( 7598406073257928,9029,0 );
  24. INSERT INTO [DataAccessLayer].[PanProduct] (TokenisedPan,ProductId,CardNetwork) VALUES ( 8068355351794216,9093,0 );
  25. INSERT INTO [DataAccessLayer].[PanProduct] (TokenisedPan,ProductId,CardNetwork) VALUES ( 8068355707321776,9093,0 );