2011年5月13日
Statistic query by week in T-SQL
摘要： SELECT DATEPART(YEAR,CreateTime)AS 'Year', DATEPART(week,CreateTime)AS 'Week', MIN(DATEADD(week,DATEDIFF(week,0,CreateTime),0))AS 'Week Date', SUM(COALESCE(Amount,0))AS 'Order Amount', SUM(COALE... 阅读全文
posted @ 2011-05-13 09:32 Allen Xu 阅读(114) 评论(0) 推荐(0) 编辑