Luis Cazares (11/2/2012)
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.
Yeah I too have that type of requirement and I shudder. Seems like many times they come back and agree with me that the column names are horrible. Of course you still have to know how to tweak that dynamic sql to get those names the first time. 😉
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/