摘要:今天遇到一个奇怪的问题,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 阅读全文
posted @ 2013-07-31 17:45 medci(卡樂江) 阅读 (196) 评论 (0) 编辑