Sqlserver 2000低版本如何 多条件分组 程序审核时自动生成编号

Question

时间排序先后顺序 站点 工程 位置 标准 方式 分组 自动从01开始叠加上 01->02-03
如同审核按钮效果 点一下 查找站点 工程 位置 标准 方式 分组后 到最大编号+1 每总数量大于等于100 时 也要+1

IF OBJECT_ID(N'TEMPDB.DBO.#T') IS NOT NULL
DROP TABLE #T
GO

CREATE TABLE #T
(ID VARCHAR(10),
 Concrete VARCHAR(20),
 Munber VARCHAR(20),
 GCMC VARCHAR(20),
 WZ VARCHAR(20),
 FS VARCHAR(20),
 sj datetime,
 FL decimal(18,2),
 SEQ VARCHAR(20)
)

INSERT INTO #T (ID,Concrete,Munber,GCMC,WZ,FS,sj,FL,SEQ)
SELECT '1-1','00600','连州市旅游','桥柱','C10','泵','2019-10-02 15:55:05','90','' UNION ALL
SELECT '1-1','00601','连州市厂房','拉锯设备底座','C30','天泵','2019-10-02 16:05:05','10','' UNION ALL
SELECT '1-1','00602','连州市厂房','拉锯设备底座','C30','天泵','2019-10-02 17:00:48','90','' UNION ALL
SELECT '1-1','00603','连州市厂房','拉锯设备底板','C30','天泵','2019-10-02 19:33:45','100','' UNION ALL
SELECT '1-1','00604','连州市厂房','拉锯设备底板','C30','天泵','2019-10-02 20:07:07','110','' UNION ALL
SELECT '1-1','00605','连州市厂房','拉锯设备底座','C30','天泵','2019-10-02 20:22:20','190','' UNION ALL
SELECT '1-1','00606','玻璃桥','底座','C55','直卸','2019-10-02 21:00:00','201','' UNION ALL
SELECT '1-2','00111','玻璃桥','底座','C55','直卸','2019-10-02 22:00:00','120','' UNION ALL
SELECT '1-2','00112','玻璃桥','柱','C30','直卸','2019-10-02 22:30:00','30','' UNION ALL
SELECT '1-2','00113','玻璃桥','底座','C55','直卸','2019-10-02 23:30:00','15','' UNION ALL
SELECT '1-2','00115','天桥','底座','C35','直卸','2019-10-03 00:30:00','1','' 
GO

select * from #T

Answer 1

sql server不支持rowid rownumber这些，只能写一个存储过程，定义一个行号变量，然后循环。当然也可以在asp.net 程序这里来设置。