Thanks Kevin - Why did you write "select count(*)" instead of "select ticketnumber" in your query?

ok - I removed the "left" join and I am currently rerunning the query

Do you have any rows in #tmpIndividualCreateDates where CreateDate is NULL?

The declaration of that temp table allows for NULL in that column and you fill it from an external file....

the stored proc hangs in section 4 of the attached proc

What's the best implementation for doing this in chunks? Can you please provide an example?

Also, why would I would I want to do this in 10k-50k chunks as opposed...

yes - the code folding in that screenshot appears to do more harm than good.

However, you mentioned a plugin could be written to use regions in a way that's more...

SSCrazy - Any reason why you wouldn't query sys.objects on object name instead of object id? Seems like a simpler approach?

I originally queried sys.objects for the info but I...

Thanks Gail!

When you say "Maybe", in what scenarios "Yes" and in what scenarios "No"?

How is region handling awful in SSMS 2012?

Is it quirky and inconsistent or does it have a poor overall design?

I downloaded SSMS Tools Pack and the region functionality seems to be a bit quirky. For example, for 2 regions on top of each other, collapsing the top region...

thanks lowell - very helpful!

TenC - Thanks for that tip. What you're describing seems logical.

Yes - the temp tables I'm using in my SQL are in the format #MyTempTable. So hopefully SS...

I see objects in the table with a create date going back several years. When you create a temp table does SS store this table indefinitely?

Also, I seem to...

What I'm suggesting is that table #a would have 2 rows with the same company. For example:

'Microsoft', 'Seattle'

'Microsoft', 'Portland'

In this scenario, row #1 would get updated but row #2...

I think for the purpose of this example it should be sufficient to assume that each table has 2 columns - DomainName and OfficeName, with the column names between the...