您应该添加条件，以删除
value =0最终结果集中包含的条目。您无法在生成数据的SELECt查询中执行此操作，因此将当前结果集作为子查询括起来，如下所示：
;WITH Data AS( SELECT [QUOTE Ref], [Product Line], [Value] FROM ( SELECt [QUOTE Ref], [Product A], [Product B], [Product C], [Product D] FROM [Table1] ) p UNPIVOT ([Value] FOR [Product Line] IN ([Product A], [Product B], [Product C], [Product D] ) )AS unpvt )SELECt * FROM DATA WHERe Value <> 0;
