Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
BigRetina
Posting Yak Master
144 Posts |
 Posted - 2002-10-14 : 04:46:42
|
| salute.. I have a stored procedure that contains INSERT statements and other calculations.. the last statement is a SELECT FROM a temp table..and basically this is the recordset that I want to return!. In Crystal Reports in VS.NET when I choose an OLEDB data source in the databases and I choose my stored procedure it does not contain any return fields..or database fields!...but if i a put ONLY ONE select statement in that stored procedure everything works fine ofcourse! by the way..if I use this stored procedure to FILL a DATASET it works fine and it fills a table in my dataset with the rows selected from the temp table..everything is smooth!. what can I do?.. please HELP me...i need this fast! Thanks In Advance |
|
|
Peter Dutch
Posting Yak Master
127 Posts |
Posted - 2002-10-14 : 05:44:26
|
| check www.aspfaqs.comfaq #174 |
 |
|
|
BigRetina
Posting Yak Master
144 Posts |
Posted - 2002-10-14 : 08:32:40
|
Thanks..It is about SET NOCOUNT OFF.. |
|
|
|
|
|
|
Crystal Reports and a Stored Procedure