to dump data into tables by parsing xml

<?xml version="1.0" encoding="UTF-8"?>
<Employees>
   <Employee>
      <EmployeeNumber>12345</EmployeeNumber>
      <EmployeeName>Bond</EmployeeName>
      <MondayTimeDetails>
         <TimeDetail>
            <WorkOrderNumber>123</WorkOrderNumber>
            <Date>Jul 28, 2014</Date>
            <RegularHours>9</RegularHours>
         </TimeDetail>
      </MondayTimeDetails>
      <TuesdayTimeDetails>
         <TimeDetail>
            <WorkOrderNumber>156</WorkOrderNumber>
            <Date>Jul 29, 2014</Date>
            <RegularHours>9</RegularHours>
         </TimeDetail>
         <TimeDetail>
            <WorkOrderNumber>145</WorkOrderNumber>
            <Date>Jul 29, 2014</Date>
            <RegularHours>2</RegularHours>
         </TimeDetail>
      </TuesdayTimeDetails>
      <WednesdayTimeDetails>
         <TimeDetail>
            <WorkOrderNumber>895</WorkOrderNumber>
            <Date>Jul 30, 2014</Date>
            <RegularHours>6</RegularHours>
         </TimeDetail>
         <TimeDetail>
            <WorkOrderNumber>145</WorkOrderNumber>
            <Date>Jul 30, 2014</Date>
            <RegularHours>7</RegularHours>
         </TimeDetail>
      </WednesdayTimeDetails>
      <ThursdayTimeDetails />
      <FridayTimeDetails />
      <SaturdayTimeDetails />
      <SundayTimeDetails />
      <CrewLeader>1</CrewLeader>
   </Employee>
   <Employee>
      <EmployeeNumber>798</EmployeeNumber>
      <EmployeeName>John</EmployeeName>
      <MondayTimeDetails>
         <TimeDetail>
            <WorkOrderNumber>123</WorkOrderNumber>
            <Date>Mar 24, 2014</Date>
            <RegularHours>9</RegularHours>
         </TimeDetail>`enter code here`
      </MondayTimeDetails>
      <TuesdayTimeDetails />
      <WednesdayTimeDetails />
      <ThursdayTimeDetails />
      <FridayTimeDetails />
      <SaturdayTimeDetails />
      <SundayTimeDetails />
   </Employee>
</Employees>

I want to split XML into following format for each employee

+--------------------------------------------------------------------------+ | Employeeid Name WorkOrderNumber Dayoftheweek Date HoursWorked | +--------------------------------------------------------------------------+ | 12345 Bond 895 Monday Jul 28, 2014 9 | | 12345 bond 156 Tuesday Jul 29, 2014 9 | | 12345 Bond 895 Wednessday Jul 30, 2014 0 | | 12345 bond 156 Thrusday Jul 31, 2014 0 | | 12345 Bond 895 Friday AUG 01, 2014 0 | | 12345 bond 156 Saturday AUG 02, 2014 0 | | 12345 bond 145 tuesday Jul 29,2014 2 | +--------------------------------------------------------------------------+

It tried using cross join but i am getting redundancy data which is not correct can any one help me is there any other way to split this data