I have a proc that is dynamically creating the columns of a report, based upon the number of terms that fall within my reporting period. So perhaps I run it one time and get a student number followed by 8 thems. Then run it again with another range and get student numbers followed by 10 terms.

#tempsum is created and poplulated by looping through student terms and creating #tempsum by 'Select ...into #tempsum. (I found this great way to pivot a table on this forum, a long time ago!) It runs fine the first time, but when I run it again, I get "Temp table #tempsum has changed since last used." (sqlcode 1397). This would be true if I use a different timeframe. But I thought the table would completely drop at the end of the procedure, each time I run it. I even tried to add 'drop table if exists #tempsum;' at the beginning of the proc. Any ideas how to tackle this error? Here is the looping section of the proc.

  drop table if exists #tempsum;
  set @sql = 'Select distinct tstudnum as ''Student'', tname as ''Name'', tclass as ''Class'','|| 
    'tperioddesc as ''Period'', tplanshort as ''PayPlan'','|| 
    'tbalance as ''Balance'', tperbalance as ''PeriodBalance'', tlastpay as ''LastCashTrans''';
  /* now loop through the term hours and add on to the sql statement for all terms.  */
  /* If you view the results of the 'message' you see the outcome!                  */
  for f_fetch
  as c_fetch no scroll cursor for
    select distinct tterm ,tinternalterm
     from tempbundle 
    order by tinternalterm
    for read only
  do 
    set @sql = trim(@sql)||',sum(( if tterm='''||trim(tterm)||''' then 1 else 0 endif) * coalesce(thours,0)) as "'||trim(tterm)||'"'; 
  end for;
  set @sql =  trim(@sql)||' into #tempsum from tempbundle group by student,name,class,payplan,Period,balance,periodbalance,lastcashtrans;'; 
  execute immediate @sql;

  select distinct  * from #tempsum order by payplan,period,student;