22,207
社区成员
发帖
与我相关
我的任务
分享
select Province as 省份,count(distinct SendNumber) as 条数
from NumberBelong n,RecvSmsTable r,SendCustomers s
where n.Num = substring(r.SendNumber,1,7)
and dbo.Fun_BusinessId(r.SmsContent) = s.[ID]
and r.SmsTime >= '2010-08-01 00:00:00'
and r.SmsTime <= '2010-08-28 23:59:59'
and n.Province='广东省'
group by Province
create clustered index idx_numid on NumberBelong(NumId)
create clustered index idx_smsindex on RecvSmsTable(SmsIndex)
create nonclustered index idx_SmsTime on RecvSmsTable(SmsTime)