Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select and Update from CTE
Message
From
30/06/2015 16:14:20
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Environment versions
SQL Server:
SQL Server 2012
Application:
Web
Miscellaneous
Thread ID:
01621599
Message ID:
01621631
Views:
26
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform