Re: Dynamically inserting values in temp table from stored procedure

[serle shuman]

Look at the restrictions on using temp tables at the moment. As soon as you use a temporary table more than twice in a stored procedure it gives a runtime message of table not found. This is misleading, but happens as soon as you use the temp table in more than two statements. Hopefully this restriction will be fixed soon as it severely limits the use of temporary tables.