>Thanks. But, if a create a global temporary table could that collide with other users running the procs and creating that same table at the same time?
Yes it probably would. But global temp tables are the only way I know of passing information from one procedure to another. If they aren't global, then any temp table created in one proc goes away atthe end of the proc.
You could try creating a unique table name for each user using the newid() function. Then pass the tablename variable around and use sp_executesql to execute SQL statements creating using the variable. Ex.
declare @tablename char(36), @cmd nvarchar(300)
set @tablename = '##'+replace(convert(char(36),newid()),'-','')
set @cmd = N'create table ' + @tablename + ' (field1 int)'
exec sp_executesql @cmd
You can explicitly drop it at the end of your processing or let SQL Server do it when you disconnect.
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao