• In many cases, I can do what I have to do by simply capturing the weekday values for a known saturday and sunday, like so:

    declare @dowSat int

    declare @dowSun int

    set @dowSat=datepart(dw,'20061028')

    set @dowSun=datepart(dw,'20061029')