CREATE
	OR

ALTER VIEW [load].[current_date_Prognose]
AS
SELECT --[Bundeslaender Id] AS [Bundeslaender Id],
	[Datum] AS [Invoice 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] 
FROM [export_csv].[current_date_Prognose]
GO