sql排班表！能用sql最好，不要指针和循环！求大神看看能不能有什么算法的！

CREATE TABLE [dbo].[行程表]([主键] NVARCHAR(50) PRIMARY KEY NOT NULL
,[派团ID] NVARCHAR(50) NULL
,[派团编号] NVARCHAR(50) NULL
,[车牌号] NVARCHAR(50) NULL
,[标题] NVARCHAR(50) NULL
,[内容] NVARCHAR(50) NULL
,[时间] DATE NULL
)
INSERT INTO [dbo].[行程表]([主键],[派团ID],[派团编号],[车牌号],[标题],[内容],[时间])
VALUES('ID1','ID1','YnkMd','云AL2203','第1天','无','2016/07/12')
,('ID2','ID1','YnkMd','云AL2203','第1天','无','2016/07/13')
,('ID3','ID1','YnkMd','云AL2203','第2天','无','2016/07/14')
,('ID4','ID1','YnkMd','云AL2203','第3天','无','2016/07/14')
,('ID5','ID2','K-MK-325','云AL2203','第1天','无','2016/07/14')
,('ID6','ID2','K-MK-325','云AL2203','第2天','无','2016/07/15')
,('ID7','ID2','K-MK-325','云AL2203','第3天','无','2016/07/16')
,('ID8','ID2','K-MK-325','云AL2203','第4天','无','2016/07/17')
,('ID9','ID2','K-MK-325','云AL2203','第5天','无','2016/07/18')
,('ID10','ID3','YN-DALI-36','云AL2203','第1天','无','2016/07/19')
,('ID12','ID3','YN-DALI-36','云AL2203','第2天','无','2016/07/20')
,('ID13','ID3','YN-DALI-36','云AL2203','第3天','无','2016/07/21')
,('ID14','ID4','YN-DALI-37','云AL2203','第1天','无','2016/07/14')
,('ID15','ID4','YN-DALI-37','云AL2203','第2天','无','2016/07/15')
,('ID16','ID4','YN-DALI-37','云AL2203','第3天','无','2016/07/16')
,('ID17','ID5','K-MK-328','云AL2203','第1天','无','2016/07/16')
,('ID18','ID5','K-MK-328','云AL2203','第2天','无','2016/07/17')
,('ID19','ID5','K-MK-328','云AL2203','第3天','无','2016/07/18')
,('ID20','ID5','K-MK-328','云AL2203','第4天','无','2016/07/19')
SELECT [主键],[派团ID],[派团编号],[车牌号],[标题],[内容],[时间] FROM [dbo].[行程表] ORDER BY [派团ID],[主键] ASC