Hi!
Can anybody help translating this Oracle SQL to something that runs on Microsoft SQL-server?
Best regards, Brian
The code:
UPDATE individ c SET (c.z_linie2, c.z_linie3, c.z_linie4) = (SELECT SUBSTR( v.z_vejnavn || ' ' || DECODE(c.husnr, NULL, DECODE(c.bnr, NULL, '', 'B-' || LTRIM(c.bnr,'0')), LTRIM(SUBSTR(c.husnr,1,3),'0') || DECODE(SUBSTR(c.husnr,4), NULL, '', ' ' || SUBSTR(c.husnr,4))) || DECODE(LTRIM(c.z_etage,' '), NULL, '', ',' || LTRIM(c.z_etage,'0')) || DECODE(LTRIM(c.z_sidedoer,' '), NULL, '', 'mf', ' mf', 'th', ' th', 'tv', ' tv', ',-' || LTRIM(c.z_sidedoer,' 0')), 1,34), v.z_bygde, v.postnr || ' ' || p.z_postdr FROM postnr p, vej v WHERE (c.vejkod = v.vejkod ) AND (c.komkod = v.komkod ) AND (v.postnr = p.postnr (+))) where c.pnr in (select l.pnr FROM ladropl2010 l where l.lseq BETWEEN &fra AND &til ) AND c.komkod like '9%'