如果行数不能被15整除，如何向存储过程添加空行

Question

我有一个存储过程，我想输出一个可以被15整除的行数。例如，我有一个输出33行的存储过程，但每页恰好包含15行。在只有3行的最后一页上，间距弄乱了。因为行数始终是动态的，所以我认为将行数设为可被15整除的数会更容易。因此，在本例中，它将添加12个空行以保持间距正确。

下面是我的代码：

SELECT  ROW_NUMBER() OVER ( ORDER BY YEAR(rce.Ecodate) ) AS Row ,
        rce.ReportRunCaseId AS CaseId ,
        YEAR(rce.EcoDate) AS EcoYear ,
        SUM(rce.NetInv) AS NetInvSum ,
        SUM(rce.NDCash) AS NDCashSum ,
        SUM(rce.DiscCash) AS DiscCashSum ,
        SUM(rce.GrossGas) AS GrossGasSum ,
        SUM(rce.GrossOil) AS GrossOilSum ,
        SUM(rce.NetProdTax) AS NetProdTaxSum ,
        SUM(rce.NetOpCost) AS NetOpCostSum ,
        SUM(rce.WellCost) AS WellCostSum ,
        SUM(rce.NetOil) AS NetOilSum ,
        SUM(rce.CoNetRevOil) AS CoNetRevOilSum ,
        SUM(rce.CoNetRevGas) AS CoNetRevGasSum ,
        SUM(rce.NetGas) AS NetGasSum ,
        rce.WellCount ,
        rcl.SortId
FROM    PhdRpt.ReportCaseList AS rcl
        INNER JOIN PhdRpt.RptCaseEco AS rce ON rce.ReportId = rcl.ReportId
                                               AND rce.ReportRunCaseId = rcl.ReportRunCaseId
GROUP BY rcl.SortId ,
        rce.ReportId ,
        rce.ReportRunCaseId ,
        YEAR(rce.EcoDate) ,
        rce.WellCount

我已经读到可以使用INSERT INTO向表添加行。我应该使用这样的东西吗：

INSERT  INTO rce
        SELECT  num - 1
        FROM    T1
        WHERE   ( num % 15 ) = 0 

Answer 1

• 将在示例中选择的记录插入到临时表中。然后，对于要添加的空行，
• 会向临时表发出另一个insert。然后，
• 从临时表中选择记录作为存储过程的返回值。