CREATE
	OR

ALTER VIEW [load].[current_date_Prognose~1]
AS
SELECT --[Bundeslaender Id] AS [Bundeslaender Id],
	[Datum] AS [Bookkeep Date],
	--[Wochentage Id] AS [Wochentage Id],
	[Arbeitstag Mofr] AS [Arbeitstag Mofr],
	[Zaehler Mofr] AS [Zaehler Mofr],
	--[Summe Mofr] AS [Summe Mofr],
	--[Arbeitstag Mosa] AS [Arbeitstag Mosa],
	--[Zaehler Mosa] AS [Zaehler Mosa],
	--[Summe Mosa] AS [Summe Mosa],
	--[Feiertage Id] AS [Feiertage Id],
	--[Jahr] AS [Jahr],
	--[Arbeitstag Nr Jahr] AS [Arbeitstag Nr Jahr],
	--[Gesamt Arbeitstage] AS [Gesamt Arbeitstage],
	year ( [Bookkeep Date] ) AS [Jahr_Dashboard],
	month ( [Bookkeep Date] ) AS [Monat_Dashboard],
	day ( [Bookkeep Date] ) AS [Tag_Dashboard] 
FROM [export_csv].[current_date_Prognose~1]
GO