Aha, DrAxeman, the problem is in the way you are growing your data!

From looking at your earlier posts I see that you have been progressively working toward this dataset. In a previous post you had a similar problem, but you must have only been considering one server. Now you appear to have multiple servers and you decided to MUNGE the column names with the SERVER NAME.

Instead you should add a column with the SERVERNAME and solve the problem with SQL the same way you did in your earlier posts.