UFN_RESEARCHGROUP_LASTWEALTHPOINTUPDATE

create function dbo.UFN_RESEARCHGROUP_LASTWEALTHPOINTUPDATE(
  @RESEARCHGROUPID uniqueidentifier
)
returns date
with execute as caller
as begin
        declare @DATERETRIEVED date;
        select top 1 @DATERETRIEVED = DATERETRIEVED 
            from dbo.WPSEARCHHISTORY 
            where @RESEARCHGROUPID = RESEARCHGROUPID 
            order by DATERETRIEVED desc

        return @DATERETRIEVED
end