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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-09-12 : 07:38:31
|
| Zee writes "Goal: Copy the contents of x amount of columns from say TableA into various other existing tables.Method: Create an SP to retrieve each row in TableA and store each column data into a variable then, take that column and insert into a different existing table but ensuring that there are no duplicate records.Problem: While retrieving the row, one of the columns (say ColumnA) has comma separated values. Each CSV data within ColumnA needs to be verified for duplicate records in say TableB. Once verified, then it needs to be entered into TableB as new record(s). For example, if "Cat, Dog, Tiger" is the value and only "Cat" and "Dog" are present, then "Tiger" needs to be entered as a new entry.Database Server: MSSQL 2000Some help would be appreciated!" |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Data Manipulation 
