
Temporary Table already exists
Could be you're reusing a pooled connection. You could try adding SQL to
check for the existence of the temp table and drop it if it shows up before
the select ... into, like this:
TmpSelect = "if object_id('tempdb..#rsTmp') is not null drop table
#temptable Select Mast.fsono, Item.fline Into #rsTmp... "
--
Bob
Microsoft Consulting Services
------
This posting is provided AS IS with no warranties, and confers no rights.