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 |
|
jaikirdatt
Starting Member
1 Post |
 Posted - 2004-09-02 : 15:42:54
|
| How would one do this. I have a database where I have to group by latest week and group by past 6 months and get results and also get the total. Can this be done with group by clause I dont think.I have a database and there is a table called host which will give me a list of host in this database and there is a table called call and all the calls logged by the host will be here. Now I have to get the summary of every single host in this database. like for every host get the called logged in a week, in past 6 months and total number of calls logged till now. Any help is appreciated.jai |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2004-09-03 : 00:07:06
|
| If you posted table structures, example data and desired results then you will probably have a better chance at getting a solution for this problemDuane. |
 |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2004-09-03 : 00:16:23
|
| hi jai< ah - just beaten by Duane >yes, there is always a way. But it depends very much on the way your tables are organised. Post us some DDL (create table statements) and example data (as SQL insert statements) and exepected results and you'll get back an answer, no problem at all.--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
|
|
|
|
|
|
Group by week, group by month