Sergey

That didn't work, I ended up with the same results. I guessing because it was not distinct with the grouping clause.

select det.PrimaryProcedure,
	det.PrimarySurgeon,
	det.PrimeDesc,
        det.CatalogNo,
	det.ItemNumber,
	det.ImmsField,
	sum(det.actualqty) as  totalused, 
	sum(det.actualqty * det.itemunitcost)as avgCost,
	count(DISTINCT det.meetingnumber) as CaseCounter

from
	(SELECT rtrim(dbo.coinv.primedesc) as PrimeDesc, 
	       rtrim(dbo.coinv.catalogno) as CatalogNo, 
	       rtrim(itemnumber) as ItemNumber, 
	       dbo.cocasedata.linkedid, 
	       dbo.coCaseData.ActualQty,
	       dbo.coCaseData.ItemUnitCost,
	       (dbo.coCaseData.ActualQty * ItemUnitCost) as ExtdCost,
	       (select isnull(immsfield,' ') from dbo.coinv i where i.invid=coCaseData.linkedid) as immsfield, 
	       (select isnull(CostBeforeCF,0) from dbo.coinv i where i.invid=coCaseData.linkedid) as CostBeforeCF, 
	       (select isnull(cf,' ') from dbo.coinv i where i.invid=coCaseData.linkedid) as CF,
		dbo.Get_PrimaryProcSurgeonByMeetID(meetings.meetingnumber) as PrimarySurgeon,
		dbo.Get_PrimaryProcDescByMeetID(Meetings.MeetingNumber) as PrimaryProcedure,
		(Select top 1 ProcID from dbo.meetproc where meetproc.meetingnumber=meetings.Meetingnumber order by sysorder) as ProcID,
		dbo.meetings.MeetingNumber

	 FROM   dbo.meetings INNER JOIN 
	       dbo.cocasedata ON dbo.meetings.meetingnumber = dbo.cocasedata.meetingnumber INNER JOIN 
	       dbo.coinv ON dbo.cocasedata.linkedid = dbo.coinv.invid 
	WHERE     (dbo.meetings.iscompleted = 1) 
	and meetings.begintime between @ltQueryFrom and @ltQueryTo 
	and coInv.invid<>@gnNonItemID 
	and timeChargeItem=0
	and coCaseData.ActualQty>0
	AND meetings.deptid=@lnDeptID ) as det
where det.PrimarySurgeon='AMEIKA, JAMES' and procID=1118
group by PrimaryProcedure,PrimarySurgeon,primedesc,catalogno,itemnumber,immsField
Order By PrimaryProcedure, PrimarySurgeon