>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?
Sorry don't have the answer to hand (my T SQL is terrible) but I might be able to help clarify the question- suggest asking about "sequentially number" vs "serialize" which has a whole different meaning to .NET programmers. (i.e to read out to a byte or character stream)
Imagine you'd have to have a trigger on insert, delete etc but how to do the trigger - I get very confused in a set based environment (and would therefore probably handle this on the business object end where I could loop the lines in the sales order)
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.
