xtract.Department.sql 371 B

1234567891011121314151617181920
  1. SET QUOTED_IDENTIFIER ON
  2. GO
  3. SET ANSI_NULLS ON
  4. GO
  5. CREATE VIEW [xtract].[Department] AS
  6. SELECT [timestamp]
  7. , [Code]
  8. , [Name]
  9. -- , [Consolidation Code]
  10. -- , [Map-to IC Dimension Code]
  11. -- , [Map-to IC Dimension Value Code]
  12. , [Client_DB]
  13. FROM [GC_TRANSIT_ARI].[import].[Department]
  14. GO
  15. SET QUOTED_IDENTIFIER OFF
  16. GO
  17. SET ANSI_NULLS OFF
  18. GO
  19. GO