摘要： --select top 10000 * into #s from searchset statistics time on set statistics io onselect userId,count(*) as searchNum,s.Posttime, p.RootID ,s.urlfrom #s sleft outer join ProductInfo p on s.ProductID like '%' + p.RootID + '%'group by userid, p.RootID,s.Posttime,s.url--dbo.GetPlatform 阅读全文