You use Microsoft SQL Server 2012 database to develop a shopping cart application.
You need to rotate the unique values of the ProductName field of a table-valued expression into
multiple columns in the output.
Which Transact-SQL operator should you use?
A.
CROSS JOIN
B.
CROSS APPLY
C.
PIVOT
D.
UNPIVOT
Explanation:
http://technet.microsoft.com/en-us/library/ms177634.aspx
C
0
0
c
0
0