User Tools

Site Tools


bicn01:jahreswechsel

HowTo ... Jahreswechsel

Beim Jahreswechsel müssen die Monate in der Tabelle T_CALENDAR_MONTH manuell aus dem AdventureBikes_Sales_DataMart übertragen werden.

USE [BIAGAME]
GO

INSERT INTO [dbo].[T_CALENDAR_MONTH]
           ([ID_Calendar_Month]
           ,[Calendar_Month]
           ,[Calendar_Month_Name]
           ,[Calendar_Month_Number]
           ,[Calendar_Quarter]
           ,[Calendar_Year]
           ,[Last_Day_Of_Month]
           ,[Calendar_Month_Sort])
  SELECT 
	[ID_Calendar_Month] ,
	[Calendar_Month_ISO] ,
	[Calendar_Month_Name] ,
	[Calendar_Month_Number] ,
	[Calendar_Quarter] ,
	[Calendar_Year] ,
	[Last_Day_Of_Month], 
	null 
FROM [AdventureBikes Sales DataMart].[dbo].[Dim_Calendar_Month] where Calendar_Year = 2018
bicn01/jahreswechsel.txt · Last modified: 2018/12/04 08:40 (external edit)