>>That's not what I meant. Read up on creating views in SQL Server and making them updatable. You would be using this view instead of the table in your code then.
>>
>>I had several links when I first was reading your question, but I don't have them right now and don't want to start searching again.
>
>Well, I do not want to update the table. I only want to update the result so I can ship that to a client.

I don't recall all details right now, but AFAIK you can set up your view to only update view and not the base table.