This seems to work OK. Many ways to solve it.

UPDATE

date_calendar

SET

quarter_weekdays_remaining =

(

SELECTISNULL( SUM( r.is_weekday ), 0 )

FROMdate_calendar r

WHEREr.calendar_date > s.calendar_date

ANDr.calendar_year = s.calendar_year

ANDr.calendar_quarter = s.calendar_quarter

),

quarter_weekdays_completed =

(

SELECTISNULL( SUM( c.is_weekday ), 0...

Ran the script and it is very nice. One problem is that I am getting stange results for the quarter_weekdays_remaining and quarter_weekdays_completed fields. On 2001-09-01 and 2009-09-02 my table has...