CREATE_temp_Fahrzeug_Kunde.sql 369 B

12345678910111213141516171819
  1. USE [GC_ETL_ARI]
  2. GO
  3. TRUNCATE TABLE [temp].[Fahrzeug_Kunde]
  4. GO
  5. INSERT INTO [temp].[Fahrzeug_Kunde]
  6. SELECT [VIN]
  7. ,[Customer No FZG]
  8. ,[Client_DB]
  9. ,[First Name]
  10. ,[Last Name]
  11. ,left([Kunde_FZG], 200) as [Kunde_FZG]
  12. ,left([Kunde_FZG_Dashboard], 200) as [Kunde_FZG_Dashboard]
  13. FROM [GC_ETL_ARI].[transform_basis].[Fahrzeug_Kunde]
  14. GO