Is there a way to do this with a range of dates too?

Thanks so much!

@orig_free_qty numeric(4),

When I do this:

SELECT @orig_free_qty = 9

SET ROWCOUNT @orig_free_qty

UPDATE @Orig_Calendar Set orig_free_day = 1  

I get this:

Invalid argument for SET ROWCOUNT. Must be a non-null non-negative integer.

Thank you all for your suggestions and help. It fixed me up just great and my performance is much better. I appreciate you taking the time as it has helped...