But how do you know if your code is right or wrong when the examples to learn from don't scale or are not complete? Most articles I find on writing...

AH nevermind. It looks like it is just the Logical Name that has PROD in it. The actual filename has TEST. That is very confusing when you first look at...

I would turn it into a column and order by it. Cleaner this way.

SELECT

(CASE WHEN AddDt > UpdateDt

THEN AddDt

ELSE ISNULL(UpdateDt, AddDt)

END) AS MaxDt,

Id, Name, OnHand, AddDt,...

13.0.2000.00

I ran this and got the below error.

Never had a reason personally to create types, but...