UFN_MEMBERSHIP_GETACTIVEMEMBERS

            create function dbo.UFN_MEMBERSHIP_GETACTIVEMEMBERS
            (
                @MEMBERSHIPID uniqueidentifier
            )
            returns table
            as
            return
            (
                select
                    ID,
                    CONSTITUENTID,
                    ISPRIMARY
                from
                    dbo.MEMBER
                where
                    MEMBERSHIPID = @MEMBERSHIPID
          and ISDROPPED = 0
            )