解决方案 »
- 怎么读文件返回的是文件路径啊?
- AspxGridView 自带的EditButton和NewButton 事件
- C#中,如果一个派生类同时拥有几个类的特性,如何建立继承关系?
- Winform画拓扑图????
- Socket(AddressFamily addressFamily,SocketType socketType,ProtocolType protocolTy
- ClickOnce发布过程中遇到的问题
- 如何在列里面创建行
- 怎样让 FileDialog 能够选择文件夹?
- 请问如何将全角字符串转成半角串
- c#socket编程服务器最大可以接受多少个来自客户端的连接
- 读TXT文件,读不出来,不知道是什么原因
- 求助,调用C++DLL函数时出现奇怪问题
(
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