Thanks Peter, that's exactly what i need.

Yes, that's probably the only solution in this case: writing into a temp table. Thanks all for your replies!

Paul,

Thanks a lot! Works like a charm, great solution. Thanks again!

Guys, thanks very much. Got it all working just fine. Didn't realize that executing an "Execute" statement that uses variables inside of it will put all previuosly declared variables out...

Thank you all, guys. Unfortunately, this particular database is pretty much overnormalized, so for now it's the only solution. We are looking into denormalizing it partialy for reporting purposes. Thanks...