Error while running sp_blitz in 2008 SQL Server and lower versions
One way you could go about this if you want to influence data types or column names is create an intermediate table to store the result of the stored procedure and then selecting from it.

Something along the lines of 

CREATE TABLE #temp (&lt; column definitions like the stored procedure returns &gt;);

INSERT INTO #temp EXEC sp_Blitz;

SELECT &lt; CAST columns to data types you want &gt; AS &lt; alias column names to names you want &gt; 
FROM #temp;