xtract.Model_Master.sql 525 B

123456789101112131415161718192021
  1. SET QUOTED_IDENTIFIER ON
  2. GO
  3. SET ANSI_NULLS ON
  4. GO
  5. CREATE VIEW [xtract].[Model_Master] AS
  6. SELECT [No_] AS [Model No_]
  7. , [Make Code]
  8. , [Description]
  9. , CASE
  10. WHEN [Gen_ Prod_ Posting Group] IN ('', 'FEHLER') THEN [Vehicle Category Code]
  11. WHEN [Gen_ Prod_ Posting Group] LIKE '%_FZG_%' THEN [Vehicle Category Code]
  12. ELSE [Gen_ Prod_ Posting Group] END AS [Model_Group_Code]
  13. FROM [GC_TRANSIT_ARI].[import].[Model_Master]
  14. GO
  15. SET QUOTED_IDENTIFIER OFF
  16. GO
  17. SET ANSI_NULLS OFF
  18. GO
  19. GO