Migration of query from Oracle to SQL Server 2008

Question

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(+);

Can anybody tell me the meaning of (+)? I have to migrate this query from Oracle to SQL Server 2008

LEFT OUTER JOIN it is in SQL Server

knkarthick24
– knkarthick24

2014-11-13 09:56:12 +00:00
Commented Nov 13, 2014 at 9:56 — knkarthick24
– knkarthick24, Commented Nov 13, 2014 at 9:56

knkarthick24 · Accepted Answer · 2014-11-13 09:57:50Z

1

SQL Server Equivalent is LEFT OUTER JOIN:

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
         left outer 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;

answered Nov 13, 2014 at 9:57

knkarthick24

3,24619 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ppascualv · Accepted Answer · 2014-11-13 09:56:55Z

0

It's a notation for LEFT OUTER JOIN

answered Nov 13, 2014 at 9:56

ppascualv

1,1378 silver badges21 bronze badges

Collectives™ on Stack Overflow

Migration of query from Oracle to SQL Server 2008

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related