110,577
社区成员
发帖
与我相关
我的任务
分享[200分]求根据日期分组（续）
...全文
请发表友善的回复…
发表回复
叫我三三 2013-06-27
- 打赏
- 举报
谢谢
lzw_0736 2013-06-27
- 打赏
- 举报
with a1 ([sign],[date]) as--明細
(
select 1,'2012-01-01' union all
select 1,'2012-02-06' union all
select 1,'2012-05-03' union all
select 1,'2012-06-11' union all
select 1,'2012-09-01' union all
select 2,'2012-02-03' union all
select 2,'2012-04-19' union all
select 2,'2012-04-23'
)
,a2 ([s_sign],[s_date],[s_n]) as
(
select 1,'2012-01-01',2 union all
select 1,'2012-05-03',2 union all
select 1,'2012-09-01',1 union all
select 2,'2012-02-03',3
)
select *
from a1 a
inner join a2 b on a.[sign]=b.[s_sign] and DATEDIFF(day,b.[s_date],a.[date]) between 0 and 90
order by 1,2
Leon_He2014 2013-06-27
- 打赏
- 举报
我已经在原帖回复了哦，记得给分。
