USP_REPORT_STANDINGORDERSIMPORTPROCESS_EXCEPTION

            CREATE procedure dbo.USP_REPORT_STANDINGORDERSIMPORTPROCESS_EXCEPTION
            (
                @ID nvarchar(36)
            )
            with execute as owner
            as
            set nocount on;

            exec dbo.USP_GET_KEY_ACCESS

            begin try

                select 
                    STANDINGORDERSIMPORTPROCESSEXCEPTION.MESSAGE,
                    STANDINGORDERSIMPORTPROCESSEXCEPTION.ROWNUMBER,
                    convert(nvarchar(50),decryptbykey(STANDINGORDERSIMPORTPROCESSEXCEPTION.ACCOUNTNUMBER)) ACCOUNTNUMBER,
                    STANDINGORDERSIMPORTPROCESSEXCEPTION.SORTCODE,
                    STANDINGORDERSIMPORTPROCESSEXCEPTION.TRANSACTIONAMOUNT,
                    STANDINGORDERSIMPORTPROCESSEXCEPTION.TRANSACTIONDATE,
                    STANDINGORDERSIMPORTPROCESSEXCEPTION.CONSTITUENTLOOKUPID,
                    STANDINGORDERSIMPORTPROCESSEXCEPTION.CONSTITUENTNAME,
                    STANDINGORDERSIMPORTPROCESSEXCEPTION.REFERENCENUMBER
                from
                    dbo.STANDINGORDERSIMPORTPROCESSEXCEPTION
                where
                    BUSINESSPROCESSSTATUSID = @ID;

                close symmetric key sym_BBInfinity

            end try
            begin catch
                close symmetric key sym_BBInfinity
                exec dbo.USP_RAISE_ERROR;
                return 1;
            end catch

            return 0;