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

[pvidya]

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.

 

[pvidya]

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

Thanks.