Thank you for the advice. I'm still very new at SQL but hopefully this will help clarify what I am looking to do:

Create Table #ClaimSummary

...