Batch Processing - one row at a time

[JackR]

OK - I'm a bit of a newbie here...

I would like to 'process' a table - read a row at a time and INSERT or UPDATE a row in another table. In more practical terms - I have a denormalized table that allowed for 5 items, that now need to be put into a normalized child table. So, I wish to read a record (row) form the source table - and in this case create however of the possible 5 items into the corresponding normailized table, then read the next row in the source table...

In general, how would one accomplish this type of batch processing or programming flow in a SQL script?

Thanks

 

[balachandar]

Well, if you want to do a row by row operation then
you need to use cursors

 

[aalmeida]

The fast option would be an UPDATE statment as:

UPDATE TblA Set ColumnA = Column1
From TblB
where A = B

The Slowest option would be to use a cursor.

AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"