greeshma.patla (9/11/2012)

---

MERGE INTO LKP_PARAM_TYPE AS C

USING (

SELECT

DISTINCT RISK_PARAMETERS

FROM SRC_DOM_RETAIL_AIRB_PARAM )X -- I think this bracket is the problem, remove it

) 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);