Top "Pivot" questions

How to merge two rows into one row in sql?

I have a table as EmployeeID IndividualPay FamilyPay IsActive 1 200 300 true 1 100 150 false But I want the output as follows(I want …

sql pivot

SQL Pivot with String

I have two tables in SQL Server: Customer and Address Customer Table: CustomerID FirstName LastName ----------- ---------- ---------- 1 Andrew Jackson 2 …

sql pivot

Create a Pivot Table from a DataTable

I am using C# winforms to create an application that needs to turn a datatable into a pivot table. I …

c# winforms datatable pivot pivot-table

TRANSFORM and PIVOT in Access 2013 SQL

How can I get second table from first table using TRANSFORM and PIVOT functions: TABLE_01 Config_ID | ConfigField | ConfigValue ----------------------------------------- 11 | …

sql pivot ms-access-2013

SQL Transpose Rows as Columns

I have an interesting conundrum which I believe can be solved in purely SQL. I have tables similar to the …

sql postgresql pivot pivot-without-aggregate

Using Multiple filters in DAX

I'm new to DAX. I'm currently using Power BI and trying to create a total sum of sales that use …

excel pivot dax powerbi

SQL Server 2005 Pivot on Unknown Number of Columns

I am working with a set of data that looks something like the following. StudentName | AssignmentName | Grade --------------------------------------- StudentA | Assignment 1 | 100 …

sql sql-server pivot

One-to-Many SQL SELECT into single row

I have data in two tables. The first table has a Primary Key called PKID PKID DATA 0 myData0 1 myData1 2 myData2 …

mysql pivot

SQL - Pivot table and group by not working

I have a table as follows: Product #users Date Count Type prodA 29 2013-02-27 113 Document prodA 31 2013-03-02 152 Extraction prodB 17 2013…

sql sql-server-2008 pivot pivot-table

SQL Server 2008 Vertical data to Horizontal

I apologize for submitting another question on this topic, but I've read through many of the answers on this and …

sql-server pivot transpose