SQL: update SUBSCRIPTIONTABLE set ACTIVEFLAG='Y' where mobile_num in (select mobile_num from LOADED_MOBILE_NUMBERS)
Could you try using UPDATE ... FROM (SELECT ....) AS .. style syntax?
About 20 minutes ago, I changed a 8 minute update to an most instant by doing that.
regards
Iain
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
