Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

my dataset not showing any columns Expand / Collapse
Posted Tuesday, November 27, 2012 5:36 AM


Group: General Forum Members
Last Login: Sunday, December 16, 2012 9:28 PM
Points: 15, Visits: 167
HI all i am trying to create a report with data from a stored procedure, i created a stored procedure (which includes Dynamic SQL,Temp Tables) and i tried to create a new dataset with data from the stored procedure when i am trying to add it the dataset is getting created with zero fields, i went to the query part and passed the parameters and the result is showing up. i am kind of confused with the issue becuase my script is working perfectly. i browsed for the issue and some one told to


i tried it but no luck. can any one help me out with this issue.
Post #1389127
Posted Tuesday, November 27, 2012 7:04 AM


Group: General Forum Members
Last Login: Monday, November 16, 2015 7:11 AM
Points: 2,829, Visits: 2,607
I wrote a blog about this that may help. There are also several alternative approaches in the comments below the blog.
Post #1389175
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse