Solved

SUPPRESS RESULT SET FROM A STORED PROCEDURE

Posted on 2008-10-16
1
1,763 Views
Last Modified: 2008-12-12
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

Open in new window

0
Comment
Question by:DEADSETONFINISHING
1 Comment
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 250 total points
ID: 22733208
>Is it possible to suppress a resultset from a stored procedure?
no.
only the "x rows affected" can be supressed with the SET NOCOUNT ON

anything else needs to be programmed into the "other" procedures, a parameter to say "don't return anything, just do your work.
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Suggested Solutions

I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
How to increase the row limit in Jasper Server.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now