SQL Server row-to-column parsing, SQL Server

SQL Server row-to-column parsing, SQL Server

For more information, see the code:

/* SELECT <Non-pivot column>, [First pivot column] AS <column Name>, [second pivot column] AS <column Name> ,... [last pivot column] AS <column Name>, FROM (<SELECT query for generated data>) AS <alias for Source Query> alias (<aggregate function> (<column to be aggregated>) FOR [<column containing the value of the column title>] IN ([first pivot column], [second pivot column],... [last pivot column]) AS <Pivot table alias> <optional order by clause>; */declare @ tb table (cid int, cname varchar (10 )) insert into @ tbselect 1, 'A' union allselect 2, 'bb' select * from @ tbdeclare @ idaa int, @ idbb intselect aa, bbfrom (select cid, cname from @ tb) as ttpivot (max (cid) for cname in ([aa], bb) piv

The above is all the content of this article. I hope this article will help you in your study or work. I also hope to provide more support to the customer's home!