Microsoft
70-457 · Question #28
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 correct answer is C. PIVOT. See the full explanation below for the reasoning.
Question
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?
Options
- ACROSS JOIN
- BCROSS APPLY
- CPIVOT
- DUNPIVOT
How the community answered
(35 responses)- A3% (1)
- B17% (6)
- C71% (25)
- D9% (3)
Community Discussion
No community discussion yet for this question.