-
Help with this query, a Challenge.. Thank you
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!!!!!!!!
Last edited by load1982; 02-03-2009 at 04:04 PM.
-
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|