xtract.times.sql 381 B

123456789101112131415161718192021222324
  1. SET QUOTED_IDENTIFIER ON
  2. GO
  3. SET ANSI_NULLS ON
  4. GO
  5. CREATE VIEW [xtract].[times] AS
  6. SELECT [client_db]
  7. , [employee_number]
  8. , [order_number]
  9. , [start_time]
  10. , [type]
  11. -- , [order_positions]
  12. , [end_time]
  13. , [duration_minutes]
  14. , [exact_duration_seconds]
  15. FROM [LOCOSOFT].[dbo].[times]
  16. GO
  17. SET QUOTED_IDENTIFIER OFF
  18. GO
  19. SET ANSI_NULLS OFF
  20. GO
  21. GO