TCristiano
asked on
Matching approximate dates between two queries
Hello-
Is there sql that will allow for an approximate match on dates between two tables with a one-to-many relationship?
Essentially, this mimics the Microsoft Excel vlookup funtion using the 'True' designation of finding an approximate match. I've attached a simple example.
Thanks!
Todd.
EExchange.pdf
Is there sql that will allow for an approximate match on dates between two tables with a one-to-many relationship?
Essentially, this mimics the Microsoft Excel vlookup funtion using the 'True' designation of finding an approximate match. I've attached a simple example.
Thanks!
Todd.
EExchange.pdf
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER