t-sql select min from two values
snippet in sql

t-sql select min from two values

user2074

SELECT
PaidForPast=(SELECT MIN(x) FROM (VALUES (PaidThisMonth),(OwedPast)) AS value(x))