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

Convert DB2 query to SQL Server [closed]

Discussão em 'Outras Linguagens' iniciado por Stack, Julho 2, 2021.

  1. Stack

    Stack Membro Participativo

    How would you convert this HTML (from DB2) to SQL Server?

    LEFT JOIN
    (select wadoco
    , replace(
    replace(
    replace(
    replace(
    xmlserialize(XMLAGG(XMLELEMENT(
    NAME "x",
    CASE WHEN trim(wammcu) = '750000' THEN
    substr(wlmcu, 3, 7)
    ELSE
    trim(wldsc1)
    END
    ) order by wlopsq) as varchar(1000))
    , '</x><x>', ' || ')
    , '<x>', ' || ')
    , '</x>', ' || ')
    , '&amp;', '&') as rem_ops

    Continue reading...

Compartilhe esta Página