SQL row to Column PIVOT column career UNPIVOT

Original: SQL row to Column PIVOT column career UNPIVOT

One:

Existing table one (T_TABLE1), want to convert to table two (t_table2) format.

Table I:

year	company	revenue
2013	Company 1	12
2013	Company 2	22
2013	company 3	32
2012	Company 1	42
2012	Company 2	52
2012	Company 3	62

Table II:

Years	Company 1	Company 2	Company 3
2012	42	52	62
2013	12	22	32

Pivot that can be supplied after using sql2005

Here's how:

Select
*
From T_table1 t

PIVOT
(Sum (revenue) for company in (company 1, Company 2, company 3)) a

The result is table two.

Two:

Table II can also be converted to table one, using Unpivot. Here's how:

Select
*

From T_table2 t
UNPIVOT
(Income for company in (company 1, Company 2, company 3)) a

The result is table I.

SQL row to Column PIVOT column career UNPIVOT