Group: General Forum Members
Last Login: Monday, October 14, 2013 7:59 AM
|Steve Jones - SSC Editor (1/16/2013)
This kind of works, but I'm wondering if you've calculated something in this view already.
SELECT cid, COUNT(DISTINCT ccid)
GROUP BY cid
I think this should be fine ..If not please post the ddl's .I am unable to understand the problem..
this is how I tried , le me know it works for you..
CREATE TABLE #test
INSERT INTO #test
-- Edited this part
(SELECT SUM(ccount) FROM(SELECT CCOUNT
FROM #test GROUP BY CID,CCOUNT)abc)CountTotal
Wondering what I would do next , when I am done with this one