I was a trombone player, but I haven't touched it in 15 years. I keep meaning to get back into piano and from there back into bass (probably electric) and...

We just keep a copy of a report file named "_Template.rdl" in the root of our development folder, include a copy in each new project so we have a base...

sure he did,...

But, since it's fun to throw rocks down a well to hear them splash, you could just do this, without mentioning the schema at all.
USE myDatabase;
SELECT top 10...

Try searching for "dynamic pivot" and see what you can find, that will handle your issue. Alternatively, you could impose some sort of practical limit, 15 or 20 diagnosis codes...

Lynn is right and wrong, you can't execute the dynamic SQL in a function BUT you can build it in a function, and execute it after you've called the function...

You are only matching on email, firstname and lastname. Your ID and the EmaiNameDuplicatedParent is what differs, and the same email is in both left and right. So you're not getting...