1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

  2. Anuncie Aqui ! Entre em contato fdantas@4each.com.br

Outer apply to select a single record

Discussão em 'StackOverflow' iniciado por fdantas, Junho 11, 2017.

  1. fdantas

    fdantas Administrator Moderador

    I'm trying to use OpenEdge sql connector to connect pull an employee's title. The employee can have multiple titles and I want to prevent multiple rows showing up on the main query. In MSSQL I'd use an outer apply to do this, but I'm having difficulties using an outer apply in Progress/Openedge.

    The part of the query in question is here:

    OUTER APPLY (
    SELECT TOP 1 * FROM "PUB"."ASSIGNMENT"
    WHERE "PUB"."ASSIGNMENT"."ID" = "NAME"."ID"
    ) title


    This gives me a syntax error at "OUTER APPLY (select top 1......"

    Anyone know how this is done with the SQL connection to ProgessDB?

    Continue reading...

Compartilhe esta Página