USP_MKTACKNOWLEDGEMENTMAILINGPROCESSSTATUS_GETRECENT

CREATE procedure dbo.[USP_MKTACKNOWLEDGEMENTMAILINGPROCESSSTATUS_GETRECENT]
(
  @MKTACKNOWLEDGEMENTMAILINGPROCESSID 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],
    [MKTACKNOWLEDGEMENTMAILINGPROCESSSEGMENTATION].[SEGMENTATIONID] as [MAILINGID],
    [MKTACKNOWLEDGEMENTMAILINGPROCESSSEGMENTATION].[ACKNOWLEDGEDATE]
  from dbo.[BUSINESSPROCESSSTATUS]
  inner join dbo.[APPUSER] on [APPUSER].[ID] = [BUSINESSPROCESSSTATUS].[STARTEDBYUSERID]
  inner join dbo.[MKTACKNOWLEDGEMENTMAILINGPROCESSSTATUS] on [MKTACKNOWLEDGEMENTMAILINGPROCESSSTATUS].[ID] = [BUSINESSPROCESSSTATUS].[ID]
  left join dbo.[MKTACKNOWLEDGEMENTMAILINGPROCESSSEGMENTATION] on [MKTACKNOWLEDGEMENTMAILINGPROCESSSEGMENTATION].[ACKNOWLEDGEMENTMAILINGPROCESSSTATUSID] = [MKTACKNOWLEDGEMENTMAILINGPROCESSSTATUS].[ID]
  where [MKTACKNOWLEDGEMENTMAILINGPROCESSSTATUS].[PARAMETERSETID] = @MKTACKNOWLEDGEMENTMAILINGPROCESSID
  order by [BUSINESSPROCESSSTATUS].[STARTEDON] desc;

  return 0;