USP_SIMPLEDATALIST_RECENTAPPEALS

CREATE procedure dbo.USP_SIMPLEDATALIST_RECENTAPPEALS
(
    @CONSTITUENTID uniqueidentifier = null, 
    @APPEALID uniqueidentifier = null
)
as
    select 
        VALUE,
        LABEL,
        DESCRIPTION 
    from (
        select
            A.ID as VALUE,
            A.NAME as LABEL,
            null as DESCRIPTION
        from dbo.APPEAL A
        where A.ID = @APPEALID

        union

        select distinct top 5
            APPEAL.ID as VALUE,
            APPEAL.NAME as LABEL,
            coalesce([CONSTITUENTAPPEAL].[DATESENT], [MKTSEGMENTATION].[MAILDATE], [MKTSEGMENTATION].[ACTIVATEDATE]) as DESCRIPTION
        from dbo.CONSTITUENTAPPEAL
        inner join dbo.APPEAL 
            on CONSTITUENTAPPEAL.APPEALID = APPEAL.ID
        inner join dbo.MKTSEGMENTATION
            on MKTSEGMENTATION.ID = CONSTITUENTAPPEAL.MKTSEGMENTATIONID
        where CONSTITUENTAPPEAL.CONSTITUENTID = @CONSTITUENTID
        order by coalesce([CONSTITUENTAPPEAL].[DATESENT], [MKTSEGMENTATION].[MAILDATE], [MKTSEGMENTATION].[ACTIVATEDATE])
    ) as T
    order by T.DESCRIPTION desc