At 03:22 2009-12-02, Peter Cushing <[email protected]> wrote:
[snip]
>Glad you got it working. Doesn't that 3rd select only give you codes
>that have a max value in 2009?
No, it gives an indication of whether the latest is in 2009.
>What makes me think this is that you are joining a table of max values
>(which could be this year or earlier) with a table of only 2009.
>It's hard to visualise it without having some data to play with.
Here is some more context:
This is part of a program for more easily changing rates
charged. While most rates are set on certain anniversaries, this is
not always the case. My boss may determine some rates for the next
year well in advance. I want to display all current charge codes,
but allow generation of new rates for only those that do not have a
newer-than-current rate already set up.
Sincerely,
Gene Wirchenko
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
