Hi Scott, thanks for your solution, I'm really sorry I didn't see it before I posted my earlier reply. That's some helpful advice about UNPIVOT and CROSS APPLY. For someone...

Hi ktflash and Steve,

Thank you both very much for showing me the error in my boolean logic, obvious really 🙂 and then how to get the results I needed. I've...

A huge thank you @Taps and pietlinden, both have done just what I needed and shown me two different ways to solve the problem. Thanks again.

Hi Jeff,

Many thanks for "shifting gears". Your tweaking of Steve's original solution is very useful. As you correctly spotted I am actually trying to work on a workload...

Steve,

Thank you, thank you, thank you!
That's just perfect and absolutely what I needed and so quick.

🙂

Jason and Mark,

Both of your solutions work perfectly, thank you so much for taking time to look at my problem and help out. I've learnt something new.

Cheers,

Ian.

Thanks for getting back to me and I will post my expected output, but to try and clarify, currently in a multiple on/off scenario I get all records that have...

Apologies for my delay but here is my DDL and DML which I hope I have presented correctly. I have also re-written the CTE at the end of the code...

OK will do, thanks.

Ian.

Jeeeez,

What is it with you lot??????????

You know nothing about exactly what this database holds or how it is managed or what happens to the data............

I'm simply a newbie asking for...

Wow, easy when you know how. My mistake was using '*' in the SELECT rather specifying the column name in the csv file, I'm learning all the time.

Thanks so much...

Thank you so much, that certainly does do it.

Cheers, Ian.

Thanks Jeffrey and Jack, I shall follow the leads you gave me.

Ian.

Sadly, even with your code edited I still get the error message that more than 1 value is returned by the query. I'm not smart enough to figure that one...

Thanks G-Squared,

Brilliant, that appears to do just what I need, now to examine the code and try to understand what went on!!

If it's not too cheeky, if I want to...