I also work in the health industry. We require all PAC Systems (Picture Archiving and Communication) to support HSM. One department runs a screening program, 20% of the images acquired...

Thanks for your help.  I have come up with a method that seems to work efficiently enough. It involves making a join on the customer ID and the Date Of...

I would love to use your second suggestion but unfortunately the OrderID is not sequential (a kind of GUID).

I am trying your first...