Y大叔的筆記

CREATE TABLE #ResutTbl (SerialNo int,Pages varchar(8000)) DECLARE @SerialNo int, @Page varchar(20) SET @SerialNo = 0 DECLARE append_page CURSOR FOR SELECT SerialNo,Page FROM SampleTbl ORDER BY SerialNo OPEN append_page FETCH NEXT FROM append_page INTO @SerialNo,@Page WHILE @@FETCH_STATUS = 0 BEGIN IF (SELECT COUNT(*) FROM #ResutTbl WHERE SerialNo=@SerialNo) = 0 BEGIN INSERT INTO #ResutTbl (SerialNo, Pages) VALUES (@SerialNo, @Page) END ELSE BEGIN UPDATE #ResutTbl SET Pages = LTRIM(Pages + ',' + @Page) WHERE SerialNo=@SerialNo END FETCH NEXT FROM append_page INTO @SerialNo, @Page END CLOSE append_page DEALLOCATE append_page SELECT * FROM #ResutTbl DROP TABLE #ResutTbl