xtract.employees_breaktimes.sql 362 B

12345678910111213141516171819202122
  1. SET QUOTED_IDENTIFIER ON
  2. GO
  3. SET ANSI_NULLS ON
  4. GO
  5. CREATE VIEW [xtract].[employees_breaktimes] AS
  6. SELECT [client_db]
  7. -- , [is_latest_record]
  8. , [employee_number]
  9. , [validity_date]
  10. , [dayofweek]
  11. , [break_start]
  12. , [break_end]
  13. FROM [LOCOSOFT].[dbo].[employees_breaktimes]
  14. GO
  15. SET QUOTED_IDENTIFIER OFF
  16. GO
  17. SET ANSI_NULLS OFF
  18. GO
  19. GO