giammin

roundrobin

Jun 6th, 2014
390
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.29 KB | None | 0 0
  1. SELECT [Date],[Domain]
  2. FROM (
  3.   SELECT    [Date] ,[Domain],
  4.   ROW_NUMBER() OVER (PARTITION BY [Domain] ORDER BY [Date]) AS recID
  5.   FROM  Delivery ) AS r
  6. ORDER BY recID, (CASE WHEN domain >1 THEN domain ELSE
  7.                  domain+(select top 1 domain from delivery order by domain desc) END)
Advertisement
Add Comment
Please, Sign In to add comment