Created
December 13, 2012 15:50
-
-
Save orangexception/4277332 to your computer and use it in GitHub Desktop.
Offending stored procedure outputs redundant/useless data. It also skews my expected resultsets, so I sent suppressed it.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- SQL Server Suppression Table | |
-- Suppress Stored Procedure Output | |
-- Create Suppression Table | |
CREATE TABLE #SuppressionTable ( | |
Value000 VARCHAR(MAX) | |
) | |
-- Insert ResultSet into Suppression Table | |
INSERT INTO #SuppressionTable | |
-- Execute Stored Procedure | |
EXECUTE StoredProcedureThatReturnsUselessData | |
-- Forget Suppressed Data | |
DROP TABLE #SuppressionTable |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment