MERGE INTO [CURRENCYRATES] as CC  
USING( 
select   isnull((select max(AUTOKEY) from [CURRENCYRATES] ),0)+(Row_Number()over(order by current_timestamp))  AUTOKEY, 
 '810' BASECURRCODE,  
NULL CLIENT,  
COD CURRCODE,  
CURRENCY_FROM CURRISOCODE,  
RATE_DATE DATETIMERATEBEG,  
NULL DATETIMERATEEND,  
RATE ,  
'ЦБ РФ' RATETYPE, 
 '1' SCALE  from  (       
select 
convert(datetime,'2014-11-29',121) rate_date, '41.9138000000' rate,'AUD ' currency_from,'036 ' COD    
union all  select 
convert(datetime,'2014-11-29',121) rate_date, '43.3333000000' rate, 'CAD ' currency_from,'124 ' COD    
union all  select 
convert(datetime,'2014-11-29',121) rate_date, '8.0283200000' rate, 'CNY ' currency_from,'156 ' COD    
union all  select 
convert(datetime,'2014-11-29',121) rate_date, '0.4171350000' rate, 'JPY ' currency_from,'392 ' COD    
union all  select 
convert(datetime,'2014-11-29',121) rate_date, '51.0316000000' rate, 'CHF ' currency_from,'756 ' COD   
union all  select 
convert(datetime,'2014-11-29',121) rate_date, '77.3813000000' rate, 'GBP ' currency_from,'826 ' COD    
union all  select 
convert(datetime,'2014-11-29',121) rate_date, '49.3220000000' rate, 'USD ' currency_from,'840 ' COD    
union all  select 
convert(datetime,'2014-11-29',121) rate_date, '0.0045332700' rate, 'BYR ' currency_from,'974 ' COD    
union all  select 
convert(datetime,'2014-11-29',121) rate_date, '61.4108000000' rate, 'EUR ' currency_from,'978 ' COD    
union all  select 
convert(datetime,'2014-11-29',121) rate_date, '3.2831000000' rate, 'UAH ' currency_from,'980 ' COD )t )tt  
on  CC.DATETIMERATEBEG=tt.DATETIMERATEBEG and CC.CURRCODE=tt.CURRCODE   
WHEN MATCHED  and cast(CC.RATE as money)<>cast( tt.RATE as money) THEN  update set CC.RATE=tt.RATE   
WHEN NOT MATCHED BY TARGET THEN  
INSERT ( [AUTOKEY], BASECURRCODE, CLIENT, CURRCODE, CURRISOCODE, DATETIMERATEBEG, DATETIMERATEEND, RATE, RATETYPE, SCALE)  
VALUES ( [AUTOKEY], BASECURRCODE, CLIENT, CURRCODE, CURRISOCODE, DATETIMERATEBEG, DATETIMERATEEND, RATE, RATETYPE, SCALE)      
OUTPUT inserted.CURRCODE;