sql - How to convert Row values into column which is containing string values? -
this table name table1 id | columnname | columnvalue ----------------------------------- 48 | vehicleno | abc-0134 48 | in-time | 10:00 48 | out-time | 11:00 and want result bellow: id | vehicleno | in-time | out-time 48 | abc-0134 | 10:00 | 11:00 please me desired result. one method using pivot . select [id], [vehicleno], [in-time], [out-time] (select id, columnname, columnvalue tablename) pivot (max(columnvalue) coulnname in([vehicleno], [in-time], [out-time])) piv