Thanks, Evgeny!
About questions:
1) Now I use projection tables and getting result set via SQL Query after that fill it in source table. I think it's a best solution in current moment.
2) I use source table as a result set of some SQL query and before of this update table is not suitable for me because need to check which row was deleted, changed or added. Now I just delete all rows from source table and after that call SQL query for getting result and insert it in table. What do you think about this approach?
- Log in to post comments