You must watch out for many subtle and not-so-subtle traps when translating Oracle queries to SQL Server. Just as T-SQL ... expression with the SELECT command. Because DUAL has only one row ...