Don't worry :o) You wouldn't believe the stuff I've been overlooking today :o)


>>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.