Scenario A table that contains several columns that you need to take and change into rows in order to normalize the data. With SQL Server 2005, a new T-SQL command UNPIVOT can help. An example table: **Table called MyTable FieldID FieldOne FieldTwo FieldThree
Read More...