Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select and Update from CTE
Message
De
30/06/2015 16:14:20
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Versions des environnements
SQL Server:
SQL Server 2012
Application:
Web
Divers
Thread ID:
01621599
Message ID:
01621631
Vues:
25
>You said yesterday you found cases where you have more than 1. Obviously if it's only 1, then it will work.

Yes, that is correct. What I did is that I simply cut and pasted the script into sequence. I have about 10. The first one takes 20 minutes, than 10 seconds, than 5 seconds, than 2 seconds, etc. So, in about 30 minutes, the job is done. I did not have time to test the other group approach as this would have required me too much time in regards to the available time left to run the script on production.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform