alter function fGetMojoodiKala(@Fc_ID as integer =0, @Pro_ID_VahedMali as integer, @Kal_ID int , @Anb_ID int, @EndDate as integer=0) returns int as begin DECLARE @MyTable table ( Varedeh int, Sadereh int ); return isnull( (select sum(f.varede) - sum(f.sadere) from dbo.fGetKalaVaredeSadere(@Fc_ID,@Pro_ID_VahedMali,@EndDate) f where f.Kal_ID = @Kal_ID and(@Anb_ID = 0 or @Anb_ID = f.Pro_ID_Anbar)) ,0); end