Category: UNPIVOT using VALUES

Till SQL 2008 VALUES clause was used only in conjunction with INSERT statements to insert values to a table. Starting from SQL 2008 onwards functionality of VALUES clause has been extended which enables it to be used in many scenarios…