|
Программирование >> Построение запросов sql
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (11, 080270, 2, 46, 01/03/2002, 12, 2001); INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (12, 080613, 2, 56, 07/19/2001, 6, 2001); INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (13, 115705, 2, 250, 10/06/2000, 9, 2000); INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (14, 115705, 2, 58.7, 09/04/2001, 8, 2001); INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (15, 136169, 2, 58.7, 12/01/2001, 11, 2001); INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (16, 443069, 2, 80, 10/03/2001, 9, 2001); INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (17, 443069, 2, 38.5, 09/13/2001, 8, 2001); INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (18, 136160, 1, 18.3, 02/05/1998, 1, 1998); INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (19, 015527, 1, 28.32, 08/03/1998, 7, 1998); INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (20, 080047, 1, 19.56, 04/02/1998, 3, 1998); INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (21, 080613, 1, 10.6, 10/03/1998, 9, 1998); INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (22, 443069, 1, 38.28, 02/04/1999, 12, 1998); INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (23, 015527, 1, 38.32, 05/07/1999, 4, 1999); INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (24, 115705, 1, 37.15, 11/04/1999, 10, 1999); INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (25, 080613, 1, 12.6, 09/20/2000, 8, 2000); INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (26, 136169, 1, 25.32, 02/03/1999, 1, 1999); INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (27, 080270, 1, 57.1, 03/05/1998, 2, 1998); INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (28, 136159, 1, 8.3, 09/10/1999, 8, 1999); INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (29, 005488, 1, 62.13, 05/03/2000, 4, 2000); INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (30, 115705, 1, 37.8, 07/12/2001, 5, 2001); INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (31, 443690, 1, 17.8, 07/10/1998, 6, 1998); INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (32, 080047, 1, 22.56, 06/25/1999, 5, 1999); INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (33, 126112, 1, 15.3, 09/08/2000, 8, 2000); INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (34, 080047, 1, 32.56, 10/18/2001, 9, 2001); INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (35, 080613, 1, 12.6, 05/22/1998, 4, 1998); INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (36, 115705, 1, 37.15, 12/23/1999, 11, 1999); INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (37, 080270, 1, 58.1, 01/07/2001, 12, 2000); INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (38, 136169, 1, 28.32, 02/08/2001, 1, 2001); INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (39, 015527, 1, 18.32, 03/18/1998, 2, 1998); INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (40, 443690, 1, 21.67, 04/10/1999, 3, 1999); INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (41, 080613, 1, 22.86, 05/04/2000, 4, 2000); INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (42, 080270, 1, 60.1, 06/07/2001, 5, 2001); INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (43, 136169, 1, 28.32, 03/05/1998, 2, 1998); INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (44, 080047, 1, 22.2, 08/10/1999, 7, 1999); INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (45, 126112, 1, 25.3, 09/10/2001, 8, 2001); INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (46, 443069, 1, 38.32, 10/09/2001, 9, 2001); INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (47, 136159, 1, 8.3, 11/14/1998, 10, 1998); INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (48, 115705, 1, 37.15, 08/10/1999, 6, 1999); INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (49, 136160, 1, 18.3, 01/07/2001, 12, 2000); COMMIT WORK; /i / /* Insert REQUEST */ /i / INSERT INTO REQUEST (REQUESTCD, ACCOUNTCD, EXECUTORCD, FAILURECD, INCOMINGDATE, EXECUTIONDATE, EXECUTED) VALUES (1, 005488, 1, 1, 12/17/2001, 12/20/2001, 1); INSERT INTO REQUEST (REQUESTCD, ACCOUNTCD, EXECUTORCD, FAILURECD, INCOMINGDATE, EXECUTIONDATE, EXECUTED) VALUES (2, 115705, 3, 1, 08/07/2001, 08/12/2001, 1); INSERT INTO REQUEST (REQUESTCD, ACCOUNTCD, EXECUTORCD, FAILURECD, INCOMINGDATE, EXECUTIONDATE, EXECUTED) VALUES (3, 015527, 1, 12, 02/28/1998, 03/08/1998, 0); INSERT INTO REQUEST (REQUESTCD, ACCOUNTCD, EXECUTORCD, FAILURECD, INCOMINGDATE, EXECUTIONDATE, EXECUTED) VALUES (5, 080270, 4, 1, 12/31/2001, NULL, 0);
|
© 2006 - 2024 pmbk.ru. Генерация страницы: 0
При копировании материалов приветствуются ссылки. |