Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-25 : 11:12:34
|
boris writes "I have a data like this
Customer_DayPart_Morning__Day_Evening
John______1_______5:50
John______2______________13:20
John______3___________________18:50
Paul______2______________13:50
Paul______2______________14:20
Paul______3___________________19:20
Bob_______1________3:20
Bob_______1________4:15
How through sql I can rearrange the data in order to get this
for reporting:
Customer_Morning_Day___Evening
John______5:50___13:20__18:50
Paul_____________13:50__19:20
Paul_____________14:20
Bob ______3:20
Bob ______4:15
Thanks" |
|
|
|
|
|
t-sql