SQL

Bug in SQL Server - Union Select Order is Important

So it turns out the select order is important when doing a union in SQL server if you have an outer select clause