Welcome to SSC.

Have a look at Jeff's Article on how to post performance problems. There's little we can do to help you with next to no...

When you want to return data from another table, but retain rows if there are no matching results in the joining table, you would use a LEFT JOIN. You would...

Without knowing what runs in EXECUTE dbo.sto_GetErrorInfo, then we have no idea what happens inside your CATCH.

Will there be any data above the rows, or will they simply be blank? If they are truly empty (no data has ever been put in them, and not formatting...

Forgot to mention, the DelimitedSplit8K function can be found here: http://www.sqlservercentral.com/articles/Tally+Table/72993/

(For some reason, editing my above post means i can't use SSC for about 2-3 minutes and...

Normally, at least for a UK address, you split it into 5 parts. Address lines 1-4 and the postcode.  If you have anymore, then you'll need to combine some of...

Excel isn't a great tool for doing stuff like this, in all honesty. it's great for collecting data from SQL server, but I don't suggest using it the other way.

There isn't a lot to go on here, but yes, you can join to a Temporary table as part of a query. Of course, it needs to exist first, and...