有什么敲不出的,多花点时间而已。
WITH t(Col1,Col2,Col3,Col4,Col5,Col6,Col7,Col8) AS (
SELECT 84849.24,NULL,4.00,NULL,20182.36,25329.12,84853.24,NULL UNION ALL
SELECT 8133357.24,NULL,290222.00,455.00,3601150.08,7227791.64,8423124.24 NULL UNION ALL
...
SELECT NULL,NULL,2.00,1.00,2.00,1.00,1.00,NULL
)
SELECT * FROM t