sqlquery.txt

中国联通 CDMA点对点短信话单分析入库的程序

INSERT INTO t_rpt_count (sendtime, callingnumber, sendcount) 
SELECT CONVERT(datetime, send_time, 20) AS sendtime, orig_mp AS callingnumber, COUNT(*) AS sendcount 
FROM GSM'+formatDateTime('yyyymmdd',rptdate)+' WHERE (sm_type = 2 OR sm_type = 3) AND (status = 1) AND (orig_mp LIKE ''86130%'' OR orig_mp LIKE ''86131%'' OR orig_mp LIKE ''86132%'')
GROUP BY CONVERT(datetime, send_time, 20), orig_mp