Kalender_Dimension.sql 392 B

123456789101112131415
  1. CREATE TABLE [dbo].[Kalender_Dimension] (
  2. [Datum] [date] NULL,
  3. [Jahr] [varchar](30) NULL,
  4. [Quartal] [varchar](30) NULL,
  5. [Monat] [varchar](30) NULL,
  6. [Tag] [varchar](30) NULL,
  7. [Zeit_Spezialkategorie] [nvarchar](128) NULL,
  8. [Zeit_Ebene1] [varchar](30) NULL,
  9. [Zeit_Ebene2] [varchar](30) NULL,
  10. [Zeit_Ebene3] [varchar](30) NULL,
  11. [Zeit_Ebene4] [varchar](30) NULL
  12. )
  13. GO