I have a table with 5 date columns, nulls NOT allowed.
Let's assume the table has 100 records.
I want to return a resultset that has 100 records, and for each record the
most recent date among the 5 on that record.
That is, I want to get the max of the 5 dates for each record, and the
Select WON'T have a Group By.
Obviously I could do a bunch of crazy nested CASEs, but is there a better
way/function to do this.
create table mytab (
pk int not null, --primary key
a datetime not null,