With SQL Server it is possible to Rotate columns in lines, to do this, it makes use the key word UNPIVOT. The syntax is special because it is not intuitive, this sample query transforms columns into rows of a SQL Server table. It...
With SQL Server it is possible to Rotate columns in lines, to do this, it makes use the key word UNPIVOT. The syntax is special because it is not intuitive, this sample query transforms columns into rows of a SQL Server table. It...