Insert rows from one table to another March 8, 2011

WITH rates(Code, Rate, BaseCode, LastUpdate, [Auto], Source) 
 AS (SELECT crc.Code, crc.Rate, crc.BaseCode, crc.LastUpdate, crc.[Auto], crc.Source
  FROM CurrencyRateCurrent crc
  WHERE crc.AccountId = 7
  )

INSERT INTO [CurrencyRateCurrent] (Code, Rate, BaseCode, LastUpdate, [Auto], Source,AccountId)
SELECT Code, Rate, NULL, LastUpdate, [Auto], Source, 20 FROM rates

Advertisement