Find the Closest Date Match for Each Record from Two Tables — From SQL to SPL #20

Problem description & analysis: SQL Server has two tables, Table1： Table2： Task: Now we need to sort Table1 by ID and traverse each record in sequence: retrieve the record in Table2 that has the same DocNum field as the current record, but with a s...