Skip to Content
0
Former Member
Aug 18, 2007 at 12:56 PM

Need a Query to check a range of dates in the given range.

25 Views

Hi Guys,

<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

Venkat.