Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Returning Multiple Datasets
Message
From
17/06/2008 08:09:14
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, United States
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
01324579
Message ID:
01324657
Views:
13
>I wrote a simple sproc:
>
>
>
>CREATE PROCEDURE Kevin_Test
>AS
>
>	SELECT * FROM Product
>	SELECT * FROM Inventory
>
>GO
>
>
>
>Then in Crystal Reports.Net I connected to the database and brought in the sproc. I only see the first data set. Anyone know what I'm doing wrong?
>
>Thanks

IIRC, you can only return one result set to Crystal.
Very fitting: http://xkcd.com/386/
Previous
Reply
Map
View

Click here to load this message in the networking platform