123456789101112131415161718192021 |
- 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
|