Dear all,
I am having problem to deal with group by in update_recordset, and also I am not able to use aggregates in update_recordset. I need some alternative suggestion or solution to achieve functionality like update_recordset.
while select forUpdate takes more time in execution rather than update_recordset
Hi,
Aggregation directly is not possible in an update_recordset (although you can do it in insert_recordset). I would suggest to make a view with the required aggregates and grouping, that can be joind to the set-based operations later.
Kind Regards,
István
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
288,584
Super User
#2
Martin Dráb
225,864
Super User
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (