Help with this query, a Challenge.. Thank you

[load1982]

i have.. something like this

Item --------------Ord
41512016----------8153359
41850002---------- 8153360
41850009----------8153360
43490004----------8153361
43490098----------8153361
43490100----------8153361
43500007----------8153362
41512016----------8153363
41512030----------8153363
41850002----------8153368

i need a third column with a secuence number depending on the order number. something like this:

item --------------ord---------------Sec
41512016----------8153359----------1
41850002----------8153360----------1
41850009----------8153360----------2
43490004----------8153361----------1
43490098----------8153361----------2
43490100----------8153361----------3
43500007----------8153362----------1
41512016----------8153363----------1
41512030----------8153363----------2
41850002----------8153368----------1

the order of the item doesnt matter, i just need a secuence there.

please help!!!!!!!!

[rmiao]

In which rdbms?

[load1982]

in SQL 2005. i have a really dumb query right now.. really slow, and really big.

if somebody can give me an idea it will be very appreciated.

Thank you