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-09-19 : 10:15:49
|
Moez writes "Hi, I need a stored procedure that will print time in increments of 15minutes on the left column and the name and phone number on the other columns depends on the appointment of the person. This is what I have in a appointment table.Appointment Table Appt_IDAppointment_dt_tm Patient_ID Patient TablePatient_IDNamePhoneTest Data Appointment Table12001-09-13 8:00 AM122001-09-13 10:15 AM4432001-09-13 11:00 AM12Report In the folowing formatTime Name Phone Number07:0007:1507:3007:4508:00 John Smith 888 888 8888....10:0010:15 Mr Doe 999 999 9999..11:00 Sandy 999 777 7777.....16:00 How can I create a sql statment that will bring this report back?Thanks" |
|
|
|
|
|
Schedule Report