I have also used Jeff's code as a jumping off point to do date tally tables. Julian date conversions were what started me down this road. I usually use the days int value as the pk_for the table with

select cast(getdate() as int)

Language conversions and other wierd stuff can then be stored in the date table that I usually put in master.

John.