So I'm returning to this thread talk:
https://www.vbforums.com/showthread....ry-reun-faster



Query runs relatively ok locally 5-10 minutes but when put on a job it takes about 50 minutes. Initially it was maxing out at 35 minutes but probably due to large data entries it went to 50 that is aaalmost the breaking point.
From what I can see, set noncount is on , haven't touched any parallelism MAXDOP etc.
The query is run as a part of a longer list of queries in one go, so I was thinking if I use it outside of the list, individually would make any difference? Or if I temp the tblDWConcession table but I would be temping a lot of GB of data.
Or any other thoughts?

Edit , just saw tblDWConcession is 42GB stand alone.