The reason you are struggling here is because you have violated 1NF by stuffing parent and child keys into the same tuple. You need to redesign how you are handling...

spam reported.

LOL just got this message from a Facebook friend. "While working on a SQL statement just now I ran into an issue that I needed a little help to solve....

What is the issue? Please see the first link in my signature for best practices when posting questions.

It would be remiss if somebody didn't mention that the root of your issue is that you are storing dates as varchar. You should choose the appropriate datatype for the...

And of course the "correct" answer is only half correct anyway as SQLPERF can also reset wait and latch statistics.

Your data in here appears to have a weak attempt at obfuscating your data. There is too much real information in here. Real doctors, hospitals that are vaguely disguised. Makes...