Oh .. I see... that would probably work, but is IMHO a little messy. So I just used regular syntax and temp tables.

>*the problem with ##tables is in multiuser enviornment if 2 people call the sp at the same time... KaBOOOM...
>
>Right, I understand. Maybe I wasn't clear...can you create a unique table name, using a unique user identifier? I'm not sure if it would work in your situation, but figured I'd ask.
>
>Kevin