Hi, I have run the following query in a query node in over 500 process ins

Is there anything else you're doing in this SQL? If it's a straight-forward Insert statement, it should work irrespective of the no of rows the Select statement returns. So, technically, your sub-select statement can return >1 records and it will be inserted. I think the issue lies in the fact that you are probably using a "=" somewhere that forces the SQL to accept only one record instead of using "IN". I would check that first. Is there a 'Where' clause you have to this SQL? I am assuming you must otherwise running 500 instances of the same sql would only result in duplicates.

In short, if you'r tempAbsentClientUpload can accept multiple records from the temporaryAbsClientTable, check the SQL. On the other hand, if the SQL was designed to only allow one record, then check the data. It's quite likely that you have some duplicate data in your child table.

Is there anything else you're doing in this SQL? If it's a straight-forward Insert statement, it should work irrespective of the no of rows the Select statement returns. So, technically, your sub-select statement can return >1 records and it will be inserted. I think the issue lies in the fact that you are probably using a "=" somewhere that forces the SQL to accept only one record instead of using "IN". I would check that first. Is there a 'Where' clause you have to this SQL? I am assuming you must otherwise running 500 instances of the same sql would only result in duplicates.

In short, if you'r tempAbsentClientUpload can accept multiple records from the temporaryAbsClientTable, check the SQL. On the other hand, if the SQL was designed to only allow one record, then check the data. It's quite likely that you have some duplicate data in your child table.