help with scheme changes to live system.

Hi Gurus,

Please forgive this naive question:

Say, I have a table (containerId, itemId) where for each containerId there
are several rows (different itemId value) in that table. Now I want to give
those rows (with same containerId) a sequence, so add one colum there to
make it become (containerId, itemId, sequence); how do I make such changes
through SQL?

I know how to alter the table to insert that new column, but how do I
populate the existed rows on that new column? note the sequence dose not
need to confirm to any sorting of other columns, i.e., as long as there is a
sequence is ok. for example, if I already have :

containerId | itemId |
1 1001
1 1002
1 1003
2 2001
2 2002

then either

containerId | itemId | sequence
1 1001 0
1 1002 1
1 1003 2
2 2001 1
2 2002 0

or

containerId | itemId | sequence
1 1001 2
1 1002 1
1 1003 0
2 2001 0
2 2002 1

are all OK.

Thanks,
Gnale

_________________________________________________________________
Is your PC infected? Get a FREE online computer virus scan from McAfee
Security. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963