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 the temp table that follow after. I'm not sure if my boss is okay with me posting the whole thing or not. I'll have to check.
Just so you know, usually for optimization assistance we need a lot of stuff, like the execution plan, underlying table schemas and indexing, etc. It's very difficult to obfuscate that much stuff consistently after a certain point. Without it, we can give you generic answers and things to go look at, but it must be understood that everything said is an educated guess, nothing more. It's very easy for us to be wrong repeatedly and look like morons.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA