USP_SIMPLEDATALIST_SEGMENTATIONRECENT

    CREATE procedure dbo.USP_SIMPLEDATALIST_SEGMENTATIONRECENT
    (
        @CONSTITUENTID uniqueidentifier = null
        , @EFFORTID uniqueidentifier = null
    )
    as
      select 
        S.VALUE,
        S.LABEL,
        S.DESCRIPTION 
      from (
        select 
          MKT.ID as VALUE
          , MKT.NAME as LABEL
          , isnull(MKT.MAILDATE, MKT.ACTIVATEDATE) as DESCRIPTION
        from dbo.MKTSEGMENTATION MKT
        where MKT.ID = @EFFORTID
      union
        select top(5)
          [MKTSEGMENTATION].[ID] as VALUE,
          [MKTSEGMENTATION].[NAME] as LABEL,
          coalesce([CONSTITUENTAPPEAL].[DATESENT], [MKTSEGMENTATION].[MAILDATE], [MKTSEGMENTATION].[ACTIVATEDATE]) as DESCRIPTION
        from dbo.[CONSTITUENTAPPEAL]  
        inner join dbo.[MKTSEGMENTATION] 
            on [MKTSEGMENTATION].[ID] = [CONSTITUENTAPPEAL].[MKTSEGMENTATIONID]
        where [CONSTITUENTAPPEAL].[CONSTITUENTID] = @CONSTITUENTID
            and [MKTSEGMENTATION].[MAILINGTYPECODE] in (0,2)        -- Enterprise Direct Marketing Effort and Membership efforts

            and [MKTSEGMENTATION].[COMMUNICATIONTYPECODE] in (0,1)    -- Appeal mailings

        order by coalesce([CONSTITUENTAPPEAL].[DATESENT], [MKTSEGMENTATION].[MAILDATE], [MKTSEGMENTATION].[ACTIVATEDATE]) desc
      ) S
      order by S.DESCRIPTION desc