Oleg,

Here's what I have so far working in XSelerator utility using both MSXML 3 & 
4 transform engines.  The XML, XSL, and the result is below.  However, in my 
.NET Transform it bombs with "Object reference not set to an instance of an 
object" when I try to transform and load it into an XmlDocument.  Is there 
anything I can do?

XML:
----
<NewDataSet>
  <row>
    <CompanyId>676708</CompanyId>
    <CompanyName>Microsoft Corporation</CompanyName>
    <CountryCd>US</CountryCd>
    <CodeId>20</CodeId>
    <CodeName>AAAA</CodeName>
  </row>
  <row>
    <CompanyId>676708</CompanyId>
    <CompanyName>Microsoft Corporation</CompanyName>
    <CountryCd>US</CountryCd>
    <CodeId>21</CodeId>
    <CodeName>BBBB</CodeName>
  </row>
  <row>
    <CompanyId>676708</CompanyId>
    <CompanyName>Microsoft Corporation</CompanyName>
    <CountryCd>US</CountryCd>
    <CodeId>22</CodeId>
    <CodeName>CCCCCC</CodeName>
  </row>
  <row>
    <CompanyId>676708</CompanyId>
    <CompanyName>Microsoft Corporation</CompanyName>
    <CountryCd>US</CountryCd>
    <CodeId>23</CodeId>
    <CodeName>DDDDD</CodeName>
  </row>
</NewDataSet

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

<!-- Define keys used to group elements -->
<xsl:key name="keyCompanyId" match="row" use="CompanyId" />

<xsl:template match="NewDataSet">
<companycodelist>
    <xsl:for-each select="//row[generate-id(.) = 
generate-id(key('keyCompanyId', CompanyId)[1])]">
     <xsl:variable name="lngCompanyId"><xsl:value-of select="CompanyId" 
/></xsl:variable>
     <xsl:variable name="lstRow" select="//row[CompanyId=$lngCompanyId]" />
     <xsl:call-template name="ShowCompanyCodes">
     <xsl:with-param name="lstRow" select="$lstRow" />
     </xsl:call-template>
    </xsl:for-each>
</companycodelist>
</xsl:template>

<xsl:template name="ShowCompanyCodes">
 <xsl:param name="lstRow" />

  <company>
  	 <companyname><xsl:value-of select="$lstRow[1]/CompanyName" 
/></companyname>
	 <codes>
		<xsl:for-each select="$lstRow">
			<xsl:element name="code">
					<xsl:attribute name="id"><xsl:value-of select="CodeId"/></xsl:attribute>
					<xsl:attribute name="name"><xsl:value-of 
select="CodeName"/></xsl:attribute>
			    	<xsl:value-of select="CodeValue" />
			</xsl:element>
		  </xsl:for-each>
	 </codes>
 </company>
</xsl:template>

</xsl:stylesheet>


Result:
-------
<?xml version="1.0" encoding="UTF-16"?>
<companycodelist>
<company>
<companyname>Microsoft Corporation</companyname>
<codes>
	<code id="20" name="AAAA"></code>
	<code id="21" name="BBBB"></code>
	<code id="22" name="CCCCCC"></code>
	<code id="23" name="DDDDD"></code>
</codes>
</company>
</companycodelist>








"Oleg Tkachenko [MVP]" wrote:

> Dave wrote:
> 
> > <?xml version="1.0" ?>
> > <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" 
> > version="2.0">
> 
> You seems to be using XSLT 2.0? Beware neither MSXML nor .NET support 
> XSLT 2.0.
> 
> > <xsl:template match="NewDataSet" mode="grp_company">
> > 	<NewDataSet>
> >      <xsl:for-each select="row[generate-id() = 
> > generate-id(key('company_key', CompanyName)[1])]">
> 
> Well, where is a definition for the company_key ?
> Can you provide more complete XSLT stylesheet?
> -- 
> Oleg Tkachenko [XML MVP]
> http://blog.tkachenko.com
>