title: Migration of query from Oracle to SQL Server 2008
body: <pre><code>select 
      eue.PERSONID,
      eue.EID,
      eue.NAME_COMPLETE,  eue.
      eue.EMAIL_ADDRESS_OFFICE as EMAIL 
  from  
      HAIL_ESS_USERS_EXTENDED_V eue
  where 
      eue.PERSONID = p_person_id) eue
  join 
     (select *
      from HAIL_ESS_ROLE_MAP
      where ROLE_ID in (select ID
                        from HAIL_ESS_ROLES
                        where upper(ROLE_NAME) like upper('Rewards and Recognition%'))) b on   eue.PERSONID = b.PERSON_ID(+); 
  </code></pre>
  
  <p>Can anybody tell me the meaning of <code>(+)</code>? I have to migrate this query from Oracle to SQL Server
  2008</p>