Anyone know the best way to write a median aggregate function in ms sql server 2k? I've seen a couple ways of doing it when I briefly searched google but they weren't presented as functions.

Snowflake wants to reduce enterprises’ reliance on data engineers and data scientists for unstructured data analysis with its new SQL functions powered by generative AI.