GO
/****** Object:  StoredProcedure [dbo].[Queue_Connector_GetError]    Script Date: 1/20/2019 3:23:35 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[Queue_Connector_GetError] 
       @RegionCode varchar(10), 
       @Error varchar(100), 
       @Channel nvarchar(10) 
AS 
BEGIN 
	   -- for test
	   --exec Queue_Connector_GetError @RegionCode='0',@Error='2000',@Channel='QU'
 
       SET NOCOUNT ON; 
       
       SELECT   TOP(1) 
				err.RegionCode, 
				err.Channel, 
				err.ID, 
				err.EDesc, 
				err.ADesc, 
				err.EText, 
				err.AText, 
				err.MsgFlag, 
				err.HostFlag, 
				err.ErrOption

       FROM		TblLUError as err 
       WHERE	err.RegionCode  = @RegionCode AND 
			    err.Channel		= @Channel	  AND 
				err.ID			= @Error 
    
      
END