UPDATE_RECORDSET TOP X


UPDATE_RECORDSET can become expensive in case of large data sets. In SQL we commonly resolve this by executing the update in smaller batches: WHILE ( @@ROWCOUNT ) BEGIN UPDATE TOP (...) SET ... WHERE ... END We would also like to be able to do this from X++. This would need a TOP clause to ...

Read more...
0 Comments

Read more...
0 Comments

Category: Development (172)

STATUS DETAILS
New