查询某个编号的批次范围

如何通过下面源表的数据查询得到目标表的数据?

源表： 
批次  编号 
1  1000
1  1001
2  1000
3  1001
4  1000
5  1000
目标表：
编号  起始批次    结束批次
1000    1          2
1001    1          1
1001    3          3
1000    4          5

/*---------------------------------
--  Author : htl258(Tony)
--  Date   : 2009-09-11 18:24:47
--  Version: Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86)
    Mar 29 2009 10:27:29
    Copyright (c) 1988-2008 Microsoft Corporation
    Enterprise Evaluation Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 2)

---------------------------------*/
--> 生成测试数据表:源表

IF NOT OBJECT_ID('[源表]') IS NULL
    DROP TABLE [源表]
GO
CREATE TABLE [源表]([批次] int,[编号] int)
INSERT [源表]
SELECT 1,1000 UNION ALL
SELECT 1,1001 UNION ALL
SELECT 2,1000 UNION ALL
SELECT 3,1001 UNION ALL
SELECT 4,1000 UNION ALL
SELECT 5,1000
GO
--SELECT * FROM [源表]

-->SQL2000查询如下:
SELECT a.编号,a.批次 起始批次,MIN(b.批次) 结束批次
FROM (
    SELECT * FROM [源表] t
    WHERE NOT EXISTS(
        SELECT 1 FROM 源表
        WHERE 编号=T.编号 AND T.批次=批次+1)
    ) AS a
    INNER JOIN (
    SELECT * FROM [源表] t
    WHERE NOT EXISTS(
        SELECT 1 FROM 源表
        WHERE 编号=T.编号 AND 批次=T.批次+1)
    ) AS b
        ON a.批次<=b.批次 AND a.编号=b.编号
GROUP BY a.批次,a.编号

 

-->SQL2005查询如下:

SELECT a.编号,a.批次 起始批次,b.批次 结束批次
FROM (
    SELECT rn=ROW_NUMBER()OVER(ORDER BY 编号,批次),* FROM [源表] t
    WHERE NOT EXISTS(
        SELECT 1 FROM 源表
        WHERE 编号=T.编号 AND T.批次=批次+1)
    ) AS a
    INNER JOIN (
    SELECT rn=ROW_NUMBER()OVER(ORDER BY 编号,批次),* FROM [源表] t
    WHERE NOT EXISTS(
        SELECT 1 FROM 源表
        WHERE 编号=T.编号 AND 批次=T.批次+1)
    ) AS b
        ON a.rn=b.rn

/*
编号          起始批次        结束批次
----------- ----------- -----------
1000        1           2
1000        4           5
1001        1           1
1001        3           3

(4 行受影响)
*/