fnHeirTaskRight

                CREATE FUNCTION dbo.fnHeirTaskRight(@ClientUsersID int, @ClientsID int, @Guid uniqueidentifier, @hasaccess bit) RETURNS bit As 
BEGIN
declare @overrideguid as uniqueidentifier
begin
    if (@hasaccess=0 AND NOT @Guid is null)
        begin
            SELECT @overrideguid=OverridingGuid FROM ApplicationTasks WHERE Guid=@Guid AND OverridingGuid<>@Guid
            if(NOT @overrideguid is null) 
                SELECT @hasaccess=dbo.fnHeirTaskRight(@ClientUsersID,@ClientsID,@overrideguid,CanEdit) from dbo.fnUserPrivs(@ClientUsersID,@ClientsID,5) where ObjectGuid=@overrideguid
        end
    end
    return coalesce(@hasaccess,0)
end