Read from one table, do Calculations based on the read columns and insert the calculated columns in another table

Question

We are using Azure SQL Database, recently we have added a new table (B) to our database. The requirement here is:

a. Read the values from table A, read row by row with individual row at a time.

b. Do calculations based on the record read from table A, form an insert statement with the calculated values and insert these calculated value as a single row in table B.

Both table A and table B have 8 millions records individually.

Can anyone suggest the best way of doing this in Azure without impacting the db performance or anything else?

Answer 1

Hi
Raul, Sushil •,

Welcome to Microsoft Q&A forum and thanks for using Azure Services.

As I understand, you have scenario to Read from one table, do Calculations based on the read columns and insert the calculated columns in another table.

For this usecase, please share more information about the data in the form of sample input and expected output data, the type of calculation needed to be performed etc so that we can better assist you.

As per the existing understanding, we can suggest you to create Stored Procedure and perform the calculations.

Alternatively, you can use Azure Data Factory/Azure Synapse Analytics pipelines to achieve this scenario.

Thank you.

Answer 2

read row by row with individual row at a time.

Normally one creates set-based solutions and do not loop through records.

Please post table design as DDL, some sample data as DML statement and the expected result.