@lalitprg2017 ,

More proof of what I was talking about for the "Readily Consumable Data" thing.  Two other folks saw a pattern that I'd missed and could easily test their solutions...

Assuming the pattern in the sample data is actually representative of your production data, the following would be simpler and more efficient as it eliminates the need to unpivot,...

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...