You can calc the min value, like :
MIN(points) OVER (Order by points) 

modify the default window like:
LAST_VALUE(points) OVER(ORDER BY points DESC ROWS BETWEEN CURRENT ROW AND UNBOUNDED...

Nice question.
Just a tip, remember to use union all instead of union when there is no need to remove duplicates.

Tricky question cause SQL Server 2005 is only supported in Windows Server 2008 or below, and SQL Server 2017 is only supported in WS 2012 and higher... ;p

Happy dragons!. Nice article.

WITH myBeers (<see CTE in the question> )
,nto as (
SELECT OwedTo as pp, sum(beer) as beers FROM myBeers
group by owedto),
nby as (SELECT Owedby as pp, sum(beer)...

Love this puzzles.
Thx! 🙂

Nice question, but the correct answer is wrong. It should be the 4th one as said by the explanation, right?

A fun and different way to SELECT DISTINCT.

WITH DistinctCTE

AS (

SELECT [Column] = MIN(t.[Column])

...

Its hard to get the directory where a dtsx is running from a Script Task because each Script Task is as one dll.

This dll is compiled and executed from some...

Its hard to get the directory where a dtsx is running from a Script Task because each Script Task is as one dll.

This dll is compiled and executed from some...

Its hard to get the directory where a dtsx is running from a Script Task because each Script Task is as one dll.

This dll is compiled and executed from some...