摘要：
今天遇到一个奇怪的问题，SSRS我觉得是个半成品，很多东西都搞不了。写了一段SQL，本来SQL写法都有点怪了，如下WITH TMP_A AS (SELECT *,ROW_NUMBER() OVER(PARTITION BY L1_WorkOrderType,L2_TaskCode ORDER BY L4_QTY)CC FROM(SELECTB.B1_APP_TYPE_ALIAS AS L1_WorkOrderType,WO.TASK_CODE AS L2_TaskCode,WO.COST_ITEM AS L3_CostItem,SUM(WO.COST_QUANTITY) AS L4_QTY,M 阅读全文
