我创建了一个PIVOT查询，但是结果很好。我想拉平行，这样可以说并将所有值移到列表的顶部，而将NULLS移到列表的底部。

http://sqlfiddle.com/#!18/7d17d/6

代替这个：

+----------+----------+----------+----------+----------+
|    A     |    B     |    C     |    D     |    E     |
+----------+----------+----------+----------+----------+
| Report 1 | (null)   | (null)   | (null)   | (null)   |
| (null)   | Report 1 | (null)   | (null)   | (null)   |
| (null)   | (null)   | Report 2 | (null)   | (null)   |
| Report 3 | (null)   | (null)   | (null)   | (null)   |
| (null)   | (null)   | Report 4 | (null)   | (null)   |
| (null)   | Report 4 | (null)   | (null)   | (null)   |
| (null)   | (null)   | (null)   | Report 4 | (null)   |
| (null)   | (null)   | (null)   | (null)   | Report 5 |
| (null)   | Report 6 | (null)   | (null)   | (null)   |
| (null)   | (null)   | (null)   | (null)   | Report 7 |
| (null)   | (null)   | (null)   | (null)   | Report 8 |
+----------+----------+----------+----------+----------+

我想创建这样的东西：

+----------+----------+----------+----------+----------+
|    A     |    B     |    C     |    D     |    E     |
+----------+----------+----------+----------+----------+
| Report 1 | Report 1 | Report 4 | Report 4 | Report 5 |
| Report 3 | Report 4 | Report 2 | (null)   | Report 7 |
| (null)   | Report 6 | (null)   | (null)   | Report 8 |
+----------+----------+----------+----------+----------+