Are you sure? I don't see why it shouldn't work in this case.

>
>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
>