'000000000000030' nolu fiş aynen kalacak, fiş ve cari ye ait 7 tane kayıt var.
Kod: Tümünü seç
SELECT
STOK_KODU,
FISNO,
STHAR_GCMIK,
STHAR_GCKOD,
STHAR_TARIH,
STHAR_NF,
STHAR_BF,
STHAR_IAF,
STHAR_KDV,
DEPO_KODU,
STHAR_ACIKLAMA,
STHAR_FTIRSIP,
LISTE_FIAT,
STHAR_HTUR,
STHAR_ODEGUN,
STHAR_BGTIP,
STHAR_CARIKOD,
PLASIYER_KODU,
SIRA,
OLCUBR,
VADE_TARIHI,
SUBE_KODU,
D_YEDEK10,
EXPORTTYPE,
ONAYTIPI
FROM TBLSTHAR WHERE STHAR_ACIKLAMA = '000940' AND FISNO = '000000000000030'
Kod: Tümünü seç
INSERT INTO TBLSTHAR
(STOK_KODU,
FISNO,
STHAR_GCMIK,
STHAR_GCKOD,
STHAR_TARIH,
STHAR_NF,
STHAR_BF,
STHAR_IAF,
STHAR_KDV,
DEPO_KODU,
STHAR_ACIKLAMA,
STHAR_FTIRSIP,
LISTE_FIAT,
STHAR_HTUR,
STHAR_ODEGUN,
STHAR_BGTIP,
STHAR_CARIKOD,
PLASIYER_KODU,
SIRA,
OLCUBR,
VADE_TARIHI,
SUBE_KODU,
D_YEDEK10,
EXPORTTYPE,
ONAYTIPI)
VALUES
('9000033','100000000000005','6.00000000','G','2018-02-12 00:00:00','13.52000000','13.52000000','11.06800000','8.00','2','000940','2','1','J','30','F','000940','02','1','1','2018-03-14 00:00:00','0','2018-02-12 00:00:00','0','A')
SELECT
STOK_KODU,
FISNO,
STHAR_GCMIK,
STHAR_GCKOD,
STHAR_TARIH,
STHAR_NF,
STHAR_BF,
STHAR_IAF,
STHAR_KDV,
DEPO_KODU,
STHAR_ACIKLAMA,
STHAR_FTIRSIP,
LISTE_FIAT,
STHAR_HTUR,
STHAR_ODEGUN,
STHAR_BGTIP,
STHAR_CARIKOD,
PLASIYER_KODU,
SIRA,
OLCUBR,
VADE_TARIHI,
SUBE_KODU,
D_YEDEK10,
EXPORTTYPE,
ONAYTIPI
FROM TBLSTHAR WHERE STHAR_ACIKLAMA = '000940' AND FISNO = '000000000000030'