DBA team defined the structure and we are not supposed to change it as it is in production..

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

I have gt this idea suggest me if i can do it in a better way .........