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.
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"