USP_MKTSPONSORSHIPMAILINGPROCESSSTATUS_GETRECENT

CREATE procedure dbo.[USP_MKTSPONSORSHIPMAILINGPROCESSSTATUS_GETRECENT]
(
  @MKTSPONSORSHIPMAILINGPROCESSID uniqueidentifier
)
as
  set nocount on;

  select top 1
    [BUSINESSPROCESSSTATUS].[ID],
    [BUSINESSPROCESSSTATUS].[STATUSCODE],
    [BUSINESSPROCESSSTATUS].[STATUS],
    [BUSINESSPROCESSSTATUS].[ERRORMESSAGE],
    [APPUSER].[USERNAME],
    [BUSINESSPROCESSSTATUS].[STARTEDON],
    [BUSINESSPROCESSSTATUS].[ENDEDON],
    [BUSINESSPROCESSSTATUS].[NUMBERPROCESSED],
    [BUSINESSPROCESSSTATUS].[NUMBEROFEXCEPTIONS],
    [BUSINESSPROCESSSTATUS].[SERVERNAME],
    [BUSINESSPROCESSSTATUS].[BUSINESSPROCESSCATALOGID],
    datediff(s, [BUSINESSPROCESSSTATUS].[STARTEDON], coalesce([BUSINESSPROCESSSTATUS].[ENDEDON], getdate())) as [DURATION],
    [MKTSPONSORSHIPMAILINGPROCESSSEGMENTATION].[SEGMENTATIONID] as [MAILINGID]
  from 
    dbo.[BUSINESSPROCESSSTATUS]
  inner join 
    dbo.[APPUSER] 
  on 
    [APPUSER].[ID] = [BUSINESSPROCESSSTATUS].[STARTEDBYUSERID]
  inner join 
    dbo.[MKTSPONSORSHIPMAILINGPROCESSSTATUS] 
  on 
    [MKTSPONSORSHIPMAILINGPROCESSSTATUS].[ID] = [BUSINESSPROCESSSTATUS].[ID]
  left outer join 
    dbo.[MKTSPONSORSHIPMAILINGPROCESSSEGMENTATION] 
  on 
    [MKTSPONSORSHIPMAILINGPROCESSSEGMENTATION].[SPONSORSHIPMAILINGPROCESSSTATUSID] = [MKTSPONSORSHIPMAILINGPROCESSSTATUS].[ID]
  where 
    [MKTSPONSORSHIPMAILINGPROCESSSTATUS].[PARAMETERSETID] = @MKTSPONSORSHIPMAILINGPROCESSID
  order by 
    [BUSINESSPROCESSSTATUS].[STARTEDON] desc;

  return 0;