how to convert the below query into merge statement in sqlserver 2008r2

See more:

SQL-Server

SQL-Server-2008

Hi ,

with the below code i am getting duplicate values , i don't want duplicates for this i am thinking i need to change it into Merge statement.

can any body help me how to change the below code into merge statement

insert into [dbo].[cmscpt_new] ([Code],[Description] ,[InputOn]
 , [InputBy]  ,[CptReview],[AddedbyApplication],[Status])
   
     
  select [code],[description],getdate(),'101','n','VAN','Active'
   FROM [dbo].[cpt_load_2013]
   -- where current_update_indicator <>'D'  and Modifier ='00'
    where current_update_indicator <>'D' or current_update_indicator is null or  Modifier ='00' or
  Modifier is null 
   
   
   
   update a
   set a.[description]= b.[description] 
    from [cmscpt_new] a, [cpt_load_2013] b
   where a.[Code]=b.[Code]