USE [weather]
GO

SET DATEFORMAT DMY

INSERT INTO [dbo].[weather]
	(
	[snapdatetime],
	[snapdate],
	[snaptime],
	[temp],
	[rh],
	[dewpoint],
	[windspd],
	[windgust],
	[winddir],
	[rain],
	[totrain],
	[pressure],
	[cumrain],
	[lategust],
	[windbear],
	[raintoday],
	[rainsince00]
	)
SELECT
	convert(varchar,snapdate) + ' ' + convert(varchar,snaptime),
	[snapdate],
	[snaptime],
	[temp],
	[rh],
	[dewpoint],
	[windspd],
	[windgust],
	[winddir],
	[rain],
	[totrain],
	[pressure],
	[cumrain],
	[lategust],
	[windbear],
	[raintoday],
	[rainsince00]
FROM [dbo].[weathermonthlyimport]