>>Would you use UNION ALL to accomplish this (solution #1)?
>>Do you have a reason for choosing #1 over the others?
>>Do you think the other 2 solutions could be "unstable" because of the large rowsize?
>
>Einar,
>
>I would expect it to be faster and yes, I would use UNION ALL if possible.

Thanks Sergey. UNION ALL works great and solution #1 is a lot faster (factor 10). Thanks for your assistance.