摘要：
--删除重复报告Select * into #Tmp from Sms_SendHistoryReportSelect min(ReportID) as ReportID into #Tmp2 from #Tmp group by HistoryID,PhoneNum,State,SendTime,IsSendedSelect * from #Tmp where ReportID in (Select ReportID from #Tmp2)delete from Sms_SendHistoryReport where ReportID not in (Select ReportID from 阅读全文
posted @ 2011-12-29 21:46 我不是高手 阅读(175) 评论(0) 推荐(0) 编辑