USP_MKTMEMBERSHIPMAILINGPROCESSSTATUS_GETRECENT

CREATE procedure dbo.[USP_MKTMEMBERSHIPMAILINGPROCESSSTATUS_GETRECENT]
(
  @MKTMEMBERSHIPMAILINGPROCESSID 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],
    [MKTMEMBERSHIPMAILINGPROCESSSEGMENTATION].[SEGMENTATIONID] as [MAILINGID]
  from 
    dbo.[BUSINESSPROCESSSTATUS]
  inner join 
    dbo.[APPUSER] 
  on 
    [APPUSER].[ID] = [BUSINESSPROCESSSTATUS].[STARTEDBYUSERID]
  inner join 
    dbo.[MKTMEMBERSHIPMAILINGPROCESSSTATUS] 
  on 
    [MKTMEMBERSHIPMAILINGPROCESSSTATUS].[ID] = [BUSINESSPROCESSSTATUS].[ID]
  left outer join 
    dbo.[MKTMEMBERSHIPMAILINGPROCESSSEGMENTATION] 
  on 
    [MKTMEMBERSHIPMAILINGPROCESSSEGMENTATION].[MEMBERSHIPMAILINGPROCESSSTATUSID] = [MKTMEMBERSHIPMAILINGPROCESSSTATUS].[ID]
  where 
    [MKTMEMBERSHIPMAILINGPROCESSSTATUS].[PARAMETERSETID] = @MKTMEMBERSHIPMAILINGPROCESSID
  order by 
    [BUSINESSPROCESSSTATUS].[STARTEDON] desc;

  return 0;