摘要:
--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 阅读全文
摘要:
1)先将报表生成图片存储于本地代码Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--stringdeviceInfo="<DeviceInfo><OutPutFormat>PNG</OutPutFormat></... 阅读全文