SUPPRESS RESULT SET FROM A STORED PROCEDURE

Is it possible to suppress a resultset from a stored procedure?

See Code Snippet for example..

I'd like to call MONTHLYREPCOMMISSIONS  and return only the results from the third stored procedure "SalesTracingNdcMainReportByRepSP".

Thanks!

ALTER              PROCEDURE dbo.MONTHLYREPCOMMISSIONS 
@Year int,
@Period int,
@Rep varchar(10)
AS
DECLARE @SQL NVARCHAR(4000)
DECLARE @ParameterList nvarchar(200)
DECLARE @ParameterList2 nvarchar(200)
 
EXEC OutOfTerritorySP @Year,@Period,'0'
EXEC FSDBMR.dbo.SalesTracingCommissionInvoiceDetailReportSP @Year,@Period
EXEC SalesTracingNdcMainReportByRepSP @Year,@Period,0
 
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

Select all Open in new window