ChrisM@Work (7/22/2013)
SELECT op, SUM(CASE WHEN dupes > 1 THEN 1 ELSE 0 END)
FROM (
SELECT op, imei, dupes = COUNT(*)
FROM #mastertab
GROUP BY op, imei
) d
GROUP BY op
can you please explain your query... I am not getting outer select statement... SUM(CASE WHEN dupes > 1 THEN 1 ELSE 0 END)
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/