I need to populate multiple columns from a table

Ron_Mc

Creating insurance claim data in a MS SQL table (Claims_Data). The insured ID, along with the FN,LN and DOB have to come from values in a separate table in the same database (Insured_List). New to this tool, cannot figure out how.

Martin_K

Hi Ron, You can use the SQL Statement generator to get rows from another table (in that database or any others). Here's some documentation on it:

https://documentation.red-gate.com/sdg4/using-generators/generic-generators#Genericgenerators-SQLStatementgenerator

Hope that helps!