UFN_WEALTHPOINT_PENDINGRESEARCHGROUPS

                CREATE function [dbo].[UFN_WEALTHPOINT_PENDINGRESEARCHGROUPS](
            )
            returns table
            as
            return
            (
                select
                    [WPSEARCHHISTORY].[RESEARCHGROUPID] as ID
                from
                    [dbo].[WPSEARCHHISTORY]
                where
                    [WPSEARCHHISTORY].[STATUSCODE] in(0,1,2) and
                    [WPSEARCHHISTORY].[RESEARCHGROUPID] is not null    
            )