Comparing two dates and check for not falling dates
I have two tables as below.
Need to compare Date from T1 with Start_date and End_date from table 2 and pull only Dates that are not falling between. (Note : can do this by joining two tables, but the volume of data is huge so cant approach this solution).
Result should be 1-jan-2018, as it doesn't fall between any of the satrt_date and end _date