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 |
|
Vivaldi
Constraint Violating Yak Guru
298 Posts |
 Posted - 2001-05-10 : 11:38:10
|
| Well,Back again. I have a table that has some denormalized data (induced by scope creep) that lists contacts and a comma separated string of the facilityids they are contacts for.FacilityContactsID|name|facilitycontactsEx: #| txt| #1, #2So is there a simple way to turn thisone contact entry into 2 entries, and each entry having a separate facilityid number?EX:44| bob | #159| suzie | #2My feeling is I will have to do this in the vb app, is there a simple way to do this in sql.Also, with this method, is there a way to add a sequence number to each entry?EX:44| 1 | bob | #159| 2 | suzie | #2Thanks for the help(and previous help) |
|
|
|
|
|
using a "split" function in sql