USP_DATALIST_CONSTITUENT_GROUPMEMBERSHIPPREVIOUS

                    CREATE procedure dbo.USP_DATALIST_CONSTITUENT_GROUPMEMBERSHIPPREVIOUS
          (
            @CONSTITUENTID uniqueidentifier
          )
          as
            set nocount on;

            select
              GD.ID as GROUPID,
              C.NAME as GROUPNAME,
              case
                when GD.GROUPTYPECODE = 0 then 'Household'
                when GD.GROUPTYPECODE = 1 then (select GT.NAME from dbo.GROUPTYPE GT where GT.ID = GD.GROUPTYPEID)
              end as GROUPTYPE,
              GMDR.DATEFROM as MEMBERDATEFROM,
              GMDR.DATETO as MEMBERDATETO,
              GMDR.COMMENTS as COMMENTS,
              GMDR.ID as GROUPMEMBERDATERANGEID,
                    case
                      when GD.GROUPTYPECODE  = 0 then 1
                      else 0
                    end as ISHOUSEHOLD,
                    GM.ID as GROUPMEMBERID,
              case 
                when DG.ID is null then 0 else 1 
              end as ISDISSOLVED,
              dbo.UDA_BUILDLIST(ORDEREDROLES.DESCRIPTION)
            from 
              dbo.GROUPMEMBER GM
            inner join 
              dbo.GROUPDATA GD on GD.ID = GM.GROUPID
            inner join 
              dbo.CONSTITUENT C on C.ID = GD.ID
            left join 
              dbo.GROUPMEMBERDATERANGE GMDR on GMDR.GROUPMEMBERID = GM.ID
            left join
              dbo.DISSOLVEDGROUP DG on DG.ID = GM.GROUPID
            outer apply
              (select top 10 GMRC.DESCRIPTION
               from dbo.GROUPMEMBERROLE GMR
               inner join dbo.GROUPMEMBERROLECODE GMRC on GMRC.ID = GMR.GROUPMEMBERROLECODEID
               where GMR.GROUPMEMBERID = GM.ID
               order by case when GMR.ENDDATE is not null then 1 else 0 end,
               GMR.ENDDATE desc, GMR.STARTDATE, GMRC.DESCRIPTION) as ORDEREDROLES
            where 
              GM.MEMBERID = @CONSTITUENTID
            and 
              dbo.UFN_GROUPMEMBER_ISCURRENTMEMBER(GM.ID) = 0
            group by
              GD.ID, C.ID, C.NAME, GD.GROUPTYPECODE, GD.GROUPTYPEID, GM.ID, GM.GROUPID,
              GMDR.ID, GMDR.DATEFROM, GMDR.DATETO, GMDR.COMMENTS, DG.ID
            order by
              MEMBERDATETO DESC