alter proc dbo.prcKalaView @Fc_ID int ,@Pro_ID_VahedMali int as  
begin  
--begin try drop table #tempKala end try begin catch end catch  
declare @t table(Kal_ID int not null, varede float not null,sadere float not null)
insert into @t
select   
 Kal_ID,  
 sum(isnull(f.varede,0.0)) varede,  
 sum(isnull(f.sadere,0.0)) sadere  
--into #tempKala   
from dbo.fGetKalaVaredeSadere(@Fc_ID ,@Pro_ID_VahedMali,0) f  
group by Kal_ID  
  
--select * from #tempKala order by kal_ID  
select  
        k.ID ID,  
        k.Code,  
        k.Name,  
        k.EnglishName, 
        k.Pro_ID_VahedMali,
        --sum(isnull(f.varede,0.0)-isnull(f.sadere,0.0))[Mojoodi],  
        (f.varede - f.sadere) [Mojoodi],  
        isnull(k.GheymatForoosh1,0.0)[GheimatForoosh1],  
        isnull(k.GheymatForoosh2,0.0)[GheimatForoosh2],  
        isnull(k.GheymatForoosh3,0.0)[GheimatForoosh3],  
	    isnull(k.GheymatKharid1,0.0)[GheymatKharid1],  
	    isnull(k.GheymatKharid2,0.0)[GheymatKharid2],  
	    isnull(k.GheymatKharid3,0.0)[GheymatKharid3],  
        g.name[NameGrooh],  
        k.IsActive,  
        k.Pro_ID_Grooh,  
        k.TakhfifMablagh,
        k.TakhfifDarsad,
        isnull(k.gheimatForoosh,0.0)[GheimatMasrafKonandeh],  
        isnull(k.TedadVahedMotevaset,0.0)[TedadVahedMotevaset],  
        isnull(k.TedadVahedBozorg,0.0)[TedadVahedBozorg]  
from kala k   
 inner join OtherProperties g on k.Pro_ID_Grooh=g.ID  
 left join @t f on k.ID=f.Kal_ID  
order by k.ID  
end