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 |
|
Otacustes
Starting Member
15 Posts |
 Posted - 2008-09-01 : 09:13:55
|
| Hi all,If I have columns in a table containing comma delimited tags, is SQL (MS Access) capable of determining the changes between them?For instance if columnA contains A1,A2,A3,A4 and columnB contains A1,A3,A4,A5 does SQL contain the capability to determine that A2 is missing and A5 has been added?If it cannot do this, what is the best alternative?Any help or guidance offered is greatly appreciated.Thanks |
|
|
georgev
Posting Yak Master
122 Posts |
Posted - 2008-09-01 : 09:48:12
|
Generally you should split the comma delimited tags in to a one:many relationship.
George |
 |
|
|
Otacustes
Starting Member
15 Posts |
Posted - 2008-09-01 : 11:08:54
|
| Hi GeorgeHow does that work? I understand a one:many relationship but am not sure of the implementation of what you are describing!!Any help or guidance offered is greatly appreciated.Thanks |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-01 : 11:25:46
|
| Read up on relationships and normalization in books online.Press F1 in MS SQL |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-09-01 : 11:44:11
|
http://www.datamodel.org/NormalizationRules.html
E 12°55'05.63"N 56°04'39.26" |
|
|
|
|
|
|
Delimited String Question