ay ay satis raporlari

merhaba arkadaslar 2007 yilina ait ay ay satis raporu almak istiyorum bunu nerden ve nasil alirim simdiden tesekkürler..

SELECT     dbo.STHARPR.STOK_KODU, dbo.STHARPR.AY_KODU, SUM(dbo.STHARPR.STHAR_GCMIK) AS TOPLAM_SATIS_MIKTARI,
                      SUM(dbo.STHARPR.STHAR_GCMIK * dbo.STHARPR.STHAR_NF) AS TOPLAM_SATIS_TUTARI, dbo.STSABIT.GRUP_KODU, dbo.STSABIT.KOD_2,
                      dbo.STSABIT.KOD_5, dbo.STHARPR.PLASIYER_KODU, dbo.STHARPR.STHAR_KOD2
FROM        dbo.STHARPR INNER JOIN
                      dbo.STSABIT ON dbo.STHARPR.STOK_KODU = dbo.STSABIT.STOK_KODU
WHERE     (dbo.STHARPR.STHAR_GCKOD = 'C') AND (dbo.STHARPR.STHAR_HTUR = 'J' OR
                      dbo.STHARPR.STHAR_HTUR = 'K' OR
                      dbo.STHARPR.STHAR_HTUR = 'I')
GROUP BY dbo.STHARPR.STOK_KODU, dbo.STHARPR.AY_KODU, dbo.STSABIT.GRUP_KODU, dbo.STSABIT.KOD_2, dbo.STSABIT.KOD_5,
                      dbo.STHARPR.PLASIYER_KODU, dbo.STHARPR.STHAR_KOD2

buyurun bunu deneyin

tesekkürler sayin emiray

CREATE VIEW [dbo].[STHARPR] (STOK_KODU, FISNO,STHAR_GCMIK,STHAR_GCMIK2,CEVRIM,STHAR_GCKOD,

STHAR_TARIH,STHAR_NF,STHAR_BF,STHAR_IAF,STHAR_KDV, DEPO_KODU,STHAR_ACIKLAMA, STHAR_SATISK,

STHAR_MALFISK,STHAR_FTIRSIP,STHAR_SATISK2,LISTE_FIAT,STHAR_HTUR,STHAR_DOVTIP,PROMASYON_KODU,

STHAR_DOVFIAT,STRA_SATISK3,STHAR_ODEGUN,STRA_SATISK4,STRA_SATISK5,STRA_SATISK6,

STHAR_BGTIP,STHAR_KOD1,STHAR_KOD2,STHAR_SIPNUM,STHAR_CARIKOD,STHAR_SIP_TURU,

PLASIYER_KODU,EKALAN_NEDEN,EKALAN, EKALAN1,REDMIK,REDNEDEN,SIRA,STRA_SIPKONT,

AMBAR_KABULNO,FIRMA_DOVTIP,FIRMA_DOVTUT,FIRMA_DOVMAL,IRSALIYE_NO,UPDATE_KODU,

IRSALIYE_TARIH,KOSULKODU,ECZA_FAT_TIP,STHAR_TESTAR,OLCUBR,INCKEYNO,VADE_TARIHI,

LISTE_NO,BAGLANTI_NO,SUBE_KODU,MUH_KODU,S_YEDEK1,S_YEDEK2,F_YEDEK3, F_YEDEK4,

F_YEDEK5,C_YEDEK6,B_YEDEK7, I_YEDEK8,L_YEDEK9,D_YEDEK10,PROJE_KODU,

FIYATTARIHI,KOSULTARIHI,SATISK1TIP,SATISK2TIP,SATISK3TIP,SATISK4TIP,

SATISK5TIP,SATISK6TIP,EXPORTTYPE,EXPORTMIK,DUZELTMETARIHI,

ONAYTIPI,ONAYNUM,KKMALF,STRA_IRSKONT, AY_KODU)

AS SELECT TBLSTHAR.STOK_KODU,TBLSTHAR.FISNO,TBLSTHAR.STHAR_GCMIK,

