ChatGPT is DANGEROUS. It always produces results that seem plausible but can be entirely wrong. If you are lucky, it just won't compile. If you aren't it may...

I copied and pasted just the phone number in question from the XML you posted and put it in the following code.  The "special characters" are an ASCII 160... which...

It could also have a default like GETDATE() or some other non-null, non-blank fixed value.  That's why I'm thinking that the folks that asked the question are the ones best...

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