I want to set the FieldX of HistorianData to be FieldX of DataDump . Because in DataDump the TIMESTAMP isn't rounded down every minute so often there are not exact matches with HistorianData.
In the match I want to round the first record of every minute DOWN so that there is always a match, so in above I want

1 would be set to record ID 9
2 would be set to record ID 12
XXX would be set to record ID X

There are more than one record per minute in DataDump , I only want to match the closest record and ignore others.

Thanks in advance for help with transact-SQL. If it helps, any records of TableX records can be deleted or modified, it will just be deleted anyway after update.

Featured Post

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder. The folder can be on the local hard drive or on a network share. This batch file will query the SQL server to get the current date & time and wi…

Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…