Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Question with Dates - should be easy

Author  Topic 

abarsami
Yak Posting Veteran

68 Posts

Posted - 2001-07-27 : 15:34:03
I have a range of dates between 06-26-00 and
06-30-00

I need a select statement that says give me every date in between and equal to 06-26-00 and 06-30-00 and uses each one to compare if it is in between 07-01-00 and 07-04-00

So the output of the select statement that gives me every date between 06-26-00 and 06-30-00 would be:

06-26-00
06-27-00
06-28-00
06-29-00
06-30-00

Then the select statement should take 06-26-00 and see if it's in between 07-01-00 and 07-04-00.
Then do the next same thing with 06-27-00 and so on and so forth.

Any help, thanks
   

- Advertisement -