Need SQL query help with dialed number string

[kavle]

Hi All,

could anyone help me with the query where I can get total call count  (number of calls hit the DN) monthly wise for the specific "DialedNumberString" from RCD or even from TCD also with "digitsdialed "

We have grouped multiple DNs and mapped single CallType so not a great visibility to see how many calls came to each DNs.

regards,

Kavle

[bill.king1]

You mean like
Select Count(DialedNumberString) as CountofCalls, DialedNumberString
from Route_Call_Detail
Group by DialedNumberString
There's obviously a lot more you might want to filter out by date and such but that's what you want?

[kavle]

yes sir , I have multiple DNs . I want to pass around 15 DNs into a single query and obtain the result of callcount .

I am trying with CASE clause to do it however not exactly getting what's the proper way.

[kavle]

Thanks, Bill, for the reply, I have figured out now.

[bill.king1]

How'd you do it, with a IN type statement I' guessing? Do you want to post how you did it here to benefit the next person?