Jack that's exactly what I'm trying to figure out if two smaller call backs vs. one large one will change performance much. Also when those calls are made does the...

I started adding the extra ''. But wasn't exactly sure how that worked after it tried to run it. I should have put more effort into it. I also noticed...

As always Lynn you are one awesome dude. Count me as a member of the LP fan club:-)

No to look at what you did and try to understand it. Thanks...

I thought that was going to work Lynn, darn it. I have some Case WHEN Col1.code IN ('A','B','C') that's throwing it off.

IF EXISTS (SELECT 1 FROM sys.objects WHERE...

Thanks everyone for the suggestions. I also appoligize about the limited information. Its hard to post the real code because of my company and because its so large.

I will say...

That's exactly what I'm getting is the Create View must be the only statement in the batch. I wrote a series of reports. That needs to span 3 different databases...

awesome tip Lynn. I'll make those changes

That might be possible there is a lot of bad stuff I have cleaned up. Such as NOLOCK on every JOIN, but I still have a lot left. its a...

I think I can get some more performance with tweaking and changing some of the underlining logic for the updates. I just didn't know if a Index would help since...

For the most part its being updated from the same 4 or 5 tables. On each Update. With different criteria on each one.

FROM #RESULTS r

INNER JOIN table1 t1...

Evil Kraig F (7/18/2014)

---

From a general perspective, and I know purists will disagree simply because of the memory grants (which will affect OTHER queries), no, it shouldn't cause you issues...

Evil Kraig F (7/18/2014)

---

thomashohner (7/18/2014)

---

This is for a report nothing else. They are just trying to create a result set with this temp table. There are a few UPDATEs to...

I should add all of the INSERT Information is under 50 characters max.

This is for a report nothing else. They are just trying to create a result set with this temp table. There are a few UPDATEs to the temp table that...

Solution: it was a corrupted file. The first one I used was a ZIP file that I downloaded then had to extract. I downloaded and used the Uncompressed version and...