USP_DATALIST_CONSTITUENTISPREVIOUSGROUPMEMBER

CREATE procedure dbo.USP_DATALIST_CONSTITUENTISPREVIOUSGROUPMEMBER
(
  @GROUPID uniqueidentifier,
  @POSSIBLEPREVIOUSMEMBERID uniqueidentifier
)
as
  set nocount on;

  declare @CURRENTDATE datetime = getdate();
  declare @ISPREVIOUSMEMBER bit = 0;
  declare @STARTDATE datetime;
  declare @ENDDATE datetime;
  declare @COMMENTS nvarchar(300);

  select 
    @ISPREVIOUSMEMBER = 1,
    @STARTDATE = GMDR.DATEFROM,
    @ENDDATE = GMDR.DATETO,
    @COMMENTS = GMDR.COMMENTS
  from
    dbo.GROUPMEMBER GM 
  inner join
    dbo.GROUPMEMBERDATERANGE GMDR on GM.ID = GMDR.GROUPMEMBERID
  where
    GM.GROUPID = @GROUPID and
    GM.MEMBERID = @POSSIBLEPREVIOUSMEMBERID and
    GMDR.DATETO is not null and
    (GMDR.DATEFROM > @CURRENTDATE or GMDR.DATETO <= @CURRENTDATE)

  select
    @ISPREVIOUSMEMBER as ISPREVIOUSMEMBER,
    @STARTDATE as STARTDATE,
    @ENDDATE as ENDDATE,
    @COMMENTS as COMMENTS