Community

Some ANY Aggregate Transformations are Broken

(Paul White) The ANY aggregate is not something we can write directly in Transact SQL. It is an internal only feature used by the query optimizer and execution engine.