34,576
社区成员
发帖
与我相关
我的任务
分享
declare @tb table(dt datetime)
insert @tb select '2009-05-01'
insert @tb select '2009-05-12'
select dt=convert(varchar(10),dt,120),
ts=datediff(dd,dt,(select top 1 dt from @tb where dt>a.dt order by dt)) from @tb a
/*
dt ts
---------- -----------
2009-05-01 11
2009-05-12 NULL
*/