在我的桌子上，我有包含'，'的記錄。
Id Name
1 Here is the result
2 of your examination.
3 ,
4 New Opening for the position of
5 PT Teacher, Science Lab.
6 ,
所以在游標中，如果我找到'，'，那么我想將 2 行值合并到第一個值中。
DECLARE @ID int
DECLARE @Name nvarchar(500)
DECLARE MergeCursor CURSOR FOR
select ID,NAME from TEST_TABLE
OPEN MergeCursor
FETCH NEXT FROM NarrationCursor into @ID,@NAME
WHILE (@@FETCH_STATUS=0)
BEGIN
if(@Name = ',')
select * from TEST_TABLE where ID = (select max(ID) from TEST_TABLE where ID < @ID)
FETCH NEXT FROM NarrationCursor into @ID,@NAME
END
CLOSE MergeCursor
DEALLOCATE MergeCursor
在游標中，如何獲取前兩行并更新第一行中的值并洗掉第二行和第三行。以及更新 ID
最后，我想輸出
Id Name
1 Here is the result of your examination.
2 New Opening for the position of PT Teacher, Science Lab.
uj5u.com熱心網友回復：
WITH
grouped AS
(
SELECT
SUM(CASE WHEN name=',' THEN 1 ELSE 0 END)
OVER (ORDER BY id)
AS group_id,
id,
name
FROM
TEST_TABLE
)
SELECT
group_id 1 AS id,
STRING_AGG(name, ' ') WITHIN GROUP (ORDER BY id) AS name
FROM
grouped
WHERE
name <> ','
GROUP BY
group_id
ORDER BY
group_id
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/477205.html