UFN_PROSPECTTEAM_MEMBERS

      CREATE function dbo.UFN_PROSPECTTEAM_MEMBERS(@PROSPECTID uniqueidentifier)
            returns table  
      as 
        return ( 
        select ID, MEMBERID, NAME, DATEFROM, PROSPECTTEAMROLECODEID, ROLEDESCRIPTION, SITENAME
        from dbo.V_PROSPECTTEAM
        where PROSPECTID = @PROSPECTID and
        (dbo.UFN_CONSTITUENT_ISFUNDRAISER(MEMBERID) = 1) and
        ((DATETO is null) OR (DATETO >= getdate()))
        );