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 - 2002-06-17 : 08:29:51
|
| jac writes "Hi,I have a database that logs telephone calls to 3 different premium rate numbers. One of the fields contains the CLID (phone number) of the person that called and another holds the date and time of the call. From the log database I need to work out how many people have called once, twice, three times a week, etc.I am trying to do this in SQL Server and it has got me stumped.I really hope you can help me.Many thnx.Jac." |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-06-17 : 09:05:41
|
| Maybe if you keep posting this question, someone give you a better answer than mine.<O> |
 |
|
|
|
|
|
Need to count how many people call once a week/ twice a week? etc.