| 12345678910111213141516 |
- INSERT INTO [GC].[data].[GC_Mitarbeiter]
- SELECT T1.[Client_DB]
- ,T1.[Employee_ID]
- ,T1.[Name]
- ,T1.[Department]
- ,T1.[Zuordnung_Funktion]
- ,T1.[Zuordnung_Produktiv]
- ,T1.[Monteur_Ebene_1]
- ,T1.[Monteur_Ebene_2]
- ,T1.[Monteur_Ebene_3]
- ,T1.[Zuordnung_Department_Name]
- ,T1.[productivity_factor]
- ,T1.[leave_date]
- FROM [LOCOSOFT].[template].[GC_Mitarbeiter] T1
- LEFT JOIN [GC].[data].[GC_Mitarbeiter] T2 ON T1.Client_DB = T2.Client_DB AND T1.Employee_ID = T2.Employee_ID
- WHERE T2.[Name] IS NULL
|