TBLSTHAR.STHAR_GCMIK2,TBLSTHAR.CEVRIM,TBLSTHAR.STHAR_GCKOD,

TBLSTHAR.STHAR_TARIH,TBLSTHAR.STHAR_NF,TBLSTHAR.STHAR_BF,

TBLSTHAR.STHAR_IAF,TBLSTHAR.STHAR_KDV,TBLSTHAR.DEPO_KODU,

TBLSTHAR.STHAR_ACIKLAMA,TBLSTHAR.STHAR_SATISK,TBLSTHAR.STHAR_MALFISK,

TBLSTHAR.STHAR_FTIRSIP,TBLSTHAR.STHAR_SATISK2,TBLSTHAR.LISTE_FIAT,

TBLSTHAR.STHAR_HTUR,TBLSTHAR.STHAR_DOVTIP,TBLSTHAR.PROMASYON_KODU,

TBLSTHAR.STHAR_DOVFIAT,TBLSTHAR.STRA_SATISK3,TBLSTHAR.STHAR_ODEGUN,

TBLSTHAR.STRA_SATISK4,TBLSTHAR.STRA_SATISK5,TBLSTHAR.STRA_SATISK6,TBLSTHAR.STHAR_BGTIP,

TBLSTHAR.STHAR_KOD1,TBLSTHAR.STHAR_KOD2,TBLSTHAR.STHAR_SIPNUM,

TBLSTHAR.STHAR_CARIKOD,TBLSTHAR.STHAR_SIP_TURU,TBLSTHAR.PLASIYER_KODU,TBLSTHAR.EKALAN_NEDEN,

TBLSTHAR.EKALAN,TBLSTHAR.EKALAN1,TBLSTHAR.REDMIK,TBLSTHAR.REDNEDEN,TBLSTHAR.SIRA,

TBLSTHAR.STRA_SIPKONT,TBLSTHAR.AMBAR_KABULNO,TBLSTHAR.FIRMA_DOVTIP,TBLSTHAR.FIRMA_DOVTUT,TBLSTHAR.FIRMA_DOVMAL,

TBLSTHAR.IRSALIYE_NO,TBLSTHAR.UPDATE_KODU,TBLSTHAR.IRSALIYE_TARIH,TBLSTHAR.KOSULKODU,

TBLSTHAR.ECZA_FAT_TIP,TBLSTHAR.STHAR_TESTAR,TBLSTHAR.OLCUBR, INCKEYNO, TBLSTHAR.VADE_TARIHI,

TBLSTHAR.LISTE_NO,TBLSTHAR.BAGLANTI_NO,TBLSTHAR.SUBE_KODU,TBLSTHAR.MUH_KODU, TBLSTHAR.S_YEDEK1,TBLSTHAR.S_YEDEK2,

TBLSTHAR.F_YEDEK3,TBLSTHAR.F_YEDEK4,TBLSTHAR.F_YEDEK5,TBLSTHAR.C_YEDEK6,TBLSTHAR.B_YEDEK7, TBLSTHAR.I_YEDEK8,TBLSTHAR.L_YEDEK9,

TBLSTHAR.D_YEDEK10,TBLSTHAR.PROJE_KODU,TBLSTHAR.FIYATTARIHI,TBLSTHAR.KOSULTARIHI,TBLSTHAR.SATISK1TIP,

TBLSTHAR.SATISK2TIP,TBLSTHAR.SATISK3TIP,TBLSTHAR.SATISK4TIP,TBLSTHAR.SATISK5TIP,

TBLSTHAR.SATISK6TIP, TBLSTHAR.EXPORTTYPE,TBLSTHAR.EXPORTMIK,TBLSTHAR.DUZELTMETARIHI,

TBLSTHAR.ONAYTIPI,TBLSTHAR.ONAYNUM,TBLSTHAR.KKMALF,TBLSTHAR.STRA_IRSKONT,

DATEPART(MONTH,TBLSTHAR.STHAR_TARIH) FROM TBLSTHAR

Hatayi yazsaydin nedenlerini söyleyebilirdik.