照搬结果如附件
分解只出来第一行数据,后续没有
合并:按钮点击后没有反馈
这是什么问题啊???
分解SQL,设置条件 where 1=1
>>>>>>>>>>
select
b.data AS 本报表.[订单_明细表].[数据]x填充不锁定
from
(select data=convert(xml,'<root><v>'+replace( 本报表.[订单_主表].[分解],',','</v><v>')+'</v></root>') ) as a
outer apply
(select data=C.v.value('.','nvarchar(100)') from a.data.nodes('/root/v')C(v)) as b
>>>>>>>>>>>
合并SQL
>>>>>>>>>>>
select distinct stuff(
(
select ','+[F_717]
from [订单_主表] inner join [订单_明细表] on [订单_主表].id=[订单_明细表].id
where [F_715] = 本报表.[订单_主表].[分解] for xml path('')), 1, 1, ''
) AS 本报表.[订单_主表].[合并]x填充不锁定
from [订单_主表] inner join [订单_明细表] on [订单_主表].id=[订单_明细表].id
>>>>>>>>>>>
|
|
zhh0815