[阅读: 1257] 2007-04-10 17:35:07
下面这段SQL生成的结果我想把 while 里面多次 SELECT 出的东西合并到一个结果集中该如何做？
这是我想改进论坛贴子列表的试验SQL
[CODE=SQL]
DECLARE @BlockID AS int
DECLARE msgBlocks CURSOR FOR
SELECT TOP 20 BlockID FROM forum_msgs
WHERE owner_board_name = 'java' AND BlockLayerID = 0 ORDER BY date_msg DESC
OPEN msgBlocks;
FETCH NEXT FROM msgBlocks INTO @BlockID
WHILE @@FETCH_STATUS = 0
BEGIN
SELECT * FROM forum_msgs WHERE BlockID = @BlockID ORDER BY BlockOrderID
FETCH NEXT FROM msgBlocks INTO @BlockID
END;
CLOSE msgBlocks;
DEALLOCATE msgBlocks;
GO
[/CODE]
| -ICP -IDC -ISP |