Need a Query to check a range of dates in the given range.
<u>My Query is :</u>
select * from DSR where d1 between Log1 and Log2
d1 is given by us as input.
I am checking d1 in between Log1 and Log2.
Is there any possibility that if I give date range like d1 to d2, it has to check all the dates between d1 and d2 one by one in the Log1 & Log2 range and it has to return all the records which are matching with the dates between d1 & d2.
Do I need to put any loop here for each and every date.
Please help me out in this. thanks