select COUNT(*) specimen_id from QuickLabDump a
left outer join PracticeandPhysician c
on (a.[Requesting Physician]=c.doctorfirstname+' '+c.DOCTORLASTNAME
        and a.[practice code]=c.practicecode)
 where 
DATEPART(mm, [DATE entered]) =12
and
DATEPART(yy, [DATE entered])=2011
	
select COUNT(*) specimen_id from QuickLabDump a
 where 
DATEPART(mm, [DATE entered]) =12
and
DATEPART(yy, [DATE entered])=2011
	
select COUNT(*), c.practicecode, a.[Requesting Physician],speciment_id
from QuickLabDump a
left outer join PracticeandPhysician c
on (a.[Requesting Physician]=c.doctorfirstname+' '+c.DOCTORLASTNAME
    and a.[practice code]=c.practicecode)
where 
DATEPART(mm, [DATE entered]) =12
and
DATEPART(yy, [DATE entered])=2011
GROUP BY c.practicecode, a.[Requesting Physician], speciment_id
HAVING COUNT(*) > 1