CREATE TABLE [dbo].[LKP_PARAM_TYPE](
	[PARAM_TYPE_ID] [int] NOT NULL,
	[PARAM_DESC] [varchar](50) NOT NULL,
 CONSTRAINT [XPKLKP_PARAM_TYPE] PRIMARY KEY CLUSTERED 
(
	[PARAM_TYPE_ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



CREATE TABLE [dbo].[SRC_DOM_RETAIL_AIRB_PARAM](
	[RISK_PARAMETERS] [varchar](20) NOT NULL,
	[A_WEIGHT_IN_WITHOUT_FACTOR] [numeric](18, 2) NOT NULL
) ON [PRIMARY]

INSERT SRC_DOM_RETAIL_AIRB_PARAM(RISK_PARAMETERS,A_WEIGHT_IN_WITHOUT_FACTOR) VALUES('pd_ec','0.00')
INSERT SRC_DOM_RETAIL_AIRB_PARAM(RISK_PARAMETERS,A_WEIGHT_IN_WITHOUT_FACTOR) VALUES('pd_rc','0.00')
INSERT SRC_DOM_RETAIL_AIRB_PARAM(RISK_PARAMETERS,A_WEIGHT_IN_WITHOUT_FACTOR) VALUES('eadf_ec','0.00')
INSERT SRC_DOM_RETAIL_AIRB_PARAM(RISK_PARAMETERS,A_WEIGHT_IN_WITHOUT_FACTOR) VALUES('eadf_rc','0.00')
INSERT SRC_DOM_RETAIL_AIRB_PARAM(RISK_PARAMETERS,A_WEIGHT_IN_WITHOUT_FACTOR) VALUES('lgd_ec','1.00')
INSERT SRC_DOM_RETAIL_AIRB_PARAM(RISK_PARAMETERS,A_WEIGHT_IN_WITHOUT_FACTOR) VALUES('lgd_rc','0.00')


DECLARE @MAX_ID INT 
     
SELECT  @MAX_ID = MAX(PARAM_TYPE_ID) FROM LKP_PARAM_TYPE 
	 
IF @MAX_ID IS NULL 
SET @MAX_ID=0
	

MERGE INTO        LKP_PARAM_TYPE AS C 
 USING        ( 
							                     SELECT         
                                 DISTINCT RISK_PARAMETERS 
                                 FROM          SRC_DOM_RETAIL_AIRB_PARAM )X
                                
                         ) AS CT 
        ON                  C.PARAM_DESC = CT.RISK_PARAMETERS 
        WHEN                NOT MATCHED 
        THEN 
        INSERT(PARAM_TYPE_ID,PARAM_DESC) 
        VALUES(@MAX_ID+1,CT.RISK_PARAMETERS); 

SELECT @MAX_ID = MAX(PARAM_TYPE_ID) FROM LKP_PARAM_TYPE 
	 
	 IF	@MAX_ID IS NULL 
	 SET	@MAX_ID=0
	 MERGE INTO    LKP_PARAM_TYPE AS C 
     USING        ( 
						SELECT RISK_PARAMETERS
						,ROW_NUMBER()OVER(ORDER BY RISK_PARAMETERS)+@MAX_ID AS ID
						FROM
						(
                         SELECT	 
						 DISTINCT RISK_PARAMETERS
						 FROM	  SRC_DOM_RETAIL_AIRB_PARAM 
						 						)X  
                   ) AS CT 
      ON           C.PARAM_DESC = CT.RISK_PARAMETERS 
      WHEN         NOT MATCHED 
      THEN 
      INSERT(PARAM_TYPE_ID,PARAM_DESC) 
      VALUES(ID,CT.RISK_PARAMETERS);