You are here: Re: Better way to use BETWEEN Begin and End Dates « MsSQL Server « IT news, forums, messages
Re: Better way to use BETWEEN Begin and End Dates

Posted by serge on 09/26/06 01:57

> Second: Yes, this can be made much simpler. I've struggled with the
> "overlappping intervals" question myself once, and suddenly found the
> best solution after drawing many sets of two intervals on an axis to
> explore the different possibilities of overlap or non-overlap.

Thanks Hugo. I actually drew all the possible intervals and I had
16 possibilities.

In any case your example is much easier to grasp. I'll work on
memorizing the logic so that I'm able to write this again without
reading the explanation.

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация