SOF 11127524

DECLARE @x TABLE(value INT, [time] DATETIME, ID INT)

INSERT @x VALUES
(0,'20120615 8:03:43 PM',11),--
(1,'20120615 8:03:43 PM',11),--*
(1,'20120615 8:03:48 PM',11),--
(1,'20120615 8:03:53 PM',12),--
(1,'20120615 8:03:58 PM',12),--
(2,'20120615 8:04:03 PM',11),--*
(2,'20120615 8:04:08 PM',11),--
(3,'20120615 8:04:13 PM',11),--*
(3,'20120615 8:04:18 PM',12),--
(3,'20120615 8:04:23 PM',11),--
(2,'20120615 8:04:28 PM',12),--*
(2,'20120615 8:04:33 PM',11);

-- output ordered by ID
0,'20120615 8:03:43 PM',11
1,'20120615 8:03:43 PM',11
2,'20120615 8:04:03 PM',11
3,'20120615 8:04:13 PM',11
2,'20120615 8:04:33 PM',11
1,'20120615 8:03:53 PM',12
3,'20120615 8:04:18 PM',12
2,'20120615 8:04:28 PM',12