I need to populate multiple columns from a table

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.

Ron_Mc September 17, 2019 19:42

Comments

1 comment

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!

Martin_K September 19, 2019 00:12

0

Add comment

Please sign in to leave a comment.

How can we help you today?

I need to populate multiple columns from a table

Comments

Add comment