The database contains a simplified healthcare claim data model consisting of two tables:
1. MedicalClaimheader: Contains 1 record (claim) per medical encounter. The table contains the following columns;
2. MedicalClaimDetail: Contains 0 or more records for each procedure made during a medial encounter. The table contains the following columns;
The MedicalClaimDetail table is related to the MedicalClaimheader table by the ClaimNumber field.
I need to write a T-SQL query that finds every MedicalClaimDetail row where a procedure J1234 was performed multiple times on the same day for the same member.