Miscellany

(
	select	sum(txa1.total_charge)
	from	Claim_Charge txa1
	inner join Claim_Header txa2 on txa2.claim_header_pk = txa1.claim_header_fk
	where	service_date = Daily_Summary.date
		and txa2.replaced = 0 
		and txa2.non_primary_payer = 0
		and txa1.voided = 0
)