title: SQL statement selecting most recent date no longer working
body: <p>I've had a sudden failure in one of my reporting routines and have traced it back to the having portion of my statement. The function this has been serving, up until 2 days ago, was selecting the most recent date from the <code>dbo.data_feed_file</code> table (column name: <code>File_Date</code>). </p>
  
  <p>Statement follows</p>
  
  <pre><code>HAVING (dbo.data_feed_file.file_date = (Select MAX(File_Date) as Expr1
                                          FROM dbo.data_feed_file AS data_feed_file_1))
  </code></pre>
  
  <p>First: is there an alternative way to write this? I've gotten my report working by removing the statement, it's just 2.5 million more lines than I want. I know I can hard code the date to pull just the specific date I want, but automation is obviously preferred.</p>
  
  <p>Second: Does anyone know what could cause this to spontaneously fail? I'm the only person with access to edit this query so I know nothing was changed (no really, nothing changed).</p>
  
  <p>Thanks in advance.</p>
  
  <p>Edit: To add clarification: There is no error message, the column headers are showing up as anticipated but no data is populated, it's just blank fields (as though nothing met the having criteria). The statement completes as though there is nothing wrong. I've confirmed there are no NULL values in the File_Date column.</p>