Windows 7 which has .net 3.5 and is turned on and W7 comes with Powershell 2.0. Also have .net 4.5 installed. Looked at the logs no errors reported.

Great working examples, thanks for the education!

Amazing how fast this query works...Thank you!

Here's what I've come up with:

select distinct [800number], (

select top 1 CompanyName

from calldata

where calldata.[800number]=cd.[800number]

group by [800number], CompanyName

order by [800number], count(*) desc) as companyname

from calldata cd

My issue is this solution...

Thanks for the reply, I only want the results to show the 800 number with the greatest row count.