摘要： 运用辅助日历表，实现计算资本开支累进值类似的功能辅助日历表名称为dbo.DatePicker ，例子数据如下图：数据库待处理表名称为dbo.PL_PM_CapitalExpenditure ，数据如下图处理后的结果图片如下具体的sql语句如下WITH DA AS ( SELECT YEAR(a.DATEVALUE) YEARd , MONTH(A.DATEVALUE) month , * FROM dbo.DatePicker A LEFT JOIN ( SELECT ProjectID , Year , monthd , value FROM dbo.PL_PM_CapitalExpendi 阅读全文

摘要： -更新前的数据量统计SELECT COUNT(1)FROM PL_PM_ApportionInvestment--插入不存在的新数据INSERT INTO dbo.PL_PM_ApportionInvestment ( ProjectID , CompanyCode , BuildCompany , CitySupporting , CityInvestment , [Year] , Source , IsTarget ) SELECT ProjectID , CompanyCode , BuildCompany , CitySupporting , CityInverstment ,  阅读全文