Posted by Ed Murphy on 05/29/07 17:51

Oonz wrote:

> Actually i will combine the multiple numbers into one single record
>
> the temporary table structure would be like this
>
> No Name Phone FinalPhone
> 1 test1 12345 12345
> 1 test1 23455 12345<br> 23455
> 2 test2 68638 68638
> 2 test2 34454 68638<br> 34454<br>
> 2 test2 45445 68638<br> 34454<br> 45445
> 3 test3 67684 67684
> 4 test4 54808 54808
> 4 test4 74594 54808<br> 74594

Add a DateInserted column, and use it in sorting.

If you delete the row with Phone = 34454, do you want to have to also
update the row with 45445 so that FinalPhone = 68638<br>45445? Of
course not - that would be a maintenance nightmare. Move FinalPhone
from the database to the UI layer, or at least from the table to a view.

[Back to original message]