date dimension

[Adnane]

hello, i would like to know if any one has already a populated date dimension in MS sql server 2000. with the different attributes( week #, day #, week_day, day_in month, etc...).
if not, does any one knows how to populate this dimension?
thank you
Regards

Adnane

Micorosft North Africa

http://www.microsoft.com/northafrica

 

[jdgonzalez]

You might want to check out Book OnLine under 'dates'. There are functions for what you are looking to accomplish such as datepart.