Thanks for good article!

Haven't seen "_(dt_year)" before?

How is the underscore here working?

SELECT dt, dt_year

FROM (VALUES (GetDate())) cur(dt)

CROSS APPLY (SELECT YEAR(cur.dt)) _(dt_year)

Like to have a book! 😀

SELECT FirstName,LastName,

ROW_NUMBER() over (order by FirstName) as 'Row per FirstName',

RANK()...

Like to have a book! 😀

SELECT FirstName,LastName,

ROW_NUMBER() over (order by FirstName) as 'Row per FirstName',

RANK()...