Thank you Luis!

I love when I find out my code is doing something stupid, I learn something new every day I'm in SQL and you have opened my eyes to...

[SOLVED]

SELECT

CustomerNumber,

SUM(CASE WHEN yearseq = 2012 THEN isnull(mainPower,0)+isnull(sidePower,0)+isnull(leftPower,0)+isnull(netappPower,0)+isnull(rightPower,0)+isnull(lowerPower,0) ELSE 0 END ) AS [2012],

SUM(CASE WHEN yearseq = 2013...

Thanks for the heads up Sean, I do know the issues with using Nolock, but unfortunately it’s my company’s policy to use it on all queries. Also the data...

Thanks for the article, I did some reading and some more and its semi clear, but not 100% I also didn't paste the full query I am using. So...