>Hi Roman,
>
>To be honest, I didn't try to test this solution and at this moment I don't have SQL Server available. However, Tawrn at 0ASP forum at tek-tips.com tested this solution against your suggested idea and found the speed in the first case about 10 times faster. Here is a thread in tek-tips (unfortunately, in order to view you would have to join the forum):
http://www.tek-tips.com/viewthread.cfm?spid=333&sqid=452982&newpid=333>
That link to tek-tips doesn't work anymore.
If it's not broken, fix it until it is.
My Blog