Advertisement
Guest User

Untitled

a guest
Mar 21st, 2019
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 7.44 KB | None | 0 0
  1.  
  2.  
  3. USE baseSOD
  4. SET DATEFORMAT ymd
  5.  
  6. TRUNCATE TABLE baseSOD.dbo.SendPayment_test
  7. GO
  8.  
  9. SET IDENTITY_INSERT dbo.SendPayment_test ON
  10. GO
  11. INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
  12.   VALUES (1, 2, 207, 3001, 470, '2019-06-03 03:45:35.030', 51, CONVERT(BIT, 'False'), '2019-03-14 01:26:05.850')
  13. GO
  14. INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
  15.   VALUES (2, 1, 311, 3001, 204, '2019-03-12 11:34:14.140', 51, CONVERT(BIT, 'False'), '2019-03-14 01:26:05.850')
  16. GO
  17. INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
  18.   VALUES (4, 1, 168, 3001, 465, '2019-08-03 07:19:33.640', 0, CONVERT(BIT, 'False'), '2019-11-03 04:58:47.823')
  19. GO
  20. INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
  21.   VALUES (18, 3, 212, 3001, 204, '2019-03-09 19:11:38.920', 0, CONVERT(BIT, 'False'), '2019-03-13 19:01:49.007')
  22. GO
  23. INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
  24.   VALUES (10, 1, 388, 3002, 473, '2019-01-19 13:15:17.660', 61, CONVERT(BIT, 'False'), '2019-01-24 13:37:34.427')
  25. GO
  26. INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
  27.   VALUES (21, 3, 556, 3002, 377, '2019-10-02 02:05:50.390', 61, CONVERT(BIT, 'False'), '2019-12-02 09:13:31.353')
  28. GO
  29. INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
  30.   VALUES (26, 2, 807, 3002, 201, '2019-12-01 00:18:36.080', 61, CONVERT(BIT, 'False'), '2019-12-01 05:16:28.507')
  31. GO
  32. INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
  33.   VALUES (6, 2, 386, 3004, 348, '2019-06-03 13:37:58.150', 51, CONVERT(BIT, 'False'), '2019-02-05 09:53:44.220')
  34. GO
  35. INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
  36.   VALUES (7, 2, 887, 3004, 265, '2018-12-26 22:36:10.340', 51, CONVERT(BIT, 'False'), '2018-12-31 18:46:09.977')
  37. GO
  38. INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
  39.   VALUES (8, 3, 813, 3004, 317, '2019-09-03 08:42:25.300', 61, CONVERT(BIT, 'False'), '2019-11-03 18:14:47.257')
  40. GO
  41. INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
  42.   VALUES (11, 3, 915, 3004, 329, '2019-02-03 02:02:16.740', 61, CONVERT(BIT, 'False'), '2019-08-03 22:02:23.720')
  43. GO
  44. INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
  45.   VALUES (12, 1, 618, 3004, 187, '2019-04-02 08:55:46.040', 51, CONVERT(BIT, 'False'), '2019-01-02 22:05:36.927')
  46. GO
  47. INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
  48.   VALUES (15, 2, 826, 3004, 121, '2019-09-03 19:56:58.990', 51, CONVERT(BIT, 'False'), '2019-03-20 16:17:11.060')
  49. GO
  50. INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
  51.   VALUES (16, 2, 619, 3004, 308, '2019-01-30 13:48:58.660', 51, CONVERT(BIT, 'False'), '2019-02-03 09:15:26.593')
  52. GO
  53. INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
  54.   VALUES (17, 3, 892, 3004, 123, '2019-01-12 20:12:48.770', 41, CONVERT(BIT, 'False'), '2019-01-15 06:20:35.220')
  55. GO
  56. INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
  57.   VALUES (22, 3, 992, 3004, 355, '2019-01-29 14:58:06.040', 51, CONVERT(BIT, 'False'), '2019-02-02 06:30:55.720')
  58. GO
  59. INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
  60.   VALUES (25, 2, 812, 3004, 409, '2019-02-26 18:01:31.500', 41, CONVERT(BIT, 'False'), '2019-03-05 00:00:33.077')
  61. GO
  62. INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
  63.   VALUES (27, 1, 758, 3004, 474, '2019-01-13 10:18:33.650', 0, CONVERT(BIT, 'False'), '2019-01-18 12:00:14.343')
  64. GO
  65. INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
  66.   VALUES (28, 1, 330, 3004, 316, '2019-03-15 03:30:41.170', 41, CONVERT(BIT, 'False'), '2019-03-20 19:41:01.227')
  67. GO
  68. INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
  69.   VALUES (30, 2, 609, 3004, 215, '2019-05-03 21:38:28.540', 61, CONVERT(BIT, 'False'), '2019-06-03 02:00:55.417')
  70. GO
  71. INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
  72.   VALUES (3, 1, 836, 3012, 470, '2019-01-19 01:16:53.940', 0, CONVERT(BIT, 'False'), '2019-01-21 17:38:11.327')
  73. GO
  74. INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
  75.   VALUES (5, 1, 753, 3012, 401, '2018-12-25 10:51:00.910', 41, CONVERT(BIT, 'False'), '2018-12-29 18:17:32.820')
  76. GO
  77. INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
  78.   VALUES (9, 1, 867, 3012, 237, '2019-01-20 00:39:23.060', 51, CONVERT(BIT, 'False'), '2019-01-24 20:33:59.937')
  79. GO
  80. INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
  81.   VALUES (13, 3, 195, 3012, 295, '2019-01-18 13:13:33.600', 41, CONVERT(BIT, 'False'), '2019-01-20 18:04:34.650')
  82. GO
  83. INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
  84.   VALUES (14, 2, 396, 3012, 361, '2019-03-18 18:44:47.800', 0, CONVERT(BIT, 'False'), '2019-03-22 14:41:05.817')
  85. GO
  86. INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
  87.   VALUES (19, 3, 672, 3012, 304, '2019-01-31 11:12:32.580', 41, CONVERT(BIT, 'False'), '2019-02-04 03:06:20.803')
  88. GO
  89. INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
  90.   VALUES (20, 3, 911, 3012, 325, '2019-02-08 23:00:56.470', 41, CONVERT(BIT, 'False'), '2019-02-13 06:36:31.717')
  91. GO
  92. INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
  93.   VALUES (23, 3, 532, 3012, 163, '2019-03-10 21:52:10.010', 0, CONVERT(BIT, 'False'), '2019-03-14 12:48:37.807')
  94. GO
  95. INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
  96.   VALUES (24, 2, 965, 3012, 132, '2019-01-15 00:00:24.220', 61, CONVERT(BIT, 'False'), '2019-01-15 20:53:12.213')
  97. GO
  98. INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
  99.   VALUES (29, 3, 117, 3012, 497, '2018-12-30 08:47:45.210', 0, CONVERT(BIT, 'False'), '2019-01-05 10:17:40.027')
  100. GO
  101. SET IDENTITY_INSERT dbo.SendPayment_test OFF
  102. GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement