iterate through a table

[junkmail]

I have a table "a" with a list of files names of data that I want to bulk insert into table "b". My question is what is the simplest way to do this.

Sample data in table a

path(column name),flag(column name)
c:\work\data1.txt,false
c:\work\data2.txt,false

Now I want to iterate through table "a" and use the bulk insert command using the "path" column to bulk insert the data into table "b". I also want to change the "false" flag to "true" to denote that the file has already been imported. I seem to be having a problem with the looping through the table to get the next row to do the bulk insert.

 

[gmmastros]

The simplest way is like this:

Insert Into b(Path,Flag)
Select Path, 1
From   a

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[markros]

You will need to use a cursor to 'loop' through each row in a table. Take a look at this link with the similar concept

http://www.sqlusa.com/bestpractices2005/importimage/

See also this link as how to use cursors the best way (the above sample does not use the proper keywords):
The Truth about Cursors - Part 1

PluralSight Learning Library

 

[junkmail]

Thanks!