Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

No rowset was returned for this query, table or procedure.

Status
Not open for further replies.

pvidya

Programmer
Jan 26, 2007
20
US
Hi,

I am trying to create a Crystal 8.5 report off a SQL 2000 stored procedure. When I try to make the procedure the basis of my report, it gives the error: 'No rowset was returned for this query, table or procedure.'

I have faced this before. I comment everything out and place 'SELECT 'A' AS [A] as the last line, it works. After that I usually 'un-comment' section by section and perform the 'Verify Database' step in Crystal to eventually get the original proc work with the report. This is not working for me this time.

CREATE PROCEDURE [dbo].[proc_name]
@BeginDate datetime
,@EndDate datetime
AS

CREATE TABLE #abc
(<fields> <datatype>)

INSERT INTO #abc EXECUTE [another proc] @BeginDate @EndDate

SELECT <field list>
FROM #abc INNER JOIN....<other tables>
GO

The following statement seems to be offending Crystal

INSERT INTO #abc EXECUTE [anotherproc] @BeginDate @EndDate

Any ideas on how to fix/get around this? Or perhaps something else is the issue. The procedure returns data when executed for the same parameters in SQL Query Analyzer.

Thank you for your time.



 
Never mind!! I added a SET NOCOUNT ON to the start of the proc and all is well!

Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top