Thanks, that is perfect.

Adam

Thanks the temp table route seems to work fine. I have found that you can use table variables in an exec statements, but they need to be declared in the EXEC...