sql取值分类
求以下语句更改：
select InvCode as 存货编码,OpSeq as 工序行号,OpCode as 工序代号,opDescription as 工序说明,ScrapQty as 报废数量,ScrapReasonCode as 报废原因码,ScrapReasonName as 报废说明
from v_fc_moroutingbilllist
结果：
需要的结果：
SQL 编码
[解决办法]
SELECT InvCode AS 存货编码 ,
OpSeq AS 工序行号 ,
OpCode AS 工序代号 ,
opDescription AS 工序说明 ,
[杂质] = MAX(CASE WHEN ScrapReasonName = '杂质' THEN ScrapQty
ELSE 0
END) ,
[冲坏] = MAX(CASE WHEN ScrapReasonName = '冲坏' THEN ScrapQty
ELSE 0
END) ,
[模具脏] = MAX(CASE WHEN ScrapReasonName = '模具脏' THEN ScrapQty
ELSE 0
END)
FROM v_fc_moroutingbilllist
GROUP BY InvCode ,
OpSeq ,
OpCode ,
opDescription
