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.
Search found 2 matches
- Mon Mar 06, 2017 9:12 am
- Forum: Advanced Topics
- Topic: Avg Insurance Payment
- Replies: 4
- Views: 8910
- Sun Mar 05, 2017 2:25 am
- Forum: Advanced Topics
- Topic: Avg Insurance Payment
- Replies: 4
- Views: 8910
Avg Insurance Payment
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...