DEADSETONFINISHING
asked on
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 "SalesTracingNdcMainReport ByRepSP".
Thanks!
See Code Snippet for example..
I'd like to call MONTHLYREPCOMMISSIONS and return only the results from the third stored procedure "SalesTracingNdcMainReport
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.