Reuse a complex non-deterministic expression in SELECT and WHERE clauses
This can't help with the determinism issue, but CROSS APPLY is a good tool for big expressions that need to be reused:

SELECT TOP 10 team_name, CxA.Score_Points
FROM teams t
CROSS APPLY (SELECT Score_Points = &lt;big Expression, refer to t&gt;) CxA
 WHERE CxA.Score_Points &gt;= 100
 ORDER BY CxA.Score_Points DESC


CROSS APPLY expressions get calculated for every row and can be referred to in any part of the query.