title: Temporary tables in Crystal Reports
body: <p>i have sql building a temporary table. it runs fine in SQL server management studio, but as soon as i put it into the crystal report add command feature it doesnt work. i have found that it is not working when it try and update the table with this line of code.</p>
  
  <pre><code>declare @newDate datetime
  select @newDate = MIN(r.DateTimeStamp)
   from StationInspection as si
  left outer join
      @report_out as r
  on r.InspectionID = si.InspectionID
  where r.Station = 2     
  
  
  UPDATE @report_out 
   set
  DateTimeStamp = @newDate
  where Station = 2
  </code></pre>
  
  <p>i am just not sure why that made Crystal Reports not accpet it any long</p>