UFN_GROUP_GETCURRENTMEMBERSNOPERMISSIONCHECK

            CREATE function dbo.UFN_GROUP_GETCURRENTMEMBERSNOPERMISSIONCHECK
            (
                @GROUPID uniqueidentifier
            )
            returns @members table
            (
                ID uniqueidentifier
            )
            as
            begin
                declare @CURRENTDATEEARLIESTTIME date;
                set @CURRENTDATEEARLIESTTIME = getdate();

                insert into @members (ID)
                select
                    GM.MEMBERID
                from dbo.GROUPMEMBER as GM
                left join dbo.GROUPMEMBERDATERANGE as GMDR on GM.ID = GMDR.GROUPMEMBERID
                where ((GMDR.DATEFROM is null and (GMDR.DATETO is null or GMDR.DATETO > @CURRENTDATEEARLIESTTIME))
                    or (GMDR.DATETO is null and (GMDR.DATEFROM is null or GMDR.DATEFROM <= @CURRENTDATEEARLIESTTIME)) 
                    or (GMDR.DATEFROM <= @CURRENTDATEEARLIESTTIME and GMDR.DATETO > @CURRENTDATEEARLIESTTIME))
                and GM.GROUPID = @GROUPID

                return
            end