I have no musical ability, but I learned some piano and french horn. I can remember some of the piano, but won't recommend to be around if I try to...

Here's the explanation on the code shown by Saravanan.
An Alternative (Better?) Method to UNPIVOT (SQL Spackle) - SQLServerCentral
And obviously, the explanation of UNPIVOT can be found...

One simple test that I keep available for demonstrating performance of scalar functions.
There's no data access or any real work being done in the functions, it's just the cost...

The first thing that you should do is to get out of the view designer and use the query editor.
Then write the query as you want it in a...

There are many problems with that query, but I tried to get it correct. This might give you an idea on what could work.
I'm guessing that this is a...

My guess is that you might need to use the OVER clause. However, it's hard to be sure. Check the articles on my signature for further help.

Thank you, guys. I just hope my manager won't hate me (more) for going against the "cloud architects". At least, I'm sure that I'll get support from the other DBAs...