Программирование >>  Построение запросов sql 

1 ... 96 97 98 [ 99 ] 100 101


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);



1 ... 96 97 98 [ 99 ] 100 101

© 2006 - 2024 pmbk.ru. Генерация страницы: 0
При копировании материалов приветствуются ссылки.
Яндекс.Метрика