Home Forums SQL Server 2012 SQL Server 2012 - T-SQL SQL Pivot? RE: SQL Pivot?
LoudClear
SSC Eights!
Points: 999
More actions
July 24, 2014 at 1:52 pm
#1732192
Hi Ken -
HOW variable is the data? I think this impacts the solution. Your example data currently results in 21 columns. What's the maximum # of rows per ItemID in the input? Would you always want all of them in one huge output row?
- Adam