declare @aa int
set @aa = 1
update EWC_HT_Contract
set ContractCode = a.ContractCode + cast (@aa as nvarchar(10)),@aa = @aa +1
from
(
select ContractCode
from Contract
where MasterID = 1
) as a
where MasterID = 2
