Erick Answered 1 Years ago through
Quizzes
This is having to process a row by row function and no Parallelism can be done.
The between changes the where clause and the join had worse results on my test.
So that Parallelism can be used I suggest a temp table be used and then an update statemen...