• Currently working in finance, there's additional days you need to kick out, which are the holidays for the different markets. Assuming you're only working against NYSE, NASDAQ, and OTC, you still need to deal with that.

    With that in mind, do you have a calendar table already setup which lists allowable dates, or do you have a holiday table with is exclusionary for your list? If calendar, this becomes easy. If holiday, we have to build the calendar on the fly and then work from there.


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA