June 2008 - Posts

• SQL Server 2005 UNPIVOT Command - changings columns to rows (normalizing)

  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... Posted Monday, June 16, 2008 3:55 PM by mab | 2 Comments Filed under: SQL Server