LOL.  (Not random, alphabetical)  🙂

I agree, but I personally don't like multi character aliases.  For me, they clutter the code and make it less readable.  I like to name them a,b,c,d... and that makes...

The same as yours, just with a function, because that was what he was using.

Not quite. Something much simpler:

My Test Code:

SELECT 'RCX_M01_SMD 1.0.6 ' AS AppVersion INTO #Temp

INSERT INTO #Temp SELECT 'RCX_D00_BackOffice 7.2.1.0'

INSERT INTO #Temp SELECT 'RCX_I04_OLAP 2.0.0.0 [2.0.0.5]'

INSERT INTO #Temp SELECT 'RCX_X02_MOB 10.6.2.3'

SELECT...

This looks like an overkill to me. It is another help to people to understand STRING_SPLIT, but in your scenario I would use INSTR to get the positions of the...

"I’m more than a little tubby"  You hide it well. 🙂

But I would like say: If you want to lose weight, 1st eat less, 2nd exercise.

Ok, let's say you have a system with 10 roles for security access. You could put the role number in X and a 1 or 0 in Y to represent...

Using the Employee table as an example: What if you need to have an unique index on the social security number to prevent duplicates.  Would that not mute everything?  (As...

Hmmm, that would still not make sense. Why would you want your own name displayed during debugging?  Don't know your own name? 🙂

Does it make sense to put USER_NAME() in the script?  I think no and that is why 31% picked the second answer. 🙂

I understand Owen's intent, but the BIG lesson here is that you should think twice when running an update statement without a where clause. 🙂

I agree.

Should the first COUNT not be a SUM?