你可以试试这个。使用
group by
用于分组
id
和
stuff
; with cte as (
select ItemID,ItemCode,BranchID,RcItemCode + '-' + Numbers as Code from StandardDetails
)
select ItemID,ItemCode,BranchID,
Stuff( (select ', ' + code from cte as c
where c.ItemID = ct.ItemID and c.ItemCode = ct.ItemCode and c.BranchID = ct.BranchID
for xml path('')),1,1,'') as RCode
from cte as ct
group by ItemID,ItemCode,BranchID
查看
请试试这个。
Create view MyView
As
Begin
select ItemID,ItemCode,BranchID,
Stuff( (select ', ' + code from (select ItemID,ItemCode,BranchID,RcItemCode + '-' + Numbers as Code from StandardDetails) as c
where c.ItemID = ct.ItemID and c.ItemCode = ct.ItemCode and c.BranchID = ct.BranchID
for xml path('')),1,1,'') as RCode
from StandardDetails as ct
group by ItemID,ItemCode,BranchID
End
