|
|
Posted by Erland Sommarskog on 05/24/05 00:12
Thomas R. Hummel (tom_hummel@hotmail.com) writes:
> I had tried something similar at the end of last week, using only the
> necessary dates for my calendar, although I actually created a calendar
> table and selected the dates into it rather than using a derived table.
> Performance with that method was still pretty bad, but then late on
> Friday I was told that the business rules were slightly different from
> what I was originally told.
>
> Now they have decided that the coverage rate with the later start date
> always has precedence when there is an overlap. If two rates have the
> same exact start date then I have to use the higher rate. With these
> new business rules I was able to quickly come up with an acceptable
> solution using a view and insert:
Ain't life great! First you put a lot of effort into a tricky problem -
and then you tell that you've been working from the wrong presumptions.
It was fortunate that the new rules made the problem simpler this time.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
Navigation:
[Reply to this message]
|