摘要:
--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
阅读全文
posted @ 2013-06-20 13:54
坐井观天
阅读(1404)
推荐(0)
编辑