UFN_CONSTITUENT_GETGROUPROLES

create function dbo.UFN_CONSTITUENT_GETGROUPROLES(
    @GROUPMEMBERID uniqueidentifier
)
returns table
as return
    select
        GROUPMEMBERROLE.ID,
        GROUPMEMBERROLE.GROUPMEMBERROLECODEID,
        GROUPMEMBERROLE.STARTDATE,
        GROUPMEMBERROLE.ENDDATE
    from dbo.GROUPMEMBERROLE
    where GROUPMEMBERROLE.GROUPMEMBERID = @GROUPMEMBERID