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. UNP

IVOT

Explanation:

http://technet.microsoft.com/en-us/library/ms177634.aspx