if exists (select name from dbo.sysobjects where name='fGetMojoodiKala') drop function fGetMojoodiKala go create function fGetMojoodiKala(@pcode int , @pCodeAnbar int) returns int as begin DECLARE @MyTable table ( Varedeh int, Sadereh int ); return isnull( (select sum(f.varede) - sum(f.sadere) from dbo.fGetKalaVaredeSadere() f where f.Code = @pCode and(@pCodeAnbar = 0 or @pCodeAnbar = f.CodeAnbar)) ,0); end --go --select dbo.fGetMojoodiKala(44,1)