I need to do some record matching based on two date fields from two tables.
For example, I need to identify rows where the TABLE_B.ARRIVAL_DATE is on the same or 1 day greater than the TABLE_A.SHIP_DATE.
I've seen examples using BETWEEN with DATEADD(dd, -1) and eyeballing the results it seems to work correctly, but I've also seen recommendations against BETWEEN due to issues related to time. My date fields don't contain times and for now I'm just concerned about the same day or +1.
What is the best (and most simple) way to do this in SQL Server 2012?