Can someone tell me why this simple command doesn't work?

update #d2
set order_seq=(select isnull(max(order_seq),0)+1 from #d2)

All I want it to do is number order_seq 1,2,3 etc. but they all get a 1 (They are all 0 to start with).

Thanks.