USE Countries

IF OBJECT_ID('dbo.CityTemperatureSource') is not null
BEGIN
	DROP TABLE dbo.CityTemperatureSource
END

SELECT *
INTO dbo.CityTemperatureSource
FROM dbo.CityTemperature

IF OBJECT_ID('dbo.CityTemperatureDestination') is not null
BEGIN
	DROP TABLE dbo.CityTemperatureDestination
END


SELECT *
INTO dbo.CityTemperatureDestination
FROM dbo.CityTemperature

UPDATE dbo.CityTemperatureSource
SET AverageTemperature = AverageTemperature + 1
WHERE AverageTemperature between 2 and 5 and
Occurence not in
(
	'1833-03-01',
	'1833-04-01',
	'1833-05-01',
	'1833-06-01',
	'1833-07-01',
	'1833-08-01',
	'1833-09-01',
	'1833-10-01',
	'1833-11-01'
)
--(418703 rows affected)

DELETE FROM dbo.CityTemperatureSource
WHERE Occurence in
(
	'1833-03-01',
	'1833-04-01',
	'1833-05-01',
	'1833-06-01',
	'1833-07-01',
	'1833-08-01',
	'1833-09-01',
	'1833-10-01',
	'1833-11-01'
)
--(21042 rows affected)

DECLARE @i int = 100000000
WHILE @i < 100200000
BEGIN
	INSERT INTO dbo.CityTemperatureSource
		(
			[Id],
			[Occurence],
			[AverageTemperature],
			[AverageTemperatureUncertainty],
			[CityName],
			[CountryName],
			[Latitude],
			[Longitude]
		)
	VALUES (@i, '2020-01-01', 12, 2.5, 'CityName', 'CountryName', '1.1N', '1.1E')

	SET @i = @i + 1
END
--(200000 rows affected)