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 |
|
ImTheodore
Starting Member
16 Posts |
 Posted - 2012-05-14 : 11:13:08
|
| I need the total for males and females for each hour:[Sex] [Day] [Time] [Day of week]M 01-01-06 0:00 SundayF 01-01-06 0:00 SundayM 01-01-06 0:00 SundayM 01-01-06 0:00 SundayM 01-01-06 1:00 SundayF 01-01-06 1:00 SundayM 01-01-06 1:00 SundayM 01-01-06 2:00 SundayM 01-01-06 3:00 SundayF 01-01-06 4:00 SundayF 01-01-06 4:00 SundayM 01-01-06 4:00 Sunday etc...Should appear like this:[Date] [Time] [Day of week] [M] [F]01-01-06 0:00 Sunday 3 101-01-06 1:00 Sunday 2 101-01-06 2:00 Sunday 101-01-06 3:00 Sunday 101-01-06 4:00 Sunday 1 2Thanks,Dave |
|
|
ITTrucker
Yak Posting Veteran
64 Posts |
Posted - 2012-05-14 : 11:44:44
|
| Should be something like this:SELECT [DATE], [TIME], [DAY OF WEEK],[M] = SUM(CASE WHEN [SEX] = 'M' THEN 1 ELSE 0 END),[F] = SUM(CASE WHEN [SEX] = 'F' THEN 1 ELSE 0 END)FROM [TABLENAME]GROUP BY [DATE], [TIME], [DAY OF WEEK] |
 |
|
|
ImTheodore
Starting Member
16 Posts |
Posted - 2012-05-14 : 12:57:31
|
| I knew it was easier than I was making it out to be (creating and joining temp tables), Thank You very much! |
|
|
|
|
|
|
Subtotals