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 |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2010-02-12 : 11:53:05
|
| Hello,I am running a stored procedure (sp) in the Data tab so that I can create a dataSet. of the reporting services 2005.This dataset returns too many fields in the result pane below.Question: I should really see these fields in the dataset window on the left hand side of the screen but it shows different fields. The fields in the dataset shown are not as same as the fields returned in the result paneDo you know why?Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-12 : 12:10:06
|
| that may be because you've not refreshed dataset using refresh button on menu. the result shown on object explorer might be one that stored procedure returned before recent changes.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2010-02-12 : 12:15:39
|
| I have refreshed for sure.This is very strange... |
|
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2010-02-12 : 12:18:44
|
| Note that stored procedure returns many fields but no records.Surely the dataset in the datasets window should show only those fields, right? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-12 : 12:28:48
|
| yup. between does sp returns only single result set or are there multiple?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2010-02-12 : 16:39:44
|
| simplified the query which returned data and it is all ok now.Thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-13 : 10:07:12
|
quote:
Originally posted by arkiboys
simplified the query which returned data and it is all ok now.Thanks
so was it returning multiple resultset?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2010-02-13 : 14:11:25
|
| yes. thanks |
|
|
|
|
|
|
create new dataSet