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 |
|
JNotenboom
Starting Member
27 Posts |
 Posted - 2001-09-26 : 06:33:57
|
| Hi,Here is the problem:We did a data import and we have in all the user tables some duplicate records. I can clean them by just go to every table and delete duplicate records (copy into, distinct etc).But I want to loop through all the user tables and delete all the duplicate records in one, let's say, procedure.How do I loop through a collection of user tables (in order to get the table name)? Can I do this by creating a DTS package?regards,Johan |
|
|
|
|
|
Import data by looping through user tables