|
With regards to SQL and queries, whats the difference between an in-memory table, temp table and a pivot table?
Started by barfoon on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
A pivot table is a special form of query where the values in several rows are summarisedan in-memory table is a table that's been entirely cached, and so doesn't result in any physical (hard disk) reads when queried....
Query.
|
|
I've seen this , so I know how to create a pivot table with a dynamically generated set of fields. My problem now is that I'd like to get the results into a temporary table.
I know that in order to get the result set into a temp table from an EXEC statement...
Started by brian on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Select o.*, OtherField1, OtherField2 INTO #temp FROM OriginalOtherData as ood PIVOT ( MAX([Value]) FOR Field in (OtherField1, OtherField2) ) as piv RIGHT OUTER join Original....
Have PIVOT tables I'm going to assume the same or 2008.
|
|
I was using mysql just fine until I recently switched one of my rails apps to heroku and had to change over. Almost everything works as expected except I have one query which does something totally funky.
This is the postgres, but under mysql it is mostly...
Started by holden on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
I created a simple table to stand in for your join:
wayne=# \d stuff Table....
It should be no trouble to replace "stuff" with your join .
You didn't say what the schema is, so I pretended all of the data was in one table, omitting the join.
|
Ask your Facebook Friends
|
Is there a pivot table component for Delphi that is opensource or freeware?
Started by RRUZ on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
TFX is a free/open.
The most known pivot component in delphi is ExpressPivotGrid Suite from Develop Express.
Look up in Torry.net.
As far as I know there is no freeware pivot component for Delphi.
|
|
I want to change it from one database to another.
There don't appear to be any options to do this on the pivot table context menu
Started by adolf garlic on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Choose External' right click on the ....
Click the 'back' button twice.
Right click on the pivot table in excel choose wizard click 'back' click 'get data...' in the query click on the pivot table, choose PivotTable Wizard.
|
|
I need to create a pivot table in .net. Can't use any third party control (unless it's free). I tried to find documentation that explains how to create pivot table (algorithm or steps) in general but almost everything is related to excel. Does anyone ...
Started by Sheraz on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
CsharpPivotTable.aspx
MS-Access has the TRANSFORM command (which does a pivot), so you could use ADO.NET to query a ms-access mdb file, then use passthrough queries there to get to the data source that can't pivot shorter than the VBScript....
|
|
I have an Excel spreadsheet which has a pivot table on it. The data itself is quite simple, Number of Units and a Discount (percentage from 0 to 100), pivoted on date across the top and customer down the left hand side. Those numbers are straight from...
Started by Jonathan on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
I will add my formulas there, then do the pivot table), the ....
Of Discount on the pivot table), the part of your formula (100-Sum of Discount) will be returning a negative to the right of the values returned from the query.
|
|
I have a large amount of data that is possibly more than a million rows. I want to be able to offer users the ability to download an Excel spreadsheet with a Pivot Table over this data, disconnected from any database.
Is it possible to have the data source...
Started by James Newton-King on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
They can't refresh unless they have access to the original data .
If you create a pivot table from an external data source, then email it to someone, they can see and interact with your pivot table.
|
|
Hi,
Does anyone know how I can embed an Excel Pivot table control in a win form application developed in C#?
The raw data for the form would be coming from a SQL Server 2000 database and loaded into a DataTable.
Thanks,
Started by theburningmonk on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
You can easily get it to create pivot.
You can try the Winforms OLAP grid from VIBlend.
I don't that you can embed the actual Excel pivot table control into your application but you can this helps.
|
|
I am trying to extract the source data from a pivot table that uses a pivot table cache and place it into a blank spreadsheet. I tried the following but it returns an application-defined or object defined error.
ThisWorkbook.Sheets.Add.Cells(1,1).CopyFromRecordset...
Started by Kuyenda on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
The following code extracts the the pivot cache for every pivot table found in a workbook, puts it into a new pivot table and creates only one pivot field (to ensure that all rows sheet with....
Find a work around.
|
