Thank you for helping, Kevin.

I am getting an error which states:

"S2.StartDate is invalid in the HAVING clause because it is not contained in either an aggregate function or the GROUP...

Thanks a bunch! That worked. Now I have to work to figure out why it worked

Thank you all for your help. It turns out that the comment that the rows "aren't as distinct as you thought" was right-on.  The static table holding the departments had...

Greg - thanks for your time and suggestions. Before I saw your post I did the following: I added an identity field, imported the data (the result set was still...

PW - I tried the first suggested resolution in the link you posted, but it did not work. The resulting table still had <null>s where real values ought to be.

Since the...

PW - thanks for letting me know this is a known issue and that I am not doing something wrong. I will try to re-enter the data after reformatting the...