Change in temporary tables from 9.01 to 9.02? -
04-27-2006
, 04:50 PM
The following code has been used in ASA 9.01.1751 without problem. It
leads to another code section that references the temporary table
#Temp:
SELECT hot_id, internal_id INTO #Temp1 FROM Hotline
WHERE call_date >= ' 2006-1-1' AND call_date < '2006-3-31'
AND h_agy_id = 4;
SELECT MAX(hot_id) as hot_id INTO #Temp FROM #Temp1
WHERE internal_id IS NOT NULL
GROUP BY internal_id;
In ASA 9.02.3044, this routine throws an error that #Temp cannot be
found. Is this a change in behavior from 9.01 to 9.02 or is it a bug
that requires a more up-to-date EBF patch? Any advice would be
appreciated.
Mark Shapiro |