Lab Sql

I have a table which I need to pivot for reporting services: DateCreated Rands Units Average Pr… Read more Pivot A Fixed Multiple Column Table In Sql Server

This is a follow up question to Transpose one row into many rows Oracle I want to be able to unpivo… Read more Have Unpivot Automatically Grab Column List (oracle 11g)

I am transforming data from this legacy table: Phones(ID int, PhoneNumber, IsCell bit, IsDeskPhone… Read more Tsql - Help With Unpivot

I have a table like this one RowNum | TranNo | nTotalSales | nBalance 1 | 1 | 800 … Read more How To Convert Columns To Rows?

I have a table in PostgreSQL like below: ----------------------------------------------------------… Read more Query For Crosstab View

I have a table as MarketOutput that has 20 Columns [Region] [LOB] [GWP 2013] [GWP 2014] [LR 2013… Read more Dynamic Unpivot And Split Columns Sql Server 2012

I have this table: id fName lName Address PostCode ContactNumber --------------------------… Read more Sql Query To Get The Resultset In Two Columns Only

Following is my sample dataset: ID Prod1 Prod2 Prod3 1 ABC01 CDE02 XYZ03 I want to conv… Read more Converting Rows To Columns Using Unpivot