SQLTeam.com | Weblogs | Forums

How to make pivote table from this source table


#1

Hello I have the following source table but my Inputs are more than one row for each Dates. I want to make the Pivot table from this source tbale. can yu guide me please? Thank you

date time Speed
01-05-2017 20:30:00.0000000 80
07-05-2017 04:45:00.0000000 100
08-05-2017 21:00:00.0000000 90


#2

Please post create table and inserts script.