Matrix Transpose TSQL
- by rmdussa
Can we do matrix transpose (rows become columns and columns become rows) in standard SQL?
1 2 3 4 5
4 5 6 6 7
7 8 9 8 9
1 3 4 5 6
2 4 5 6 7
changes to
1 4 7 1 2
2 5 8 3 4
3 6 9 5 6
4 6 8 5 6
5 7 9 6 7
how about no of rows < no of column ?
let's consider the no of rows it's fixed.