摘要: select * from ( select ROW_NUMBER() OVER(order by SUM(HavePayAmount) desc) AS rowNum, CustomerID,CustomerName,SUM(Amount) sumContractAmount, SUM(HavePayAmount) sumHavePayAmount from #tmpTable where (ContractDate >= '2012-04-01' and ContractDate ... 阅读全文
posted @ 2013-03-06 15:40 xust 阅读(339) 评论(0) 推荐(0)
摘要: ExpressionBuilder 类 .NET Framework 4 其他版本 此主题尚未评级 - 评价此主题 在分析页的过程中计算表达式。继承层次结构System.ObjectSystem.Web.Compilation.ExpressionBuilderSystem.Web.Compilation.AppSettingsExpressionBuilderSystem.Web.Compilation.ConnectionStringsExpressionBuilderSystem.Web.Compilation.ResourceExpressionBuilderSystem.Web.C. 阅读全文
posted @ 2013-03-06 11:08 xust 阅读(429) 评论(0) 推荐(0)