What is the purpose of requiring a table alias for pivot table if it is for internal reference only?
View Complete Post
Having a little trouble here. I am taking a table (Articles) and grouping all the results by the key that references another table (ArticleSectionCategories). I then want to sort these results by the OrderBy field of the referenced table (ArticleSectionCategory.OrderBy). This is what I am using right now but it is not working. Any thoughts?
var GroupedArticles = from A in DC.Articles
where A.PackagesId == packageId
group A by A.ArticleSectionCategoriesId into G
select G.OrderBy(C => C.ArticleSectionCategory.OrderBy);
SQLServer 2008 R2
Excel 2010 x64
I have a fairly complex Excel report where a raw data sheet is updated from 10 or so PivotTables pulling from an Analysis Services Cube, (2008 R2), with a VBA script that refreshes all pivottables, and then does some post-processing, formatting etc.
This was originally developed in Excel 2003, and the updating of all the pivot tables ran in under 10 seconds
I've now recreated in Excel 2010 and *each table* is taking up to a minute to refresh!
I've also observed that I can get the refresh time of a single table back down to 1sec, if I delete all other pivottables from the worksheet/book.
Its deeply frustrating, as I'm touting 2010 as being the way for our business to go...it won't help the cause if I deliver something with a x60 increase in runtime!
I've run traces of both the 2003 and 2010 versions executing against the SQL Server, the only thing I can see is that the 2003 version passes 1 single MDX query, whilst the 2010 version appears to be firing it in sections.
I've posted this in the Excel forum too.
Please can anyone help?
I want to export my data to excel
sheet. The logic to export data in excel is clear.
Now my query is I have 3 tables and I
want to generate the data jst like below.
And so on.....
The data will come from 3 tables I.e
Master Table for Company
I have an Excel file with Pivot Table connected to MS SQL Analysis Services.
Is it possible to programmatically get this Pivot table (refreshed data) and save it as image (gif, wmf, emf, etc)
I have a new WCF service I'm writing under VS2010 and IIS 7.5. The service includes a table named Client.
When I built my test class and added the service reference, the first test was confirming the creation of the client.
My service reference did not generate any client that I could call .Open on!!!! I was wondering if it is due to that table name???
Edited to add that I tested the service through the browser and it brings up the page and XAML fine.
Thanks for any assistance!