>Remember that SQL is about manipulating sets of rows not record by record manipulation. You may have to resort to using a cursor which might affect performance.
>
>Can the calculations be embedded with the query?
>
>-Mike

So, you are saying this can't be done? Isn't one of the uses for a trigger keeping repoting or non-normalized data up to date? So, I can only do this if rocount is 1?

BOb