Hi martin,

this is my sample xml file.
<TABLE NAME="PS_JOBCODE_TBL">
<ROWS>
<ROW>
<COLUMN NAME="SETID"><![CDATA[COMMN]]></COLUMN>
<COLUMN NAME="JOBCODE"><![CDATA[P10]]></COLUMN>
<COLUMN NAME="EFFDT"><![CDATA[01-Jan-1996 00:00:00]]></COLUMN>
<COLUMN NAME="EFF_STATUS"><![CDATA[A]]></COLUMN>
<COLUMN NAME="DESCR"><![CDATA[yyyyyyyyyyyyyyy]]></COLUMN>
</ROW>
<ROW>
<COLUMN NAME="SETID"><![CDATA[COMMN]]></COLUMN>
<COLUMN NAME="JOBCODE"><![CDATA[B64]]></COLUMN>
<COLUMN NAME="EFFDT"><![CDATA[01-Jan-1900 00:00:00]]></COLUMN>
<COLUMN NAME="EFF_STATUS"><![CDATA[A]]></COLUMN>
<COLUMN NAME="DESCR"><![CDATA[CONSTR SUPR]]></COLUMN>
</ROW>
<ROW>
<COLUMN NAME="SETID"><![CDATA[COMMN]]></COLUMN>
<COLUMN NAME="JOBCODE"><![CDATA[B64]]></COLUMN>
<COLUMN NAME="EFFDT"><![CDATA[01-Jun-1966 00:00:00]]></COLUMN>
<COLUMN NAME="EFF_STATUS"><![CDATA[A]]></COLUMN>
<COLUMN NAME="DESCR"><![CDATA[CONSTR SUPR]]></COLUMN>
</ROW>
<ROW>
<COLUMN NAME="SETID"><![CDATA[COMMN]]></COLUMN>
<COLUMN NAME="JOBCODE"><![CDATA[P10]]></COLUMN>
<COLUMN NAME="EFFDT"><![CDATA[16-Jul-1991 00:00:00]]></COLUMN>
<COLUMN NAME="EFF_STATUS"><![CDATA[A]]></COLUMN>
<COLUMN NAME="DESCR"><![CDATA[CABLE SPLICERS]]></COLUMN>
</ROW>
<ROW>
<COLUMN NAME="SETID"><![CDATA[COMMN]]></COLUMN>
<COLUMN NAME="JOBCODE"><![CDATA[P10]]></COLUMN>
<COLUMN NAME="EFFDT"><![CDATA[16-Jul-1994 00:00:00]]></COLUMN>
<COLUMN NAME="EFF_STATUS"><![CDATA[A]]></COLUMN>
<COLUMN NAME="DESCR"><![CDATA[XXXXXXXXXXX]]></COLUMN>
</ROW>
</ROWS>
</TABLE>

I need to find out the DESCR. based on JobCode

*Input :  *Jobcode like P10
*Process: *find out the all the nodes with  Jobcode  *P10*  and find the 
latest Effective date (EFFDT) and display corresponding DESCR
*output: *DESCR with latest Effective date.

Please suggest me on best of way of doing this.

Thanks,
Anil






--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe@l...>
--~--