PivotTable

khh · Post by **khh** » Fri 18 Feb 2011 15:23

Hello,

How I can get the SQL behind the PivotTable result?

Thanks

.jp · Post by **.jp** » Fri 18 Feb 2011 16:32

Thanks for the post.
Please specify the product name and the version you are using.

khh · Post by **khh** » Sat 19 Feb 2011 02:38

dbForge Data Studio for SQL Server 1.0.127

Alexz · Post by **Alexz** » Mon 21 Feb 2011 11:19

There is the Edit SQL Text button on the toolbar.
After click this button, the document Text view will be opened, and you will be able to edit the SQL text.
Also you can clik Edit Text or Design Query in the context menu of the root node in the Data Source window.

khh · Post by **khh** » Mon 21 Feb 2011 13:48

This brings SQL for the source table.

I meant the result SQL for the PivotTable.

Meaning the SQL that will give me PivotTable.

Alexz · Post by **Alexz** » Mon 21 Feb 2011 14:27

The pivot table is build with internal functionality help without using SQL. So there is no SQL statement that you asked.

khh · Post by **khh** » Mon 21 Feb 2011 14:46

OK

It would be a great feature if it is using native SQL statements.

"SQL PivotTable Designer" is what was in my mind.

Thank you

Alexz · Post by **Alexz** » Mon 21 Feb 2011 15:16

Thank you for the suggestion.
We'll consider implementing this feature in one of the next versions of the product.