SELECT num, [val1], [val2], [val3], [val4], [val5] FROM ( SELECT num, val FROM TableName ) AS DT PIVOT (MAX(val) FOR num IN([val1], [val2], [val3], [val4], [val5])) AS PT
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)