help with query

[babysilvertooth]

IS there a query for: top 50 procedures by number. That is, the procedures that are done the most by quantity. (how many pros, crowns, etc).

[Hersheydmd]

Try this:
SET @FromDate='2011-01-01' , @ToDate='2011-12-31';
SELECT Count(*),pv.Abbr, pc.ProcCode, pc.AbbrDesc, AVG(pl.ProcFee) as '$Ave. Fee' , SUM(pl.ProcFee) AS '$Tot. Prod' FROM patient
INNER JOIN procedurelog pl ON patient.PatNum=pl.PatNum
INNER JOIN procedurecode pc ON pl.CodeNum= pc.CodeNum
INNER JOIN provider pv ON pl.ProvNum=pv.ProvNum
WHERE pl.ProcStatus = '2' AND (pl.ProcDate >=@FromDate
AND pl.ProcDate <= @ToDate)
GROUP BY pc.ProcCode
ORDER BY Count(*)DESC Limit 50

[babysilvertooth]

Thanks!

HOw about one for: Pt's who have spent >$sum for the year.

[Hersheydmd]

Thanks!

HOw about one for: Pt's who have spent >$sum for the year.

Put Production in the search field and you'll find many examples at:
http://70.90.133.65:1942/ODQueryList/QueryList.aspx