Loop Through Reader, Select Data, Insert into table.
I'm working on a Console Application that is pulling data from other systems and databases. I would like to
1. have the datareader loop through a table and select the distinct employee ID
2. as each employee ID is read, I will pass the ID as a parameter and read and retrieve data from another table.
3. populate the third table with the new data.
I would appreciate any help you could provide to help me get this project done sooner.
Thanks in advance.