Ïðîãðàììèðîâàíèå >>  Ïîñòðîåíèå çàïðîñîâ sql 

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


INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (18, 443069, 2, 38.5, 8, 2001);

INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (6, 136160, 1, 18.3, 1, 1998);

INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (20, 015527, 1, 28.32, 7, 1998);

INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (21, 080047, 1, 19.56, 3, 1998);

INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (22, 080613, 1, 10.6, 9, 1998);

INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (23, 443069, 1, 38.28, 12, 1998);

INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (24, 015527, 1, 38.32, 4, 1999);

INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (25, 115705, 1, 37.15, 10, 1999);

INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (26, 080613, 1, 12.6, 8, 2000);

INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (27, 136169, 1, 25.32, 1, 1999);

INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (28, 080270, 1, 57.1, 2, 1998);

INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (29, 136159, 1, 8.3, 8, 1999);

INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (30, 005488, 1, 62.13, 4, 2000);

INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (31, 115705, 1, 37.8, 5, 2001);

INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (32, 443690, 1, 17.8, 6, 1998);



INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (33, 080047, 1, 22.56, 5, 1999);

INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (34, 126112, 1, 15.3, 8, 2000);

INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (35, 080047, 1, 32.56, 9, 2001);

INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (36, 080613, 1, 12.6, 4, 1998);

INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (37, 115705, 1, 37.15, 11, 1999);

INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (38, 080270, 1, 58.1, 12, 2000);

INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (39, 136169, 1, 28.32, 1, 2001);

INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (40, 015527, 1, 18.32, 2, 1998);

INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (41, 443690, 1, 21.67, 3, 1999);

INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (42, 080613, 1, 22.86, 4, 2000);

INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (43, 080270, 1, 60.1, 5, 2001);

INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (44, 136169, 1, 28.32, 2, 1998);

INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (45, 080047, 1, 22.2, 7, 1999);

INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (46, 126112, 1, 25.3, 8, 2001);

INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (47, 443069, 1, 38.32, 9, 2001);



INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (48, 136159, 1, 8.3, 10, 1998);

INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (49, 115705, 1, 37.15, 6, 1999);

INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD,

GAZSERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR)

VALUES (50, 136160, 1, 18.3, 12, 2000);

COMMIT WORK;

/ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë ùßë I rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 I

/* Insert PAYSUMMA */

rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 rf9 I

INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (1, 005488, 2, 58.7, 01/08/2002, 12, 2001);

INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD,

PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (2, 005488, 2, 46,

01/06/2001, 12, 2000);

INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD,

PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (3, 005488, 2, 56,

05/06/1999, 4, 1999);

INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (4, 115705, 2, 40, 02/10/2000, 1, 2000);

INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (5, 115705, 2, 250, 10/03/2001, 9, 2001);

INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (6, 136160, 2, 20, 06/13/2001, 5, 2001);

INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (7, 136160, 2, 56, 02/12/1999, 1, 1999);

INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (8, 136169, 2, 20, 06/22/2001, 5, 2001);

INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD,

PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (9, 080047, 2, 80,

11/26/1998, 10, 1998);

INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, GAZSERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (10, 080047, 2, 80, 11/21/2001, 10, 2001);



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

© 2006 - 2024 pmbk.ru. Ãåíåðàöèÿ ñòðàíèöû: 0
Ïðè êîïèðîâàíèè ìàòåðèàëîâ ïðèâåòñòâóþòñÿ ññûëêè.
ßíäåêñ.Ìåòðèêà