I modified Steve's code: This will return all 3 rows if you send the value of '0'.
DECLARE @Data_Group_Number CHAR(1);

SET @Data_Group_Number = '0';

WITH group1...

I've never needed to do anything like this, but I would think you could tie the image to the group footer.  I may be way off, it has been a...

In the properties for the cell, under 'Number' there is Format, if you put a lower case d it will display the date without the time in MM/DD/YYYY format.

2018 World Series Champs, Pirate's!!  🙂   Heck, I'll be happy if they finish above 500, the bums. 

OK, I couldn't figure out how to do it with PIVOT without hard coding the names. I'm sure there is a way, just not seeing it right now.
Here is...

I would think you would only need one pivot statement.  Pivot the name and percentage in the same statement.  If you can't get that to work, I think 'Cross Apply'...

What have you tried?  Did you try using PIVOT?
https://technet.microsoft.com/en-us/library/ms177410(v=sql.105).aspx

I think we should spring forward a half an hour this year, then we never change the clocks again.  Get the best of both worlds. IMHO 🙂

We use SSIS for all of our ETL.  I would prefer that SSIS be used more for EL and not (T)ransform.  Setting up the SSIS to Extract and Load the...