I have a series of commands I am sending to my SQLserver. When I execute the string it works and I get 1 back from the SQLexec but I don't get a data set. When I execute the command in QA is works too. Here is the command string. I have made blank lines between commands but it goes as a single string from VFP. I have also tried taking the two 'drop table' commands off the end of the string but I still don't get data back.

select a.repcode,  a.purord,  count(a.sernum) as qty , b.stuff   into #select1 
 from scraps a  LEFT OUTER JOIN redcode b ON a.scrapcode = b.number  where 
a.purord in (select distinct purord from income where  custnum = 'AF' OR 
custnum = 'AF3') and a.actiondate >= '01/01/05' and a.actiondate <= '09/07/05' 
and b.stuff not like 'INPUT ERROR%'  group by a.repcode,  a.purord, 
a.scrapcode, b.stuff  order by a.repcode, a.purord,  a.scrapcode, b.stuff ;  

select distinct purord, recdate into #select2 from income;  

select a.*, b.recdate from #select1 a left outer join #select2 b 
on a.purord = b.purord order by a.purord ;  

drop table #select1;  

drop table #select2