如何创建PIVOT QUERY CREATE [英] HOW TO CREATE PIVOT QUERY CREATE

问题描述

<pre lang="xml">
</pre>

hi,,

I GOT RESULT FROM QUERY :

TITAL   PCS RGH_CTS    VALUE
SEND    10  49.8550    198742.94400
BID     15  76.7070      327461.76300
FINAL   19  88.5630    337954.15600

I WANT LIKE THIS OUT PUT  : HOW TO SOLVE THIS ,,,

| TITAL     |    SEND      |    BID       |   FINAL      |
| PCS       |     10       |    15        |     19       |
| RGH_CTS   |   49.8550    |  76.7070     |   88.5630    |
| VALUE     | 198742.94400 | 327461.76300 | 337954.15600 |


ANY BUDDY CAN SOLVE THIS MY SIMPLE QUERY  ?.
THANKS IN ADVANCE :</pre>

推荐答案

从这里学习。非常简单，试试自己



http：//blog.sqlauthority .com / 2008/06/07 / sql-server-pivot-and-unpivot-table-examples / [ ^ ]

Learn from here.its very Simple ,try yourself

http://blog.sqlauthority.com/2008/06/07/sql-server-pivot-and-unpivot-table-examples/[^]

此外还有Mr.King，你可以参考这个链接。

http://www.mssqltips.com/sqlservertip/3000/use-sql-servers-unpivot-operator-to-help-normalize-output/ [ ^ ]

http://sqlhints.com/2014/03/10/pivot-and-unpivot- in-sql-server / [ ^ ]



希望这可以帮到你。

In addition Mr.King,also you can refer this link.
http://www.mssqltips.com/sqlservertip/3000/use-sql-servers-unpivot-operator-to-help-normalize-output/[^]
http://sqlhints.com/2014/03/10/pivot-and-unpivot-in-sql-server/[^]

Hope this may help you.

any buddy can use this query like result and output.....

SELECT Tital,
       [SEND],
       [BID],
       [FINAL]
FROM   (SELECT t.TITAL AS tt,
               c.TITAL,
               cdata
        FROM   Tablename t
               CROSS apply ( VALUES ('PCS',[PCS]),
                                    ('RGH_CTS',[RGH_CTS]),
                                    ('VALUE',VALUE) ) c (TITAL, cdata)) a
       PIVOT (Max(cdata)
             FOR tt IN([SEND],
                       [BID],
                       [FINAL])) piv

这篇关于如何创建PIVOT QUERY CREATE的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！