Which 'following table' and which 'connection string details'? Why are you avoiding providing more information? Also, where is the DDL for the temp table you want to...

I have the following table ...

Where is this 'following table'?

If you are just selecting from table1 all the time, why not select all of the rows you need in one...

IIRC, there is also a difference in the dates in Excel and SQL Server.  Only problem is that I don't quite remember what the problem, had I haven't had...

I missed debugging in SSMS for a short while although I didn't miss the number of times debugging would crash SSMS. I think I'm actually happier with my current...

Wait ... monotonically INSERTing using a WHILE loop? Brave of you to post that here!

For those that aren't aware, debugging T-SQL from VS is possible, as per this ridiculous example I've just thrown together.

As you can see, you can...

I am able to get some of the values for all of the database in my instances with a script I have, but not all of the ones I...

Excel is doing its best to be helpful, though this 'help' is often a hindrance to advanced users.

Turning off auto-formatting could, perhaps, be enabled as a spreadsheet-specific option, but that...

Here's one way.

SELECT CalcTextName = CASE
                     ...

What is your thinking behind using

SELECT FROM (SELECT ... )

rather than a single SELECT?

You're dead right that there's a communication issue. I cannot relate the questions you are asking to whatever query you have, which 'works'.

Please identify exactly those parts of this working...

Throw bubbles up, but only if you choose to do so ... you have control

BEGIN TRY
    BEGIN TRY
      ...

I agree with you: in this specific instance, it does meet the goal, though I would never do it that way (I'd use the method suggested by Pietlinden in the...

If the solutions provided do not match up with your requirement, please consider providing some sample data, along with desired results, based on that sample data.

When providing the sample data,...

Not an error as such, but any leading zeros in the VARCHAR(5) column could cause issues.

DECLARE @x VARCHAR(5) = '01234';

IF @x = CAST(01234 AS VARCHAR(5))
  ...