Daily Archives: 3/28/2007

MS SQL Union (Selects Distinct Values)

here’s a wake up call for devs who use SQL Unions infrequently. at work we recently tripped up on a bug with a stored proc… well it was actually just that we had forgotten that with UNION, only distinct values are selected! oops. so remember: The UNION ALL command is equal to the UNION command, [...]