set @sql = 'select [仓库],[仓库名称],[品号] ' select @sql = @sql + ' , max(case CA09 when ''' + CA09 + ''' then CA082 else 0 end) [' + CA09 + ']'+'需求 ...