Jon;

I like the idea of having the extra columns available for utility purposes. I think, however, that it's a mistake to define the columns and then populate them as your stored proc is doing.

This technique opens you up to data errors. What prevents an incorrect value in any of the derived date variables?

Perhaps a better approach would be to use computed columns or a VIEW that calculates all of the derived date information.

TroyK