Exact match and Nearest Match for updating a table with another table
I have a big data table (1M rows). One column is serialNumber, one column is dateTime, one column is elapsedTime. Another much smaller table also has these columns, but the dateTime is earlier by an small amount (5-20 minutes) and the elapsedTime is a much more accurate value. The small table also has lots of extra rows associated with other events at other dateTimes (I do not have an 'event' c...
krln
j_bonnouvrier