MS SQL 2000 에서의 ROW_NUMBER()

select name, title, regdate, identity(int, 1, 1) seq into #PLAN_TEMP

from TABLE
order by regdate
 

select D.seq, C.name, C.title, C.regdate  
from TABLE as C

     Inner Join #PLAN_TEMP as D on

           C.name = D.name
 

drop table  #PLAN_TEMP