title: SQL Server compare results of two queries that should be identical
body: <p>I am modifying a sql server 2005 stored procedure slightly for performance, and I would like to quickly make sure the old stored proc and the new one return the exact same results (the columns are the same, I want to make sure the rows are the same). </p>
  
  <p>Is there a simple way to do this in sql server 2005?</p>