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 |
|
Ali T
Starting Member
22 Posts |
 Posted - 2009-01-18 : 14:58:58
|
| Dear all;I have a table including the call record data of a telecom company. the columns of this table as as follow: ID, Date, and durationneedless to say that each record (row) of this table represents a call (i.e if a subscriber makes 10 call we would have 10 records in the table)Now what I'm going to do is to calculate the number of days in which each Subscriber (ID) has had a call (no matter outgiong or incoming) and add the results as a column to another table named R wich has two columns named "id" and "noofdays" . in this table ID are unique. I'm looking for a query that can extract the number of days in which the customer has made a phone call for every single cutomer.I'd be grateful if you help mewith this problem.RegardsAli |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-18 : 22:57:22
|
| have answered it herehttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=118046 |
 |
|
|
|
|
|
Day count 2