Example 12-23: Transforming master/detail info for insert

<!-- deptemp.xsl -->
<ROWSET xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xsl:version="1.0">
  <xsl:for-each select="DepartmentList/Department">
   <ROW>
     <DEPTNO><xsl:value-of select="Id"/></DEPTNO>
     <DNAME><xsl:value-of select="Name"/></DNAME>
     <EMPLOYEES>
       <xsl:for-each select="Employees/Employee">
         <EMPLOYEES_ITEM>
           <EMPNO><xsl:value-of select="Id"/></EMPNO>
           <ENAME><xsl:value-of select="Name"/></ENAME>
           <SAL><xsl:value-of select="Salary"/></SAL>
         </EMPLOYEES_ITEM>
       </xsl:for-each> <!-- Employees -->
     </EMPLOYEES>
   </ROW>
  </xsl:for-each> <!-- Departments -->
</ROWSET>