Redirecting to
https://blog.greglow.com/2025/02/18/t-sql-101-117-creating-scalar-subqueries-in-sql-server-t-sql/