USP_DATALIST_IMPORTPROCESSEXCEPTION

List of exceptions which occurred during an import process.

Parameters

Parameter	Parameter Type	Mode	Description
@BUSINESSPROCESSSTATUSID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



CREATE procedure dbo.USP_DATALIST_IMPORTPROCESSEXCEPTION(@BUSINESSPROCESSSTATUSID uniqueidentifier)
with execute as caller
as
    set nocount on;

    select IMPORTPROCESSEXCEPTION.MESSAGE,
        IMPORTPROCESSEXCEPTION.ROWNUMBER,
        row_number() over (order by IMPORTPROCESSEXCEPTION.ROWNUMBER) EXCEPTIONROWNUMBER,
        IMPORTPROCESSEXCEPTION.ID
    from dbo.IMPORTPROCESSEXCEPTION 
    where BUSINESSPROCESSSTATUSID = @BUSINESSPROCESSSTATUSID
    order by IMPORTPROCESSEXCEPTION.ROWNUMBER;