Quite a tricky question, I am not aware of a way that it can be done without using dynamic SQL.

Am interested if anyone has a solution ..