>Hi Naomi
>
>Thx for that, and there was me trying to be clever and do it in SQL.
>
>That'll teach me LOL
>
>.
It actually depends. In your case it could be a good solution. In our case it was a long process and we needed to execute this kind of select many times. The result was unsatisfactory. However, if you need just one select it may work OK and you would not notice the performance difference.
If it's not broken, fix it until it is.
My Blog