if Exists(select name from sysobjects where Name = 'fGetMandeHesab') drop function fGetMandeHesab go create function fGetMandeHesab(@pCode bigint) returns decimal(19,4) as begin declare @mande decimal(19,4); set @mande=( select sum(isnull(bes,0.0))-sum(isnull(bed,0.0)) from dbo.fAllCodeBedBes(0 , 20000000) where code=@pcode ) return @mande; end