Transpose Query Output

  • Thread starter Thread starter carl
  • Start date Start date
C

carl

I use this query:

SELECT TotalVolume.[Total Volume: ], TotalTrades.[Total Trades: ],
TotalPIPVolume.[PIP Volume: ], TotalPIPTrades.[PIP Trades: ],
QQQVolume.[QQQ Volume: ], QQQTrades.[QQQ Trades: ], SPYVolume.[SPY
Volume: ], SPYTrades.[SPY Trades: ], PENVolume.[PEN Volume: ],
PENTrades.[PEN Trades: ]
FROM TotalVolume, TotalTrades, TotalPIPVolume, TotalPIPTrades,
QQQVolume, QQQTrades, SPYVolume, SPYTrades, PENVolume, PENTrades;

Which generates output like this (result is horizontal)

Total Volume: Total Trades: PIP Volume: PIP Trades: QQQ Volume:
QQQ Trades: SPY Volume: SPY Trades: PEN Volume: PEN Trades:
384852 36591 219231 19876 15799 456 39362 2286 281466 27156


I am trying to get the result of the query to look like this (result
vertical)

Total Volume: 384852
Total Trades: 36591
PIP Volume: 219231
PIP Trades: 19876
QQQ Volume: 15799
QQQ Trades: 456
SPY Volume: 39362
SPY Trades: 2286
PEN Volume: 281466
PEN Trades: 27156


I would apprciate any help youcan provide.

Thank you in advance.
 
carl said:
I use this query:

SELECT TotalVolume.[Total Volume: ], TotalTrades.[Total Trades: ],
TotalPIPVolume.[PIP Volume: ], TotalPIPTrades.[PIP Trades: ],
QQQVolume.[QQQ Volume: ], QQQTrades.[QQQ Trades: ], SPYVolume.[SPY
Volume: ], SPYTrades.[SPY Trades: ], PENVolume.[PEN Volume: ],
PENTrades.[PEN Trades: ]
FROM TotalVolume, TotalTrades, TotalPIPVolume, TotalPIPTrades,
QQQVolume, QQQTrades, SPYVolume, SPYTrades, PENVolume, PENTrades;
Click to expand...

Oh. My. God.
Which generates output like this (result is horizontal)

Total Volume: Total Trades: PIP Volume: PIP Trades: QQQ Volume:
QQQ Trades: SPY Volume: SPY Trades: PEN Volume: PEN Trades:
384852 36591 219231 19876 15799 456 39362 2286 281466 27156


I am trying to get the result of the query to look like this (result
vertical)

Total Volume: 384852
Total Trades: 36591
Click to expand...

select 'Total Volume' As Metric,[Total Volume: ] As Value
FROM TotalVolume
UNION ALL
select 'Total Trades',[Total Trades: ]
FROM TotalTrades
UNION ALL
select etc.
 
Back
Top