Andy check the original post again please I've redone the question to help more and added some code.

Have a look when you can and let me know if...

I’ve lost you Andy. I don’t what the code is doing I’ll have to look into it. Eg I don’t know what pivot is so I’ll have to look that...

“You're usually better off at that point creating entirely different stored procedures for the different categories”

Totally agree Andy. In fact, I hate this approach but it’s been thrown at...

Slight edit in the code.

When Category = 1
Then SELECT Col1, SELECT Col2, SELECT Col3, SELECT Col4, SELECT Col5
SELECT Col6 AS EMPTY STRING,...

Not sure I’ll try it in a week when I get back into the office so for now I’m turning notifications off

And I’ll get back.

The IsActive column is something...

You’re right. I haven’t got a clue. The design is crap I can tell even as a junior dev thats something isnt right.

Thanks. I’ll try it out see what...

Here you go.

https://stackoverflow.com/questions/51464758/retrieve-show-columns-based-on-user-input

Had to go to Stack Overflow. Posting on here via mobile was really difficult.

Thanks

Hi. I was having some difficulties with this site so i posted on stack overflow. Am i allowed fo give you the link?

Sorry for the formatting guys. Uploaded from

The phone and I won’t be doing that again.

Thank you all for your help, your time and your guidance.