Netsis de KDV leri ayırmak istedim ama beceremedim şöyle ;
%1, %8, %18 KDV Oranları ve %1 KDV Tutarı, %8 KDV Tutarı, %18 KDV Tutarı şeklinde sütün sütün ayırmak istiyorum yardımcı olur musunuz ?
Kod: Tümünü seç
SELECT STHAR_TARIH,FISNO,CARI_ISIM,VERGI_NUMARASI,TCKIMLIKNO,STHAR_KDV AS KDV_ORAN1,STHAR_KDV AS KDV_ORAN8,STHAR_KDV AS KDV_ORAN18,STHAR_FTIRSIP,TBLSTHAR.STHAR_GCMIK,STHAR_NF,GENELTOPLAM,
TBLSTHAR.STHAR_NF AS NETCIKISTUT1, (CASE WHEN TBLSTHAR.STHAR_KDV = 1 THEN TBLSTHAR.STHAR_KDV ELSE 0 END) * TBLSTHAR.STHAR_KDV,
TBLSTHAR.STHAR_GCMIK * TBLSTHAR.STHAR_NF * TBLSTHAR.STHAR_KDV / 100 AS KDV_TUT1,
TBLSTHAR.STHAR_NF AS NETCIKISTUT8, (CASE WHEN TBLSTHAR.STHAR_KDV = 8 THEN TBLSTHAR.STHAR_KDV ELSE 0 END) * TBLSTHAR.STHAR_KDV,
TBLSTHAR.STHAR_GCMIK * TBLSTHAR.STHAR_NF * TBLSTHAR.STHAR_KDV / 100 AS KDV_TUT8,
TBLSTHAR.STHAR_NF AS NETCIKISTUT18, (CASE WHEN TBLSTHAR.STHAR_KDV =18 THEN TBLSTHAR.STHAR_KDV ELSE 0 END) * TBLSTHAR.STHAR_KDV,
TBLSTHAR.STHAR_GCMIK * TBLSTHAR.STHAR_NF * TBLSTHAR.STHAR_KDV / 100 AS KDV_TUT18
FROM TBLSTHAR INNER JOIN TBLCASABIT ON TBLSTHAR.STHAR_CARIKOD=TBLCASABIT.CARI_KOD
INNER JOIN TBLCASABITEK ON TBLCASABITEK.CARI_KOD=TBLSTHAR.STHAR_CARIKOD
INNER JOIN TBLFATUIRS ON TBLSTHAR.STHAR_CARIKOD=TBLFATUIRS.CARI_KODU