Not that I'm aware of besides creating temp table before executing dynamic sql.
>So no way to do it in multi-user safe style?
>
>
>
>>>But that solution is problematic in a multi-user environment. If 2 or more people call the sp at the same time, kaboom...
>>
>>Yes, the global temporary tables are not for the multi-user environment.
--sb--