viewde aratoplam aldirma

SELECT     TOP (100) PERCENT dbo.tblcasabit.PLASIYER_KODU AS BOLGE, CONVERT(char(11), dbo.TBLSTHAR.STHAR_TARIH, 105) AS TESLIM_TRH,
                      SUBSTRING(dbo.tblcasabit.CARI_ISIM, 1, 28) AS CARI_ISIM, dbo.TBLSTHAR.STOK_KODU, dbo.TBLSTSABIT.STOK_ADI, CONVERT(char(11),
                      dbo.TBLSTHAR.IRSALIYE_TARIH, 105) AS SIP_TRH, STR(SUM(dbo.TBLSIPATRA.STHAR_GCMIK), 11, 0) AS SIP_MIK,
                      STR(SUM(dbo.TBLSTHAR.STHAR_GCMIK), 11, 0) AS TES_MIK, STR(SUM(dbo.TBLSIPATRA.STHAR_GCMIK) - dbo.TBLSTHAR.STHAR_GCMIK, 11, 0)
                      AS BAKIYE
FROM         dbo.TBLSIPATRA FULL OUTER JOIN
                      dbo.TBLCARIKOD1 RIGHT OUTER JOIN
                      dbo.tblcasabit RIGHT OUTER JOIN
                      dbo.TBLSTHAR INNER JOIN
                      dbo.TBLSTSABIT ON dbo.TBLSTSABIT.STOK_KODU = dbo.TBLSTHAR.STOK_KODU ON
                      dbo.tblcasabit.CARI_KOD = dbo.TBLSTHAR.STHAR_ACIKLAMA ON dbo.TBLCARIKOD1.GRUP_KOD = dbo.tblcasabit.RAPOR_KODU1 ON
                      dbo.TBLSIPATRA.FISNO = dbo.TBLSTHAR.STHAR_SIPNUM AND dbo.TBLSIPATRA.STOK_KODU = dbo.TBLSTSABIT.STOK_KODU
WHERE     (dbo.TBLSTHAR.STHAR_HTUR = 'J') AND (dbo.TBLSTHAR.STHAR_FTIRSIP = '1') AND (dbo.TBLSTHAR.STHAR_TARIH > GETDATE() - 1)
GROUP BY dbo.TBLSTHAR.STOK_KODU, dbo.TBLSTHAR.STHAR_TARIH, dbo.TBLSTHAR.STHAR_ACIKLAMA, dbo.TBLSTSABIT.STOK_ADI,
                      SUBSTRING(dbo.tblcasabit.CARI_ISIM, 1, 28), dbo.TBLCARIKOD1.GRUP_ISIM, dbo.tblcasabit.RAPOR_KODU1, dbo.TBLSTSABIT.KOD_3,
                      dbo.TBLSTHAR.STHAR_NF, dbo.tblcasabit.PLASIYER_KODU, dbo.TBLSTSABIT.KOD_1, dbo.TBLSTHAR.FISNO, dbo.TBLSIPATRA.STHAR_GCMIK,
                      dbo.TBLSTHAR.IRSALIYE_TARIH, dbo.TBLSTHAR.STHAR_GCMIK