SQLserver 2008 数据记录连续合并的问题

Question

数据库表

现在需要根据cardStatus字段进行合并，
和lastTime，printStatus 字段无关
最终结果如下：
hostId beginDate endDate cardStatus
liquan 2016-06-19 11:01:37 2016-06-19 11:02:56 -117
liquan 2016-06-19 11:03:56 2016-06-19 11:04:56 -239
liquan 2016-06-19 11:05:57 2016-06-19 11:08:57 -117
liquan 2016-06-19 11:09:58 2016-06-19 11:11:58 0
liquan 2016-06-19 11:12:58 2016-06-19 11:12:58 -117
liquan 2016-06-19 11:13:58 2016-06-19 11:13:58 -239
liquan 2016-06-19 11:14:59 2016-06-19 11:19:00 -117

后面结果一次类推

Answer 1

http://www.soso.io/article/11616.html