八度空間

select DispatchList.cDLCode,DispatchLists.cSoCode from DispatchLists,DispatchList where DispatchList.DLID=DispatchLists.DLID and cDLCode='SN2025010610016'

----------------------------下面語句是行轉列------------------------------------------------------------------------
select
l.cDLCode
,Subjects=stuff((select distinct ','+convert(varchar,DispatchLists.cSoCode)
from DispatchList,DispatchLists where DispatchList.DLID=DispatchLists.DLID and DispatchList.cDLCode=l.cDLCode
for xml path('')), 1, 1, '')
from
DispatchList l,DispatchLists where l.DLID=DispatchLists.DLID and cDLCode='SN2025010610016'
group by l.cDLCode