D-Net

<?xml version="1.0" encoding="UTF-8"?>

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">

    <xsl:output method="text"/>

    <xsl:variable name="sq">'</xsl:variable>

    <xsl:template match="/">

        <xsl:for-each select="//Result/item">

            <xsl:variable name="year" select="./anno"/>

            <xsl:for-each select="./personale/item[string-length(./matricola) &gt; 0]">

                <xsl:variable name="pid" select="concat('matricola:',./matricola)"/>

                <xsl:for-each select="./labs/item">

                    <xsl:variable name="gid" select="./sigla"/>

                    <xsl:value-of select="concat('INSERT INTO affiliations_temp(pid,gid,year) VALUES (' ,$sq, $pid, $sq, ',', $sq, $gid, $sq, ',', $year, ');&#xa;')"/>

                </xsl:for-each>

            </xsl:for-each>

        </xsl:for-each>

    </xsl:template>

</xsl:stylesheet>