x_data.Mitarbeiter.sql 474 B

1234567891011121314151617181920212223242526
  1. SET QUOTED_IDENTIFIER ON
  2. GO
  3. SET ANSI_NULLS ON
  4. GO
  5. CREATE VIEW [x_data].[Mitarbeiter] AS
  6. SELECT [Client_DB]
  7. , [Employee No_]
  8. , [Name]
  9. , [First Name]
  10. , [Last Name]
  11. , [Leaving Date]
  12. , [Task Type Group]
  13. , [Function Code]
  14. , [Group No_ 1]
  15. , [Group No_ 2]
  16. , [Group No_ 3]
  17. , [Monteur_Gruppe]
  18. , [Monteur_Gruppe_2]
  19. FROM [GC_CONFIG].[ari].[Mitarbeiter]
  20. GO
  21. SET QUOTED_IDENTIFIER OFF
  22. GO
  23. SET ANSI_NULLS OFF
  24. GO
  25. GO