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-08-13 : 08:37:26
|
| J. M. Harper writes "if you don't mind, I have another question for youtblJohnsGrades[grade, date][51, 08/08/2001 10:53:00 PM][84, 08/08/2001 11:53:00 PM][99, 08/08/2001 1:53:00 AM][18, 08/08/2001 10:05:00 PM][78, 08/08/2001 10:54:00 PM]Now what I want to do is pull the hours of the date one-by-one to see how many grades were done in that hour....for example if i wanted to create a chart to see in what hour of the day john's teacher does most of her grading, what code would I use?ThanksJ. M. Harper" |
|
|
|
|
|
select group by hour of a date string