Select DATE,Car,Bike,Cycle Into #TableName
From
(Select DATE,SettingName,SettingValue From T01)u
PIVOT(Sum(SettingValue) For SettingName in(Car,Bike,Cycle)) AS Pvt
Create Table TableName (Columns)
Insert TableName
Select DATE,Car,Bike,Cycle
From
(Select DATE,SettingName,SettingValue From T01)u
PIVOT(Sum(SettingValue) For SettingName in(Car,Bike,Cycle)) AS Pvt