Hi Mohammed i know i can do that..
But the table structure is the problem i have for example the Program code
"PRG004" repeatable
for all the rows
that means i would have to first do a distinct for a program code then loop
through it and start adding other tags i need.
Would you have an idea how to do this?


"Mohammad Shalabi" <mshalabi@m...> wrote in message
news:OUa38EjQGHA.3460@T......
> If you change the way you construct this xml, then this will be so easily
to
> do. You can change the xml to the bellow xml for example.
>
> <?xml version="1.0" standalone="yes"?>
> <?xml-stylesheet type="text/xsl" href="email.xsl"?>
>
> <NewDataSet>
>
> <ProgramDetail>
>
> <Item>
>
> <Code>PRG004</Code>
>
> <programDescription>Crazy Training 2</programDescription>
>
> <course>
>
> <CourseCode>MAT01</CourseCode>
>
> <DurationHours>8</DurationHours>
>
> <CourseDescription>Maths For Beginners</CourseDescription>
>
> <ModuleCode>TEST101</ModuleCode>
>
> <ModuleDescription>Test Module</ModuleDescription>
>
> </course>
>
> <course>
>
> <CourseCode>PHS101</CourseCode>
>
> <DurationHours>36</DurationHours>
>
> <CourseDescription>Physics</CourseDescription>
>
> <ModuleCode>TEST101</ModuleCode>
>
> <ModuleDescription>Test Module</ModuleDescription>
>
> <PreReqCourseCode>MAT234</PreReqCourseCode>
>
> </course>
>
> <course>
>
> <CourseCode>PHS101</CourseCode>
>
> <DurationHours>36</DurationHours>
>
> <CourseDescription>Physics</CourseDescription>
>
> <ModuleCode>TEST103</ModuleCode>
>
> <ModuleDescription>TESTMODULEWITHLONGNAME</ModuleDescription>
>
> <PreReqCourseCode>MAT234</PreReqCourseCode>
>
>
> </course>
>
> </Item>
>
> <Item>
>
> <Code>PRG005</Code>
>
> <programDescription>Program 6</programDescription>
>
> <course>
>
> <CourseCode>COURSE102</CourseCode>
>
> <DurationHours>5</DurationHours>
>
> <CourseDescription>Course for learning Courses</CourseDescription>
>
> <ModuleCode>MODULE101</ModuleCode>
>
> <ModuleDescription>Module 1</ModuleDescription>
>
> </course>
>
> <course>
>
> <CourseCode>MAT01</CourseCode>
>
> <DurationHours>8</DurationHours>
>
> <CourseDescription>Maths For Beginners</CourseDescription>
>
> <ModuleCode>TEST101</ModuleCode>
>
> <ModuleDescription>Test Module</ModuleDescription>
>
> </course>
>
> <course>
>
> <CourseCode>MAT234</CourseCode>
>
> <DurationHours>8</DurationHours>
>
> <CourseDescription>Maths</CourseDescription>
>
> <ModuleCode>TEST101</ModuleCode>
>
> <ModuleDescription>Test Module</ModuleDescription>
>
> <PreReqCourseCode>MAT01</PreReqCourseCode>
>
> </course>
>
> </Item>
>
> </ProgramDetail>
>
> </NewDataSet>
>
>
>
> "Patrick.O.Ige" <naijacoder@h...> wrote in message
> news:%23U%23mYn5NGHA.720@T......
> >I have an sample xml below.
> > I want to do a distinct on the code node and the programDescription.
> > I want the output to be like in a tree structure.
> > So i would like to  have
> > PRG004 >Crazy Training 2> MAT01
> >                                             PHS101
> > Any ideas it musn't be in a tree but it could be in a table structure
> > Thanks
> >
> > <?xml version="1.0" standalone="yes"?>
> > <?xml-stylesheet type="text/xsl" href="email.xsl"?>
> > <NewDataSet>
> >   <ProgramDetail>
> >      <Code>PRG004</Code>
> >
> >      <programDescription>Crazy Training 2</programDescription>
> >
> >      <CourseCode>MAT01</CourseCode>
> >
> >      <DurationHours>8</DurationHours>
> >
> >      <CourseDescription>Maths For Beginners</CourseDescription>
> >
> >      <ModuleCode>TEST101</ModuleCode>
> >
> >      <ModuleDescription>Test Module</ModuleDescription>
> >   </ProgramDetail>
> >
> >   <ProgramDetail>
> >      <Code>PRG004</Code>
> >
> >      <programDescription>Crazy Training 2</programDescription>
> >
> >      <CourseCode>PHS101</CourseCode>
> >
> >      <DurationHours>36</DurationHours>
> >
> >      <CourseDescription>Physics</CourseDescription>
> >
> >      <ModuleCode>TEST101</ModuleCode>
> >
> >      <ModuleDescription>Test Module</ModuleDescription>
> >
> >      <PreReqCourseCode>MAT234</PreReqCourseCode>
> >   </ProgramDetail>
> >
> >   <ProgramDetail>
> >      <Code>PRG004</Code>
> >
> >      <programDescription>Crazy Training 2</programDescription>
> >
> >      <CourseCode>PHS101</CourseCode>
> >
> >      <DurationHours>36</DurationHours>
> >
> >      <CourseDescription>Physics</CourseDescription>
> >
> >      <ModuleCode>TEST103</ModuleCode>
> >
> >      <ModuleDescription>TESTMODULEWITHLONGNAME</ModuleDescription>
> >
> >      <PreReqCourseCode>MAT234</PreReqCourseCode>
> >   </ProgramDetail>
> >
> >   <ProgramDetail>
> >      <Code>PRG005</Code>
> >
> >      <programDescription>Program 6</programDescription>
> >
> >      <CourseCode>COURSE102</CourseCode>
> >
> >      <DurationHours>5</DurationHours>
> >
> >      <CourseDescription>Course for learning Courses</CourseDescription>
> >
> >      <ModuleCode>MODULE101</ModuleCode>
> >
> >      <ModuleDescription>Module 1</ModuleDescription>
> >   </ProgramDetail>
> >
> >   <ProgramDetail>
> >      <Code>PRG005</Code>
> >
> >      <programDescription>Program 6</programDescription>
> >
> >      <CourseCode>MAT01</CourseCode>
> >
> >      <DurationHours>8</DurationHours>
> >
> >      <CourseDescription>Maths For Beginners</CourseDescription>
> >
> >      <ModuleCode>TEST101</ModuleCode>
> >
> >      <ModuleDescription>Test Module</ModuleDescription>
> >   </ProgramDetail>
> >
> >   <ProgramDetail>
> >      <Code>PRG005</Code>
> >
> >      <programDescription>Program 6</programDescription>
> >
> >      <CourseCode>MAT234</CourseCode>
> >
> >      <DurationHours>8</DurationHours>
> >
> >      <CourseDescription>Maths</CourseDescription>
> >
> >      <ModuleCode>TEST101</ModuleCode>
> >
> >      <ModuleDescription>Test Module</ModuleDescription>
> >
> >      <PreReqCourseCode>MAT01</PreReqCourseCode>
> >   </ProgramDetail>
> >
> >   <ProgramDetail>
> >      <Code>PRG005</Code>
> >
> >      <programDescription>Program 6</programDescription>
> >
> >      <CourseCode>MAT234</CourseCode>
> >
> >      <DurationHours>8</DurationHours>
> >
> >      <CourseDescription>Maths</CourseDescription>
> >
> >      <ModuleCode>TEST101</ModuleCode>
> >
> >      <ModuleDescription>Test Module</ModuleDescription>
> >
> >      <PreReqCourseCode>MAT101</PreReqCourseCode>
> >   </ProgramDetail>
> >
> >   <ProgramDetail>
> >      <Code>PRG005</Code>
> >
> >      <programDescription>Program 6</programDescription>
> >
> >      <CourseCode>MAT234</CourseCode>
> >
> >      <DurationHours>8</DurationHours>
> >
> >      <CourseDescription>Maths</CourseDescription>
> >
> >      <ModuleCode>TEST101</ModuleCode>
> >
> >      <ModuleDescription>Test Module</ModuleDescription>
> >
> >      <PreReqCourseCode>PHS101</PreReqCourseCode>
> >   </ProgramDetail>
> >
> >   <ProgramDetail>
> >      <Code>PRG005</Code>
> >
> >      <programDescription>Program 6</programDescription>
> >
> >      <CourseCode>MAT234</CourseCode>
> >
> >      <DurationHours>8</DurationHours>
> >
> >      <CourseDescription>Maths</CourseDescription>
> >
> >      <ModuleCode>TEST102</ModuleCode>
> >
> >      <ModuleDescription>TestModule2</ModuleDescription>
> >
> >      <PreReqCourseCode>MAT01</PreReqCourseCode>
> >   </ProgramDetail>
> >
> >   <ProgramDetail>
> >      <Code>PRG005</Code>
> >
> >      <programDescription>Program 6</programDescription>
> >
> >      <CourseCode>MAT234</CourseCode>
> >
> >      <DurationHours>8</DurationHours>
> >
> >      <CourseDescription>Maths</CourseDescription>
> >
> >      <ModuleCode>TEST102</ModuleCode>
> >
> >      <ModuleDescription>TestModule2</ModuleDescription>
> >
> >      <PreReqCourseCode>MAT101</PreReqCourseCode>
> >   </ProgramDetail>
> >
> >   <ProgramDetail>
> >      <Code>PRG005</Code>
> >
> >      <programDescription>Program 6</programDescription>
> >
> >      <CourseCode>MAT234</CourseCode>
> >
> >      <DurationHours>8</DurationHours>
> >
> >      <CourseDescription>Maths</CourseDescription>
> >
> >      <ModuleCode>TEST102</ModuleCode>
> >
> >      <ModuleDescription>TestModule2</ModuleDescription>
> >
> >      <PreReqCourseCode>PHS101</PreReqCourseCode>
> >   </ProgramDetail>
> > </NewDataSet>
> >
> >
> >
> >
>
>