USP_DATALIST_BBISBUSINESSPROCESSSTATUS

CREATE procedure dbo.USP_DATALIST_BBISBUSINESSPROCESSSTATUS
    as

  set nocount on;

  select 
    BPC.NAME,
    a.BUSINESSPROCESSCATALOGID,
    a.STATUS,
    a.ERRORMESSAGE,
    a.NUMBEROFEXCEPTIONS,
    a.DATEADDED 
  from (
        --Process CMS Email Business Process

        select top 1 BUSINESSPROCESSCATALOGID , [STATUS], ERRORMESSAGE, NUMBEROFEXCEPTIONS , DATEADDED from dbo.BUSINESSPROCESSSTATUS 
        where BUSINESSPROCESSCATALOGID = '6F6A65C4-15C8-4412-99B8-D6BB3C66E412' 
        order by DATEADDED desc
        union all
        --CMS List Refresh Business Process

        select top 1 BUSINESSPROCESSCATALOGID , [STATUS], ERRORMESSAGE, NUMBEROFEXCEPTIONS , DATEADDED from dbo.BUSINESSPROCESSSTATUS 
        where BUSINESSPROCESSCATALOGID = '2B566163-8B91-428C-B4B6-B90AB1434D58' 
        order by DATEADDED desc
        union all
        --CMS Role Refresh Business Process

        select top 1 BUSINESSPROCESSCATALOGID , [STATUS], ERRORMESSAGE, NUMBEROFEXCEPTIONS , DATEADDED from dbo.BUSINESSPROCESSSTATUS 
        where BUSINESSPROCESSCATALOGID = '21670EF3-992B-4FD3-AC83-320691E7F827' 
        order by DATEADDED desc
        union all
        --CMS Fundraiser Synchronization Process

        select top 1 BUSINESSPROCESSCATALOGID , [STATUS], ERRORMESSAGE, NUMBEROFEXCEPTIONS , DATEADDED from dbo.BUSINESSPROCESSSTATUS 
        where BUSINESSPROCESSCATALOGID = '08BD6029-02D7-46BF-BA05-0607F95E77E2' 
        order by DATEADDED desc
        union all
        --CMS Data Integration Process

        select top 1 BUSINESSPROCESSCATALOGID , [STATUS], ERRORMESSAGE, NUMBEROFEXCEPTIONS , DATEADDED from dbo.BUSINESSPROCESSSTATUS 
        where BUSINESSPROCESSCATALOGID = '23796B55-70F5-40F0-9AC8-3C199E73A172' 
        order by DATEADDED desc
        union all
        --CMS User Import Business Process

        select top 1 BUSINESSPROCESSCATALOGID , [STATUS], ERRORMESSAGE, NUMBEROFEXCEPTIONS , DATEADDED from dbo.BUSINESSPROCESSSTATUS 
        where BUSINESSPROCESSCATALOGID = '2F72ADCF-A190-4F40-8178-740C85FDC02E' 
        order by DATEADDED desc
        union all
        --CMS Advocacy Delivery Status Update Process

        select top 1 BUSINESSPROCESSCATALOGID , [STATUS], ERRORMESSAGE, NUMBEROFEXCEPTIONS , DATEADDED from dbo.BUSINESSPROCESSSTATUS 
        where BUSINESSPROCESSCATALOGID = '4C52CC2E-69CB-47AC-96DA-D056A7676627' 
        order by DATEADDED desc
        union all
        --CMS Migrate Anonymous Email Preferences

        select top 1 BUSINESSPROCESSCATALOGID , [STATUS], ERRORMESSAGE, NUMBEROFEXCEPTIONS , DATEADDED from dbo.BUSINESSPROCESSSTATUS 
        where BUSINESSPROCESSCATALOGID = 'BC2D6505-302A-4E89-8C51-69492105E75D' 
        order by DATEADDED desc
        union all
        --CMS BBPay Template Update Business Process

        select top 1 BUSINESSPROCESSCATALOGID , [STATUS], ERRORMESSAGE, NUMBEROFEXCEPTIONS , DATEADDED from dbo.BUSINESSPROCESSSTATUS 
        where BUSINESSPROCESSCATALOGID = '00923D84-40BF-4A43-9885-5E90FF3CAD22' 
        order by DATEADDED desc
        union all
        --CMS Delete Email Business Process

        select top 1 BUSINESSPROCESSCATALOGID , [STATUS], ERRORMESSAGE, NUMBEROFEXCEPTIONS , DATEADDED from dbo.BUSINESSPROCESSSTATUS 
        where BUSINESSPROCESSCATALOGID = '3db7d505-cb6d-42dc-ac87-e7e550437802' 
        order by DATEADDED desc
    union all
    --CMS Inactive Recipient Business Process

    select top 1 BUSINESSPROCESSCATALOGID , [STATUS], ERRORMESSAGE, NUMBEROFEXCEPTIONS , DATEADDED 
    from dbo.BUSINESSPROCESSSTATUS 
        where BUSINESSPROCESSCATALOGID = '1af781f9-ba9f-41b8-b994-921aa1de7619' 
        order by DATEADDED desc
    ) a
inner join
dbo.BUSINESSPROCESSCATALOG BPC 
on a.BUSINESSPROCESSCATALOGID = BPC.ID
order by DATEADDED desc;