I found the answer. You have to use the RANK()
Example below:
select originator,holdtime,hubtime,
RankHubTime = ROW_NUMBER() OVER(ORDER BY hubtime ASC),
RankHoldTime = ROW_NUMBER() OVER(ORDER BY holdtime ASC),
from #tmp1
Result:
Col1 Col2 Col3 col4 col5<br />
Test1 304925 59674601 1 2<br />
Test2 353072 62857242 2 4<br />
Test3 490172 24462340 4 3<br />
Test4 975875 15261822 3 4
Thanks