Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #1676

how to make a matrix from a series of data

Show all headers | View raw

I have following input:

select TIER1, TIER2, AMOUNT 
from   RESULT_SET1;

TIER1 TIER2 AMOUNT
===== ===== ======
1     1     400
1     2     150
1     3     100
2     1     300
2     2     20
2     3     30

I need to build a matrix out of it, as below:


      TIER1
      =====   =====
      1       2
T              
I 1 :  40%     30%
E 2 :  15%      2%
R 3 :  10%      3%
2

I can't wrap my brain around making a matrix out of series of values I get from my result set. Any ideas would by much appreciated. We run SQL Server 2008.

Back to comp.databases.ms-sqlserver | Previous | Next — Next in thread | Find similar

Thread

how to make a matrix from a series of data migurus <migurus@yahoo.com> - 2014-02-11 09:49 -0800
  Re: how to make a matrix from a series of data Erland Sommarskog <esquel@sommarskog.se> - 2014-02-11 22:07 +0100
  Re: how to make a matrix from a series of data migurus <migurus@yahoo.com> - 2014-02-11 15:21 -0800

csiph-web