Loop through SQL table.
Posted on 2007-04-10
I think what I am asking is simple.
But I can not work it out.
I have a Microsoft SQL table.
It is one column. Example below.
Micrososoft SQL 2003.
I need to pick each Product and insert into another table.
An example of the insert statement : Insert into Accepted_ Products(Client_Id,ContactNumber,Product)
Values ('022222222',2,'Microsoft XP')
I need to loop through Product table replacing Product with next item.
Any help highly appreciated