USP_DATAFORMTEMPLATE_VIEW_BBNCTRANSACTIONDOWNLOADEXCEPTION

        CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_BBNCTRANSACTIONDOWNLOADEXCEPTION
        (
            @ID uniqueidentifier,
            @DATALOADED bit = 0 output,
            @TRANSACTIONFIELDS xml = null output,
            @EXCEPTIONMESSAGE nvarchar(1024) = null output,
            @WEBHEALTHINFORMATION nvarchar(4000) = null output
        )
        as
            set nocount on;

            -- be sure to set this, in case the select returns no rows
            set @DATALOADED = 0;

            -- populate the output parameters, which correspond to fields on the form.  Note that
            -- we set @DATALOADED = 1 to indicate that the load was successful.  Otherwise, the system
            -- will display a "no data loaded" message.
            select
              @DATALOADED = 1,
              @TRANSACTIONFIELDS = TRANSACTIONFIELDS,
              @EXCEPTIONMESSAGE = EXCEPTIONMESSAGE,
              @WEBHEALTHINFORMATION = WEBHEALTHINFORMATION
          from 
              dbo.BBNCTRANSACTIONDOWNLOADEXCEPTION 
          where 
              ID = @ID;

            return 0;