This kind of works, but I'm wondering if you've calculated something in this view already.

SELECT cid, COUNT(DISTINCT ccid)

FROM dbo.MyTable

GROUP BY cid