Advertisement
Guest User

Untitled

a guest
Sep 2nd, 2015
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.95 KB | None | 0 0
  1. +-------------------------------------------------------------------+
  2. |Route |Sequence| Planned Time | Business Date |
  3. +-------------------------------------------------------------------+
  4. | 10-1 | 1 | 2015-08-21 20:15:00.000 | 2015-08-21 |
  5. | 10-1 | 2 | 2015-08-22 00:30:00.000 | 2015-08-21 |
  6. | 10-1 | 3 | 2015-08-22 08:45:00.000 | 2015-08-21 |
  7. | 22-1 | 1 | 2015-08-20 17:30:00.000 | 2015-08-20 |
  8. | 22-1 | 2 | 2015-08-21 01:10:00.000 | 2015-08-20 |
  9. | 22-1 | 3 | 2015-08-21 06:30:00.000 | 2015-08-20 |
  10. +------+--------+---------------------------+-----------------------+
  11.  
  12. SELECT
  13. [Route],
  14. [Sequence] = ROW_NUMBER() OVER
  15. (PARTITION BY [Route] ORDER BY [Planned Time]),
  16. [Planned Time],
  17. [Business Date] = MIN(CONVERT(DATE, [Planned Time])) OVER
  18. (PARTITION BY [Route])
  19. FROM dbo.table_name
  20. ORDER BY [Route], [Sequence];
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement