直接拖单元格里不扩展即可

select

stuff((

         SELECT ',' + @all_wips

         FROM v_w2_wip pmob

         WHERE pmob.monumber = aa.monumber

         FOR XML path('')

     ), 1, 1, '')

        from v_w2_wip aa

        group by aa.moNumber--sql server

JOINARRAY(SQL("FRDemo","SELECT 'B010' AS ID union all SELECT 'B011' AS ID",1),",")

方案1 

单独加一个单元格引用这个数据设置为不扩展。

方案2

使用公式

ARRAY（单元格）返回一个数组。

试试这个方法：

例子：SELECT (select stuff(( select ','+CAST(OwnerCode AS NVARCHAR(8)) FROM 

(select 123344 AS OwnerCode

UNION ALL

select 12334 ) T for xml path('')),1,1,''))

替换这个

(select 123344 AS OwnerCode

 UNION ALL

 select 12334 )