• TheSQLGuru (12/17/2008)

    It is customary and useful to have your int date keys be formatted CCYYMMDD, at least in the classical date dimension scenario. Identities are really not helpful here.

    What format would you propose for the quarterly and hourly values?