If you take a photograph of yourself, and then dye your hair, does the hair colour in the photograph change?
You've effectively taken a snapshot of the data in the...

DELETED - Somehow managed to double post

I would also consider separating Directories and Files into their own tables.

And how do you handle a tie?  Where the patient sees multiple providers the same number of max times.

SQL Prompt decrypts the procs

Below are 2 different methods for calculating the time differences

1 - Calculate the INT difference, and then convert the result to TIME.
SELECT [Time1] = [YourIntField1]
...