[Question] Crystal / VB ASP .net / Stored Procedure

[Paul M.]

Hi,
I have a Crystal Report that I want to have use as its datasource a
SQLServer 2000 stored procedure, basically the sp would do several selects
to insert data from several tables into 1 temp table (first letter of temp
table name = #) then the last thing I do is select * from #temptable.
However Crystal can not see in the VB .net IDE any fields just the SP. If
all I do is create the temp table and then do select * from #temptable I can
see the fields in the SP when I add the SP to Crystal within the VB IDE.
Obviously doing the latter is no good as I need to do several selects prior
to the last one to populate my temp table.

Anyone got any ideas?

Thanks
Paul

 

[Paul M.]

The answer (as I have just found out!) is to put the line "SET NOCOUNT ON"
at the start of the SP as the rows affected figure returned by action
quesries prior to the main (and final select) counts as a recordset return
and therefore the any after are discounted.

Cheers
Paul