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.