title: SQL Server - compare the results of two stored procedures that output multiple tables
body: <p>So, similar to <a href="https://stackoverflow.com/questions/11017678/sql-server-compare-results-of-two-queries-that-should-be-identical">"SQL Server compare results of two queries that should be identical"</a>, I need to compare the output of two stored procedures to ensure the new version is generating equivalent output to the old version. The tricky part is that my SP outputs six tables of differing widths.</p>
  
  <p>I started writing a hybrid version of them that would compare each of the tables individually, but it's a pretty complex SP, so I was hoping there was an easier way.</p>
  
  <p>I tried using EXCEPT as in the linked question, but it looks like that will only compare one table to one other table.</p>