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 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.
I know Kraig, sorry about the limited info. I do know better. I just didn't know if this was more of a general don't do this type thing. I would love to provide more info which I know you guys need, however I'm new at my job and don't know how they would feel about posting the whole code vs snips.
PS. None of you guys ever look like morons! Just new guys like me
***SQL born on date Spring 2013:-)