Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

convert multiple columns to ROws in sql server

select *
  from yourTable
  unpivot (
    Value
    for NewCol in (Value1, Value2, Value3,Value4, Value5)
  ) up
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #convert #multiple #columns #ROws #sql #server
ADD COMMENT
Topic
Name
2+6 =