Multiple sets of column names and the capability of dynamic, interchangeable columns
Posted on 2004-09-07
I'd like to have 2 sets of column names for a particular table. One set will include long, descriptive titles and the other will use short, Reporting Services/Report friendly/Spaceless column names. How can I do this (I have approx 800 columns)? Is there a way I can use the 'Description' feature located when you 'Design' a table in Enterprise Manager to assign either the long or short name and then have it appear as the column name?