Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
X-Factor
Constraint Violating Yak Guru
392 Posts |
 Posted - 2010-06-19 : 09:29:02
|
| Hi there,I have a table of entertainment venues. Each row essentially is an address. I want to be able to store a custom text formatting for any of the venues. For example one venue is a boat so I want to be able to say 'aboard...' instead of 'at' in an order email.So where do I store the format string? At the moment I have added an extra column to the venue table. But now aren't I mixing data with presentation?Perhaps I should have a second table of 'formats' to give me the option of having multiple formats for each venue. i.e. format in order email or format on web page. Then I would have a join table between venues and formats where each row would identify a venue and a format and provide a format string.Any ideas?Cheers, XF. |
|
|
|
|
|
Storing text formatting