Unfortunately using the alias in the order by clause does not work in all flavors of SQL and I have trouble rememberig which it does work with. Agreed, it...

I use numbers in my order by statements every day for short queries. It is faster than typing out long names and is especially nice when the column is...

I've learned to read the discussions about all the questions because I learn things there as well. Did not know about adding a number to GO to get multiple...

The calculation of the column

ISNULL(S.RandomNumber, 0) - ISNULL(D.RandomNumber, 0) AS RandomNumberDiff

requires some attention. It is important to choose a numeric value that is far from your threshold number...

This did not run on my 2005 system and there was no qualification about version

It took me a little while to realize the trigger has a condition that count(*) = 1. Since its count = 2, it works. Interesting question.

The trigger has a condition of if count(*) = 1 so statement 5 works because its count=2

I am using SQL Server 2005 and changed the column to varchar(100) and changed the limit to 20 in the trigger. Statement 4 (id=2) raised an error and failed....

The code in the email does not have GO in it but the code in the Web page does so it is not clear what is being tested here. ...