• John Mitchell-245523 - Friday, February 2, 2018 9:24 AM

    You're not imposing.  It's just that it's easier to assist someone who wants help with a specific issue, rather than asking for an end-to-end solution.  You should try working through that article I linked to - you may find it's closer to your situation than you imagine.  And if it isn't, then please do ask for help.

    By the way, might it be possible to put an upper limit on the number of columns?  If you could do that, you wouldn't need dynamic SQL and your problem would get a lot simpler.

    John

    I found that link during my search but, still couldn't get it. I tried putting an upper limit on the number of columns but, the user insists that they need all of them.