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 |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2005-05-25 : 03:43:44
|
| I have a queryselect fromlangauge,tolanguage,firstname,lastname from filestolanguage is a number and I have another table called languages and until now I just did a join to get the language name.Now it's more complicated as tolangauge could be more then one number like 1,2,3,4 Anyway within the query to pull up the languages in a comma delimited string instead of the numbers? |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-05-25 : 03:46:16
|
| Redesign your database so that the language IDs for a file are in another table.Having multiple values in a column breaks the First Normal Form of database design. It's going to make EVERYTHING harder from now on.DamianIta erat quando hic adveni. |
 |
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2005-05-25 : 03:51:17
|
| ok -- i thought of that... but though it would be more complicating --- I'm taking on somethign already done -- but your probably right???tell me if I redesign and have the tolangauges in a dif table(a join table with fileid,languageid -- is there an easy way to in the query still pull them up so that the query will return them as a string in a comma delimited way of languages? |
|
|
|
|
|
|
query help