Skip to content

Instantly share code, notes, and snippets.

@orangexception

orangexception/gist:4277332

Created December 13, 2012 15:50
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save orangexception/4277332 to your computer and use it in GitHub Desktop.
Save orangexception/4277332 to your computer and use it in GitHub Desktop.
Download ZIP
Offending stored procedure outputs redundant/useless data. It also skews my expected resultsets, so I sent suppressed it.
Raw
gistfile1.sql
-- 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