aylik satis raporu nasil alinir (bir plasiyerin)

bu örnek belki isinizi görörür.
SELECT     TARIH, DATEPART(month, TARIH) AS ay, 'KRD' AS HAREKET_TURU, ALACAK, LEFT(ACIKLAMA, 3) AS tahsilat, PLASIYER_KODU AS pls,
                      INC_KEY_NUMBER
FROM        dbo.TBLCAHAR
WHERE     (ACIKLAMA LIKE 'KR:%')
UNION
SELECT     TARIH, DATEPART(month, TARIH) AS ay, 'NKT' AS HAREKET_TURU, ALACAK, LEFT(ACIKLAMA, 3) AS tahsilat, PLASIYER_KODU AS pls,
                      INC_KEY_NUMBER
FROM        dbo.TBLCAHAR AS TBLCAHAR_4
WHERE     (ACIKLAMA LIKE 'NAK_T TAH%') AND (NOT (ACIKLAMA LIKE '%TED_YE%'))
UNION
SELECT     TARIH, DATEPART(month, TARIH) AS ay, 'CEK' AS HAREKET_TURU, ALACAK, LEFT(ACIKLAMA, 3) AS tahsilat, PLASIYER_KODU AS pls,
                      INC_KEY_NUMBER
FROM        dbo.TBLCAHAR AS TBLCAHAR_3
WHERE     (ACIKLAMA LIKE 'ÇEK%') AND (NOT (ACIKLAMA LIKE 'ÇEK_M_Z%')) AND (NOT (ACIKLAMA LIKE 'ÇEKLER_M_Z%'))
UNION
SELECT     TARIH, DATEPART(month, TARIH) AS ay, 'SNT' AS HAREKET_TURU, ALACAK, LEFT(ACIKLAMA, 3) AS tahsilat, PLASIYER_KODU AS pls,
                      INC_KEY_NUMBER
FROM        dbo.TBLCAHAR AS TBLCAHAR_2
WHERE     (ACIKLAMA LIKE 'SEN%')
UNION
SELECT     TARIH, DATEPART(month, TARIH) AS ay, 'HVL' AS HAREKET_TURU, ALACAK, LEFT(ACIKLAMA, 3) AS tahsilat, PLASIYER_KODU AS pls,
                      INC_KEY_NUMBER
FROM        dbo.TBLCAHAR AS TBLCAHAR_1
WHERE     (ACIKLAMA LIKE 'HAV%')
UNION
SELECT     TARIH, DATEPART(month, TARIH) AS ay, KSMAS_KOD AS tip, TUTAR, LEFT(ACIKLAMA, 3) AS tahsilat, PLASIYER_KODU AS pls, SIRA
FROM        dbo.KASA
WHERE     (IO = 'G') AND (TUTAR > '0')

isinize yaradigina sevindim. ekler konusunda bos zamanin-mda çalismasini yapar buraya eklerim.