from
(
select RoomListID,
(
SELECT ',' +cast([Week] AS NVARCHAR)
FROM RoomOpenSet
WHERE RoomListID=ro2.RoomListID
for xml path('')
)MarkUp
from RoomOpenSet ro2
GROUP BY RoomListID
) as Strings
where RoomListID = 1
2014年12月31日 星期三
[SQL]如何將多筆資料列的值組成同一欄位
原本的資料列表
但是我想將Week欄位組成 2,3,4 使用stuff
select stuff(Strings.MarkUp,1,1,'') as [Week]
from
(
select RoomListID,
(
SELECT ',' +cast([Week] AS NVARCHAR)
FROM RoomOpenSet
WHERE RoomListID=ro2.RoomListID
for xml path('')
)MarkUp
from RoomOpenSet ro2
GROUP BY RoomListID
) as Strings
where RoomListID = 1
from
(
select RoomListID,
(
SELECT ',' +cast([Week] AS NVARCHAR)
FROM RoomOpenSet
WHERE RoomListID=ro2.RoomListID
for xml path('')
)MarkUp
from RoomOpenSet ro2
GROUP BY RoomListID
) as Strings
where RoomListID = 1
訂閱：
張貼留言 (Atom)
Visual Studio JS intellisense 失效解決方式
試了好久，發現到工具>選項>IntelliCode js項目設定啟用，重新開啟VS就正常了! 後來發現是TypeScript3.2版有問題停用，使用4.3版的TypeScript即可
沒有留言:
張貼留言