>That's what I meant :o)
>
>
>>>I thought that as long as the computed column was deterministic (something like total AS (Qty * Price)) then it would be calculated at INSERT or UPDATE time only and the column could be used as an index and then optimizable...
>>
>>There is no need of calculation. At least not by you. You could use "Computed" column and put formula there. This is SQL Server :-)

O!
I misunderstood "would be calculated at INSERT or UPDATE...", I read it as "should be calculated at INSERT or UPDATE...". Grrr.
Sorry Tracy.