I have a brain block this AM
This table contains transactions on sales orders that must be serialized in a seq column (int) by adddate (datetime) within sales order order sono (char).
So, if a sales order has 10 transactions the seq column must be 1,2,3, etc in ascending order by adddate.
Because of insertions, deletions, etc, I need to be able to reserialize the transactions for a given sales order with a tsql command(s).
Can anyone unbock my brain?
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.