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]
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)