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))
  ...

Your SELECT includes 5 items, yet your Result section includes only one (per instance). Can you change your result to match the query (or vice versa)?

Also, are you aware that...

Can you please clarify exactly what you want by providing an example showing

a) Original text and

b) Desired text?