Well. It didn't worth it, for sure.

And now, my application for an Itzik Ben-Gan book! 🙂

CREATE TABLE #CopyrightedContent (id int IDENTITY(1,1), Author varchar(255), ArticleURL varchar(255), PublicationDate date)

INSERT INTO #CopyrightedContent(Author, ArticleURL, PublicationDate) VALUES

('Itzik Ben-Gan', 'http://tsql.solidq.com/books/windowfunctions2012/', '2012-04-10'),

('Itzik Ben-Gan', 'http://tsql.solidq.com/books/tsqlfund2008/', '2008-10-22'),

('Itzik Ben-Gan', 'http://tsql.solidq.com/books/source_code/SQL%20Server%20MVP%20Deep%20Dives%20-%20Chapter%2005.txt', '2009-11-01')

INSERT INTO #CopyrightedContent(Author, ArticleURL, PublicationDate)

-- HERE COMES THE LOGIC:

SELECT 'Me' AS Author, LastWork, CURRENT_TIMESTAMP FROM (

SELECT ArticleURL AS LastWork, PublicationDate, ROW_NUMBER() OVER(PARTITION BY Author ORDER BY PublicationDate DESC) AS RecentRank FROM #CopyrightedContent

) A WHERE RecentRank = 1

SELECT * FROM #CopyrightedContent

DROP TABLE #CopyrightedContent