Open Dental Forum

Thank you Chris.
I wanted to know one row for each procedure code .
Additionally, I am not able to see all the InsPayAmts when I use the query.
looking in the claim table (Select * from claim), there are over 400 records,
Not all of them are shown in the procedure query.
Thanks.

Hi there, I was looking to get the AVG and SUM of insurance payments for the procedures, The query 14 was used and modified, Please let me know if the Query is correct Thank you. SET @FromDate='2016-01-01' , @ToDate='2017-01-13'; SELECT definition.ItemName, procedurecode.ProcCode, procedurecode.Desc...