Sean Lange (11/2/2012)
That seems like a horrible way to name your columns but in order to do that you will have to use dynamic sql. Make you sure you wrap your column names with [] or it won't work.
As horrible as it seems, I know it can happen.
Once, a developer asked me to use the column names exactly as the user should view them to avoid additional processing and coding at the front end.
This works for reports, not for creating permanent tables.