Given the column naming convention, I think there might be a simpler solution than using an EAV.  This assumes that there are three sets of weights: PWT, PNT, and...

@lalitprg2017 ,

The graphics you posted are great especially for showing the final result you wanted (which is the key to solving this problem without many words) but they're horrible for...

What are these WT1, WT2...... in the output? Why 15 has to be shown under WT1 for B and not in WT2?

You can use CASE WHEN THEN ELSE END...

Here we go again... 🙁

i would suggest to make sure to have the following measures applied before embarking to real database migration;

Use Updated Versions. First, keeping your hardware, hypervisors, and software updated is...

I think adding the WeekDay and Hour columns to the main table make the most sense.  Computed columns will be more efficient than a trigger, but they do have...

I'm glad someone else said that.  If they're the ones that are going to review the...

Thanks for the feedback.  I wish I had the answer for you folks.  I dont.  Hopefully , someone else might see this and be able to rattle one off.

And, isn't...

Why...

I use it a fair bit in real life.

You've posted delimited data.  Take it to the next step and post it as readily consumable data and you might get better answers because more people will give it a...

Just in case you need to fight off the folks that still think that regular index maintenance based on logical fragmentation is a good idea, Microsoft finally "got the word"...

Then the derivative code from SwePeso's post will correctly return the total number of decimal hours for you.  You only think his code was complex because he included test data...

Understood... Such a statement generally means that no value will be...

So... lemme get this straight... you actually have a 4.1 TERAbyte TempDB???  This suggests to me that your code has some real problems and that you grew tempdb to that...