none
Help XML - SQL : Cross apply, outer apply, ... RRS feed

  • Question

  • Bonjour a tous,

    J'ai un gros fichier XML, et je souhaiterai récupérer ces données dans une table SQL Server. Le soucis, c'est qu'il décale les résultat dans la table vers le bas a cause des nœuds XML. Je met ci-dessous les images pour que vous compreniez. Je pense être prêt du but notamment avec les OUTER APPLY. J'ai vraiment besoin d'aide, e ne suis que novice en XML et c'est une de mes missions de stage.

    Merci d'avance.

    Code SQL : 

    DECLARE @XML XML 
    SET @XML = '<?xml version="1.0" encoding="SHIFT_JIS" standalone="yes"?>
    <ROOT>
    <Faildata>
    	<Header>
    		<Judge>FAIL</Judge>
    		<D.Total Pass="0" Fail="1">1</D.Total>
    		<Total Pass="85" Fail="92">177</Total>
    		<M.Name>B003382AA-BOTTOM-FLAN.SWX</M.Name>
    		<DateOfTest>2017-06-06</DateOfTest>
    		<TimeOfTest>04:40:37+02:00</TimeOfTest>
    		<TestTime>00:00:53</TestTime>
    		<M.Version>2.0-9g</M.Version>
    		<TesterID>9411_1</TesterID>
    		<M.Index>P=B003382AA X=24B</M.Index>
    		<Message>.\n.-------------------------B003382AA\n.\n.- BOTTOM\n.- Connecteur vers le bas</Message>
    	</Header>
    	<ABSide AB="A">
    		<Group G.No="1">
    		</Group>
    		<Group G.No="2">
    		</Group>
    		<Group G.No="3">
    		</Group>
    		<Group G.No="4">
    		</Group>
    		<Group G.No="5">
    		</Group>
    		<Group G.No="6">
    		</Group>
    		<Group G.No="7">
    		</Group>
    		<Group G.No="8">
    		</Group>
    		<Group G.No="9">
    		</Group>
    		<Group G.No="10">
    		</Group>
    		<Group G.No="11">
    		</Group>
    		<Group G.No="12">
    		</Group>
    		<Group G.No="13">
    		</Group>
    		<Group G.No="14">
    		</Group>
    		<Group G.No="15">
    		</Group>
    		<Group G.No="16">
    		</Group>
    		<Group G.No="17">
    		</Group>
    		<Group G.No="18">
    		</Group>
    		<Group G.No="19">
    		</Group>
    		<Group G.No="20">
    			<Step AB="A" G.No="20" No="499">
    				<Aux>Non</Aux>
    				<Parts>D4</Parts>
    				<Value>*</Value>
    				<Comment>HH00003SA</Comment>
    				<Loc>*</Loc>
    				<Func>**</Func>
    				<P.Tol Unit="%">30</P.Tol>
    				<M.Tol Unit="%">30</M.Tol>
    				<Judge>OPEN</Judge>
    				<M.Mode>DC-CC</M.Mode>
    				<M.Range>4</M.Range>
    				<M.Time Unit="ms">1.0</M.Time>
    				<Ref.EL>D</Ref.EL>
    				<Ref.Val Unit="V">0.666</Ref.Val>
    				<Ref.Fig Unit="V">0.666</Ref.Fig>
    				<Test.EL No="1">D</Test.EL>
    				<Test.Val No="1" Unit="V">2.652</Test.Val>
    				<Test.Fig No="1" Unit="V">2.652</Test.Fig>
    				<Test.EL No="2">D</Test.EL>
    				<Test.Val No="2" Unit="V">2.652</Test.Val>
    				<Test.Fig No="2" Unit="V">2.652</Test.Fig>
    				<AccessProbe>( +. N. N. -)</AccessProbe>
    				<Pin Pol.="+" NET="$554">310</Pin>
    				<Pin Pol.="-" NET="$553">318</Pin>
    				<Pin Pol.="G1" NET="*">0</Pin>
    				<Pin Pol.="G2" NET="*">0</Pin>
    				<Contact No="1" XYUnit="mm">163.1425 129.6138</Contact>
    				<Contact No="4" XYUnit="mm">174.2325 140.4000</Contact>
    				<D.Status>---</D.Status>
    				<T.Info>
    					<D.Pass>0</D.Pass>
    					<D.Fail>1</D.Fail>
    					<T.Pass>85</T.Pass>
    					<T.Fail>92</T.Fail>
    					<M.Name>C:\TAKAYA\board\Carte B003382AA\B003382AA-BOTTOM-FLAN.SWX</M.Name>
    					<DateOfTest>2017-06-06</DateOfTest>
    					<TimeOfTest>04:40:37+02:00</TimeOfTest>
    					<TestTime>00:00:53</TestTime>
    					<TesterID>9411_1</TesterID>
    					<M.Index>P=B003382AA X=24B</M.Index>
    				</T.Info>
    			</Step>
    		</Group>
    		<Group G.No="21">
    		</Group>
    		<Group G.No="22">
    		</Group>
    		<Group G.No="23">
    		</Group>
    		<Group G.No="24">
    			<Step AB="A" G.No="24" No="603">
    				<Aux>Non</Aux>
    				<Parts>D4</Parts>
    				<Value>*</Value>
    				<Comment>HH00003SA</Comment>
    				<Loc>*</Loc>
    				<Func>**</Func>
    				<P.Tol Unit="%">30</P.Tol>
    				<M.Tol Unit="%">30</M.Tol>
    				<Judge>OPEN</Judge>
    				<M.Mode>DC-CC</M.Mode>
    				<M.Range>4</M.Range>
    				<M.Time Unit="ms">1.0</M.Time>
    				<Ref.EL>D</Ref.EL>
    				<Ref.Val Unit="V">0.666</Ref.Val>
    				<Ref.Fig Unit="V">0.666</Ref.Fig>
    				<Test.EL No="1">D</Test.EL>
    				<Test.Val No="1" Unit="V">2.652</Test.Val>
    				<Test.Fig No="1" Unit="V">2.652</Test.Fig>
    				<Test.EL No="2">D</Test.EL>
    				<Test.Val No="2" Unit="V">2.653</Test.Val>
    				<Test.Fig No="2" Unit="V">2.653</Test.Fig>
    				<AccessProbe>( +. N. N. -)</AccessProbe>
    				<Pin Pol.="+" NET="$554">374</Pin>
    				<Pin Pol.="-" NET="$553">382</Pin>
    				<Pin Pol.="G1" NET="*">0</Pin>
    				<Pin Pol.="G2" NET="*">0</Pin>
    				<Contact No="1" XYUnit="mm">201.6638 -4.7075</Contact>
    				<Contact No="4" XYUnit="mm">212.7538 6.0788</Contact>
    				<D.Status>---</D.Status>
    				<T.Info>
    					<D.Pass>0</D.Pass>
    					<D.Fail>1</D.Fail>
    					<T.Pass>85</T.Pass>
    					<T.Fail>92</T.Fail>
    					<M.Name>C:\TAKAYA\board\Carte B003382AA\B003382AA-BOTTOM-FLAN.SWX</M.Name>
    					<DateOfTest>2017-06-06</DateOfTest>
    					<TimeOfTest>04:40:37+02:00</TimeOfTest>
    					<TestTime>00:00:53</TestTime>
    					<TesterID>9411_1</TesterID>
    					<M.Index>P=B003382AA X=24B</M.Index>
    				</T.Info>
    			</Step>
    			<Step AB="A" G.No="24" No="607">
    				<Aux>Non</Aux>
    				<Parts>D2</Parts>
    				<Value>*</Value>
    				<Comment>HH00003SA</Comment>
    				<Loc>*</Loc>
    				<Func>**</Func>
    				<P.Tol Unit="%">30</P.Tol>
    				<M.Tol Unit="%">30</M.Tol>
    				<Judge>OPEN</Judge>
    				<M.Mode>DC-CC</M.Mode>
    				<M.Range>4</M.Range>
    				<M.Time Unit="ms">1.0</M.Time>
    				<Ref.EL>D</Ref.EL>
    				<Ref.Val Unit="V">0.700</Ref.Val>
    				<Ref.Fig Unit="V">0.7</Ref.Fig>
    				<Test.EL No="1">D</Test.EL>
    				<Test.Val No="1" Unit="V">2.652</Test.Val>
    				<Test.Fig No="1" Unit="V">2.652</Test.Fig>
    				<Test.EL No="2">D</Test.EL>
    				<Test.Val No="2" Unit="V">2.652</Test.Val>
    				<Test.Fig No="2" Unit="V">2.652</Test.Fig>
    				<AccessProbe>( N. N. +. -)</AccessProbe>
    				<Pin Pol.="+" NET="$633">375</Pin>
    				<Pin Pol.="-" NET="$554">374</Pin>
    				<Pin Pol.="G1" NET="*">0</Pin>
    				<Pin Pol.="G2" NET="*">0</Pin>
    				<Contact No="3" XYUnit="mm">199.0175 -0.9438</Contact>
    				<Contact No="4" XYUnit="mm">201.6638 -4.7075</Contact>
    				<D.Status>---</D.Status>
    				<T.Info>
    					<D.Pass>0</D.Pass>
    					<D.Fail>1</D.Fail>
    					<T.Pass>85</T.Pass>
    					<T.Fail>92</T.Fail>
    					<M.Name>C:\TAKAYA\board\Carte B003382AA\B003382AA-BOTTOM-FLAN.SWX</M.Name>
    					<DateOfTest>2017-06-06</DateOfTest>
    					<TimeOfTest>04:40:37+02:00</TimeOfTest>
    					<TestTime>00:00:53</TestTime>
    					<TesterID>9411_1</TesterID>
    					<M.Index>P=B003382AA X=24B</M.Index>
    				</T.Info>
    			</Step>
    		</Group>
    	</ABSide>
    </Faildata>
    
    <Faildata>
    	<Header>
    		<Judge>PASS</Judge>
    		<D.Total Pass="1" Fail="1">2</D.Total>
    		<Total Pass="86" Fail="92">178</Total>
    		<M.Name>B003382AA-BOTTOM-FLAN.SWX</M.Name>
    		<DateOfTest>2017-06-06</DateOfTest>
    		<TimeOfTest>04:42:26+02:00</TimeOfTest>
    		<TestTime>00:00:49</TestTime>
    		<M.Version>2.0-9g</M.Version>
    		<TesterID>9411_1</TesterID>
    		<M.Index>P=B003382AA X=24B</M.Index>
    		<Message>.\n.-------------------------B003382AA\n.\n.- BOTTOM\n.- Connecteur vers le bas</Message>
    	</Header>
    	<ABSide AB="A">
    		<Group G.No="1">
    		</Group>
    		<Group G.No="2">
    		</Group>
    		<Group G.No="3">
    		</Group>
    		<Group G.No="4">
    		</Group>
    		<Group G.No="5">
    		</Group>
    		<Group G.No="6">
    		</Group>
    		<Group G.No="7">
    		</Group>
    		<Group G.No="8">
    		</Group>
    		<Group G.No="9">
    		</Group>
    		<Group G.No="10">
    		</Group>
    		<Group G.No="11">
    		</Group>
    		<Group G.No="12">
    		</Group>
    		<Group G.No="13">
    		</Group>
    		<Group G.No="14">
    		</Group>
    		<Group G.No="15">
    		</Group>
    		<Group G.No="16">
    		</Group>
    		<Group G.No="17">
    		</Group>
    		<Group G.No="18">
    		</Group>
    		<Group G.No="19">
    		</Group>
    		<Group G.No="20">
    		</Group>
    		<Group G.No="21">
    		</Group>
    		<Group G.No="22">
    		</Group>
    		<Group G.No="23">
    		</Group>
    		<Group G.No="24">
    		</Group>
    	</ABSide>
    </Faildata>
    
    <Faildata>
    	<Header>
    		<Judge>PASS</Judge>
    		<D.Total Pass="2" Fail="1">3</D.Total>
    		<Total Pass="87" Fail="92">179</Total>
    		<M.Name>B003382AA-BOTTOM-FLAN.SWX</M.Name>
    		<DateOfTest>2017-06-06</DateOfTest>
    		<TimeOfTest>04:46:22+02:00</TimeOfTest>
    		<TestTime>00:00:49</TestTime>
    		<M.Version>2.0-9g</M.Version>
    		<TesterID>9411_1</TesterID>
    		<M.Index>P=B003382AA X=24B</M.Index>
    		<Message>.\n.-------------------------B003382AA\n.\n.- BOTTOM\n.- Connecteur vers le bas</Message>
    	</Header>
    	<ABSide AB="A">
    		<Group G.No="1">
    		</Group>
    		<Group G.No="2">
    		</Group>
    		<Group G.No="3">
    		</Group>
    		<Group G.No="4">
    		</Group>
    		<Group G.No="5">
    		</Group>
    		<Group G.No="6">
    		</Group>
    		<Group G.No="7">
    		</Group>
    		<Group G.No="8">
    		</Group>
    		<Group G.No="9">
    		</Group>
    		<Group G.No="10">
    		</Group>
    		<Group G.No="11">
    		</Group>
    		<Group G.No="12">
    		</Group>
    		<Group G.No="13">
    		</Group>
    		<Group G.No="14">
    		</Group>
    		<Group G.No="15">
    		</Group>
    		<Group G.No="16">
    		</Group>
    		<Group G.No="17">
    		</Group>
    		<Group G.No="18">
    		</Group>
    		<Group G.No="19">
    		</Group>
    		<Group G.No="20">
    		</Group>
    		<Group G.No="21">
    		</Group>
    		<Group G.No="22">
    		</Group>
    		<Group G.No="23">
    		</Group>
    		<Group G.No="24">
    		</Group>
    	</ABSide>
    </Faildata>
    
    <Faildata>
    	<Header>
    		<Judge>FAIL</Judge>
    		<D.Total Pass="2" Fail="2">4</D.Total>
    		<Total Pass="87" Fail="93">180</Total>
    		<M.Name>B003382AA-BOTTOM-FLAN.SWX</M.Name>
    		<DateOfTest>2017-06-06</DateOfTest>
    		<TimeOfTest>04:49:07+02:00</TimeOfTest>
    		<TestTime>00:00:50</TestTime>
    		<M.Version>2.0-9g</M.Version>
    		<TesterID>9411_1</TesterID>
    		<M.Index>P=B003382AA X=24B</M.Index>
    		<Message>.\n.-------------------------B003382AA\n.\n.- BOTTOM\n.- Connecteur vers le bas</Message>
    	</Header>
    	<ABSide AB="A">
    		<Group G.No="1">
    		</Group>
    		<Group G.No="2">
    		</Group>
    		<Group G.No="3">
    		</Group>
    		<Group G.No="4">
    			<Step AB="A" G.No="4" No="83">
    				<Aux>Non</Aux>
    				<Parts>D4</Parts>
    				<Value>*</Value>
    				<Comment>HH00003SA</Comment>
    				<Loc>*</Loc>
    				<Func>**</Func>
    				<P.Tol Unit="%">30</P.Tol>
    				<M.Tol Unit="%">30</M.Tol>
    				<Judge>OPEN</Judge>
    				<M.Mode>DC-CC</M.Mode>
    				<M.Range>4</M.Range>
    				<M.Time Unit="ms">1.0</M.Time>
    				<Ref.EL>D</Ref.EL>
    				<Ref.Val Unit="V">0.666</Ref.Val>
    				<Ref.Fig Unit="V">0.666</Ref.Fig>
    				<Test.EL No="1">D</Test.EL>
    				<Test.Val No="1" Unit="V">2.652</Test.Val>
    				<Test.Fig No="1" Unit="V">2.652</Test.Fig>
    				<Test.EL No="2">D</Test.EL>
    				<Test.Val No="2" Unit="V">2.652</Test.Val>
    				<Test.Fig No="2" Unit="V">2.652</Test.Fig>
    				<AccessProbe>( +. N. N. -)</AccessProbe>
    				<Pin Pol.="+" NET="$554">54</Pin>
    				<Pin Pol.="-" NET="$553">62</Pin>
    				<Pin Pol.="G1" NET="*">0</Pin>
    				<Pin Pol.="G2" NET="*">0</Pin>
    				<Contact No="1" XYUnit="mm">9.0750 129.6163</Contact>
    				<Contact No="4" XYUnit="mm">20.1650 140.4025</Contact>
    				<D.Status>---</D.Status>
    				<T.Info>
    					<D.Pass>2</D.Pass>
    					<D.Fail>2</D.Fail>
    					<T.Pass>87</T.Pass>
    					<T.Fail>93</T.Fail>
    					<M.Name>C:\TAKAYA\board\Carte B003382AA\B003382AA-BOTTOM-FLAN.SWX</M.Name>
    					<DateOfTest>2017-06-06</DateOfTest>
    					<TimeOfTest>04:49:07+02:00</TimeOfTest>
    					<TestTime>00:00:50</TestTime>
    					<TesterID>9411_1</TesterID>
    					<M.Index>P=B003382AA X=24B</M.Index>
    				</T.Info>
    			</Step>
    		</Group>
    		<Group G.No="5">
    		</Group>
    		<Group G.No="6">
    		</Group>
    		<Group G.No="7">
    		</Group>
    		<Group G.No="8">
    		</Group>
    		<Group G.No="9">
    		</Group>
    		<Group G.No="10">
    		</Group>
    		<Group G.No="11">
    		</Group>
    		<Group G.No="12">
    		</Group>
    		<Group G.No="13">
    		</Group>
    		<Group G.No="14">
    		</Group>
    		<Group G.No="15">
    		</Group>
    		<Group G.No="16">
    		</Group>
    		<Group G.No="17">
    		</Group>
    		<Group G.No="18">
    		</Group>
    		<Group G.No="19">
    		</Group>
    		<Group G.No="20">
    		</Group>
    		<Group G.No="21">
    		</Group>
    		<Group G.No="22">
    		</Group>
    		<Group G.No="23">
    		</Group>
    		<Group G.No="24">
    		</Group>
    	</ABSide>
    </Faildata>
    
    <Faildata>
    	<Header>
    		<Judge>FAIL</Judge>
    		<Judge>GROUP JUMP</Judge>
    		<D.Total Pass="2" Fail="3">5</D.Total>
    		<Total Pass="87" Fail="94">181</Total>
    		<M.Name>B003382AA-BOTTOM-FLAN.SWX</M.Name>
    		<DateOfTest>2017-06-06</DateOfTest>
    		<TimeOfTest>04:54:22+02:00</TimeOfTest>
    		<TestTime>00:00:05</TestTime>
    		<M.Version>2.0-9g</M.Version>
    		<TesterID>9411_1</TesterID>
    		<M.Index>P=B003382AA X=24B</M.Index>
    		<Message>.\n.-------------------------B003382AA\n.\n.- BOTTOM\n.- Connecteur vers le bas</Message>
    	</Header>
    	<ABSide AB="A">
    		<Group G.No="20">
    			<Step AB="A" G.No="20" No="499">
    				<Aux>Non</Aux>
    				<Parts>D4</Parts>
    				<Value>*</Value>
    				<Comment>HH00003SA</Comment>
    				<Loc>*</Loc>
    				<Func>**</Func>
    				<P.Tol Unit="%">30</P.Tol>
    				<M.Tol Unit="%">30</M.Tol>
    				<Judge>OPEN</Judge>
    				<M.Mode>DC-CC</M.Mode>
    				<M.Range>4</M.Range>
    				<M.Time Unit="ms">1.0</M.Time>
    				<Ref.EL>D</Ref.EL>
    				<Ref.Val Unit="V">0.666</Ref.Val>
    				<Ref.Fig Unit="V">0.666</Ref.Fig>
    				<Test.EL No="1">D</Test.EL>
    				<Test.Val No="1" Unit="V">2.652</Test.Val>
    				<Test.Fig No="1" Unit="V">2.652</Test.Fig>
    				<Test.EL No="2">D</Test.EL>
    				<Test.Val No="2" Unit="V">2.652</Test.Val>
    				<Test.Fig No="2" Unit="V">2.652</Test.Fig>
    				<AccessProbe>( +. N. N. -)</AccessProbe>
    				<Pin Pol.="+" NET="$554">310</Pin>
    				<Pin Pol.="-" NET="$553">318</Pin>
    				<Pin Pol.="G1" NET="*">0</Pin>
    				<Pin Pol.="G2" NET="*">0</Pin>
    				<Contact No="1" XYUnit="mm">163.1425 129.6138</Contact>
    				<Contact No="4" XYUnit="mm">174.2325 140.4000</Contact>
    				<D.Status>---</D.Status>
    				<T.Info>
    					<D.Pass>2</D.Pass>
    					<D.Fail>3</D.Fail>
    					<T.Pass>87</T.Pass>
    					<T.Fail>94</T.Fail>
    					<M.Name>C:\TAKAYA\board\Carte B003382AA\B003382AA-BOTTOM-FLAN.SWX</M.Name>
    					<DateOfTest>2017-06-06</DateOfTest>
    					<TimeOfTest>04:54:22+02:00</TimeOfTest>
    					<TestTime>00:00:05</TestTime>
    					<TesterID>9411_1</TesterID>
    					<M.Index>P=B003382AA X=24B</M.Index>
    				</T.Info>
    			</Step>
    		</Group>
    		<Group G.No="24">
    		</Group>
    	</ABSide>
    </Faildata>
    
    <Faildata>
    	<Header>
    		<Judge>PASS</Judge>
    		<D.Total Pass="3" Fail="3">6</D.Total>
    		<Total Pass="88" Fail="94">182</Total>
    		<M.Name>B003382AA-BOTTOM-FLAN.SWX</M.Name>
    		<DateOfTest>2017-06-06</DateOfTest>
    		<TimeOfTest>04:55:29+02:00</TimeOfTest>
    		<TestTime>00:00:02</TestTime>
    		<M.Version>2.0-9g</M.Version>
    		<TesterID>9411_1</TesterID>
    		<M.Index>P=B003382AA X=24B</M.Index>
    		<Message>.\n.-------------------------B003382AA\n.\n.- BOTTOM\n.- Connecteur vers le bas</Message>
    	</Header>
    	<ABSide AB="A">
    		<Group G.No="4">
    		</Group>
    	</ABSide>
    </Faildata>
    
    <Faildata>
    	<Header>
    		<Judge>FAIL</Judge>
    		<Judge>GROUP JUMP</Judge>
    		<D.Total Pass="3" Fail="4">7</D.Total>
    		<Total Pass="88" Fail="95">183</Total>
    		<M.Name>B003382AA-BOTTOM-FLAN.SWX</M.Name>
    		<DateOfTest>2017-06-06</DateOfTest>
    		<TimeOfTest>04:55:54+02:00</TimeOfTest>
    		<TestTime>00:00:03</TestTime>
    		<M.Version>2.0-9g</M.Version>
    		<TesterID>9411_1</TesterID>
    		<M.Index>P=B003382AA X=24B</M.Index>
    		<Message>.\n.-------------------------B003382AA\n.\n.- BOTTOM\n.- Connecteur vers le bas</Message>
    	</Header>
    	<ABSide AB="A">
    		<Group G.No="20">
    			<Step AB="A" G.No="20" No="499">
    				<Aux>Non</Aux>
    				<Parts>D4</Parts>
    				<Value>*</Value>
    				<Comment>HH00003SA</Comment>
    				<Loc>*</Loc>
    				<Func>**</Func>
    				<P.Tol Unit="%">30</P.Tol>
    				<M.Tol Unit="%">30</M.Tol>
    				<Judge>OPEN</Judge>
    				<M.Mode>DC-CC</M.Mode>
    				<M.Range>4</M.Range>
    				<M.Time Unit="ms">1.0</M.Time>
    				<Ref.EL>D</Ref.EL>
    				<Ref.Val Unit="V">0.666</Ref.Val>
    				<Ref.Fig Unit="V">0.666</Ref.Fig>
    				<Test.EL No="1">D</Test.EL>
    				<Test.Val No="1" Unit="V">2.652</Test.Val>
    				<Test.Fig No="1" Unit="V">2.652</Test.Fig>
    				<Test.EL No="2">D</Test.EL>
    				<Test.Val No="2" Unit="V">2.651</Test.Val>
    				<Test.Fig No="2" Unit="V">2.651</Test.Fig>
    				<AccessProbe>( +. N. N. -)</AccessProbe>
    				<Pin Pol.="+" NET="$554">310</Pin>
    				<Pin Pol.="-" NET="$553">318</Pin>
    				<Pin Pol.="G1" NET="*">0</Pin>
    				<Pin Pol.="G2" NET="*">0</Pin>
    				<Contact No="1" XYUnit="mm">163.1425 129.6138</Contact>
    				<Contact No="4" XYUnit="mm">174.2325 140.4000</Contact>
    				<D.Status>---</D.Status>
    				<T.Info>
    					<D.Pass>3</D.Pass>
    					<D.Fail>4</D.Fail>
    					<T.Pass>88</T.Pass>
    					<T.Fail>95</T.Fail>
    					<M.Name>C:\TAKAYA\board\Carte B003382AA\B003382AA-BOTTOM-FLAN.SWX</M.Name>
    					<DateOfTest>2017-06-06</DateOfTest>
    					<TimeOfTest>04:55:54+02:00</TimeOfTest>
    					<TestTime>00:00:03</TestTime>
    					<TesterID>9411_1</TesterID>
    					<M.Index>P=B003382AA X=24B</M.Index>
    				</T.Info>
    			</Step>
    		</Group>
    	</ABSide>
    </Faildata>
    
    <Faildata>
    	<Header>
    		<Judge>PASS</Judge>
    		<D.Total Pass="4" Fail="4">8</D.Total>
    		<Total Pass="89" Fail="95">184</Total>
    		<M.Name>B003382AA-BOTTOM-FLAN.SWX</M.Name>
    		<DateOfTest>2017-06-06</DateOfTest>
    		<TimeOfTest>04:59:06+02:00</TimeOfTest>
    		<TestTime>00:00:01</TestTime>
    		<M.Version>2.0-9g</M.Version>
    		<TesterID>9411_1</TesterID>
    		<M.Index>P=B003382AA X=24B</M.Index>
    		<Message>.\n.-------------------------B003382AA\n.\n.- BOTTOM\n.- Connecteur vers le bas</Message>
    	</Header>
    	<ABSide AB="A">
    		<Group G.No="20">
    		</Group>
    	</ABSide>
    </Faildata>
    
    <Faildata>
    	<Header>
    		<Judge>PASS</Judge>
    		<D.Total Pass="5" Fail="4">9</D.Total>
    		<Total Pass="90" Fail="95">185</Total>
    		<M.Name>B003382AA-BOTTOM-FLAN.SWX</M.Name>
    		<DateOfTest>2017-06-06</DateOfTest>
    		<TimeOfTest>05:03:19+02:00</TimeOfTest>
    		<TestTime>00:00:02</TestTime>
    		<M.Version>2.0-9g</M.Version>
    		<TesterID>9411_1</TesterID>
    		<M.Index>P=B003382AA X=24B</M.Index>
    		<Message>.\n.-------------------------B003382AA\n.\n.- BOTTOM\n.- Connecteur vers le bas</Message>
    	</Header>
    	<ABSide AB="A">
    		<Group G.No="17">
    		</Group>
    	</ABSide>
    </Faildata>
    </ROOT>'
    
    SELECT
    	Tab2.Col1.value('Judge[1]', 'nvarchar(25)') as Judge,
        Tab2.Col1.value('D.Total[1]', 'float') as DTotal,
        Tab2.Col1.value('Total[1]', 'float') as Total,
        Tab2.Col1.value('M.Name[1]', 'nvarchar(25)') as MName,
    	Tab2.Col1.value ('DateOfTest[1]', 'datetime') as DateOfTest,
    	Tab2.Col1.value('TimeOfTest[1]', 'time') as TimeOfTest,
    	Tab2.Col1.value('TestTime[1]', 'time') as TestTime,
    	Tab2.Col1.value('M.Version[1]', 'nvarchar(25)') as MVersion,
    	Tab2.Col1.value('TesterID[1]', 'nvarchar(25)') TesterID,
    	Tab2.Col1.value('M.Index[1]', 'nvarchar(25)') as MIndex,
    	Tab2.Col1.value('Message[1]', 'nvarchar(255)') as Message
    	--Tab5.Col1.value('Aux[1]', 'nvarchar(25)') as Aux
    FROM
     @XML.nodes('/ROOT') AS XTbl(Events)
     outer apply XTbl.Events.nodes('FailData') as Tab1(Col1)
     outer apply Tab1.Col1.nodes('Header') as Tab2(Col1)
     --outer apply Tab1.Col1.nodes('/ABSide') as Tab3(Col1)
     --outer apply Tab3.Col1.nodes('/Group') as Tab4(Col1)
     --outer apply Tab4.Col1.nodes('/Step') as Tab5(Col1)
       
    

    Code XML : 

    <?xml version="1.0" encoding="SHIFT_JIS" standalone="yes"?>
    <ROOT>
    <Faildata>
    	<Header>
    		<Judge>FAIL</Judge>
    		<D.Total Pass="0" Fail="1">1</D.Total>
    		<Total Pass="85" Fail="92">177</Total>
    		<M.Name>B003382AA-BOTTOM-FLAN.SWX</M.Name>
    		<DateOfTest>2017-06-06</DateOfTest>
    		<TimeOfTest>04:40:37+02:00</TimeOfTest>
    		<TestTime>00:00:53</TestTime>
    		<M.Version>2.0-9g</M.Version>
    		<TesterID>9411_1</TesterID>
    		<M.Index>P=B003382AA X=24B</M.Index>
    		<Message>.\n.-------------------------B003382AA\n.\n.- BOTTOM\n.- Connecteur vers le bas</Message>
    	</Header>
    	<ABSide AB="A">
    		<Group G.No="1">
    		</Group>
    		<Group G.No="2">
    		</Group>
    		<Group G.No="3">
    		</Group>
    		<Group G.No="4">
    		</Group>
    		<Group G.No="5">
    		</Group>
    		<Group G.No="6">
    		</Group>
    		<Group G.No="7">
    		</Group>
    		<Group G.No="8">
    		</Group>
    		<Group G.No="9">
    		</Group>
    		<Group G.No="10">
    		</Group>
    		<Group G.No="11">
    		</Group>
    		<Group G.No="12">
    		</Group>
    		<Group G.No="13">
    		</Group>
    		<Group G.No="14">
    		</Group>
    		<Group G.No="15">
    		</Group>
    		<Group G.No="16">
    		</Group>
    		<Group G.No="17">
    		</Group>
    		<Group G.No="18">
    		</Group>
    		<Group G.No="19">
    		</Group>
    		<Group G.No="20">
    			<Step AB="A" G.No="20" No="499">
    				<Aux>Non</Aux>
    				<Parts>D4</Parts>
    				<Value>*</Value>
    				<Comment>HH00003SA</Comment>
    				<Loc>*</Loc>
    				<Func>**</Func>
    				<P.Tol Unit="%">30</P.Tol>
    				<M.Tol Unit="%">30</M.Tol>
    				<Judge>OPEN</Judge>
    				<M.Mode>DC-CC</M.Mode>
    				<M.Range>4</M.Range>
    				<M.Time Unit="ms">1.0</M.Time>
    				<Ref.EL>D</Ref.EL>
    				<Ref.Val Unit="V">0.666</Ref.Val>
    				<Ref.Fig Unit="V">0.666</Ref.Fig>
    				<Test.EL No="1">D</Test.EL>
    				<Test.Val No="1" Unit="V">2.652</Test.Val>
    				<Test.Fig No="1" Unit="V">2.652</Test.Fig>
    				<Test.EL No="2">D</Test.EL>
    				<Test.Val No="2" Unit="V">2.652</Test.Val>
    				<Test.Fig No="2" Unit="V">2.652</Test.Fig>
    				<AccessProbe>( +. N. N. -)</AccessProbe>
    				<Pin Pol.="+" NET="$554">310</Pin>
    				<Pin Pol.="-" NET="$553">318</Pin>
    				<Pin Pol.="G1" NET="*">0</Pin>
    				<Pin Pol.="G2" NET="*">0</Pin>
    				<Contact No="1" XYUnit="mm">163.1425 129.6138</Contact>
    				<Contact No="4" XYUnit="mm">174.2325 140.4000</Contact>
    				<D.Status>---</D.Status>
    				<T.Info>
    					<D.Pass>0</D.Pass>
    					<D.Fail>1</D.Fail>
    					<T.Pass>85</T.Pass>
    					<T.Fail>92</T.Fail>
    					<M.Name>C:\TAKAYA\board\Carte B003382AA\B003382AA-BOTTOM-FLAN.SWX</M.Name>
    					<DateOfTest>2017-06-06</DateOfTest>
    					<TimeOfTest>04:40:37+02:00</TimeOfTest>
    					<TestTime>00:00:53</TestTime>
    					<TesterID>9411_1</TesterID>
    					<M.Index>P=B003382AA X=24B</M.Index>
    				</T.Info>
    			</Step>
    		</Group>
    		<Group G.No="21">
    		</Group>
    		<Group G.No="22">
    		</Group>
    		<Group G.No="23">
    		</Group>
    		<Group G.No="24">
    			<Step AB="A" G.No="24" No="603">
    				<Aux>Non</Aux>
    				<Parts>D4</Parts>
    				<Value>*</Value>
    				<Comment>HH00003SA</Comment>
    				<Loc>*</Loc>
    				<Func>**</Func>
    				<P.Tol Unit="%">30</P.Tol>
    				<M.Tol Unit="%">30</M.Tol>
    				<Judge>OPEN</Judge>
    				<M.Mode>DC-CC</M.Mode>
    				<M.Range>4</M.Range>
    				<M.Time Unit="ms">1.0</M.Time>
    				<Ref.EL>D</Ref.EL>
    				<Ref.Val Unit="V">0.666</Ref.Val>
    				<Ref.Fig Unit="V">0.666</Ref.Fig>
    				<Test.EL No="1">D</Test.EL>
    				<Test.Val No="1" Unit="V">2.652</Test.Val>
    				<Test.Fig No="1" Unit="V">2.652</Test.Fig>
    				<Test.EL No="2">D</Test.EL>
    				<Test.Val No="2" Unit="V">2.653</Test.Val>
    				<Test.Fig No="2" Unit="V">2.653</Test.Fig>
    				<AccessProbe>( +. N. N. -)</AccessProbe>
    				<Pin Pol.="+" NET="$554">374</Pin>
    				<Pin Pol.="-" NET="$553">382</Pin>
    				<Pin Pol.="G1" NET="*">0</Pin>
    				<Pin Pol.="G2" NET="*">0</Pin>
    				<Contact No="1" XYUnit="mm">201.6638 -4.7075</Contact>
    				<Contact No="4" XYUnit="mm">212.7538 6.0788</Contact>
    				<D.Status>---</D.Status>
    				<T.Info>
    					<D.Pass>0</D.Pass>
    					<D.Fail>1</D.Fail>
    					<T.Pass>85</T.Pass>
    					<T.Fail>92</T.Fail>
    					<M.Name>C:\TAKAYA\board\Carte B003382AA\B003382AA-BOTTOM-FLAN.SWX</M.Name>
    					<DateOfTest>2017-06-06</DateOfTest>
    					<TimeOfTest>04:40:37+02:00</TimeOfTest>
    					<TestTime>00:00:53</TestTime>
    					<TesterID>9411_1</TesterID>
    					<M.Index>P=B003382AA X=24B</M.Index>
    				</T.Info>
    			</Step>
    			<Step AB="A" G.No="24" No="607">
    				<Aux>Non</Aux>
    				<Parts>D2</Parts>
    				<Value>*</Value>
    				<Comment>HH00003SA</Comment>
    				<Loc>*</Loc>
    				<Func>**</Func>
    				<P.Tol Unit="%">30</P.Tol>
    				<M.Tol Unit="%">30</M.Tol>
    				<Judge>OPEN</Judge>
    				<M.Mode>DC-CC</M.Mode>
    				<M.Range>4</M.Range>
    				<M.Time Unit="ms">1.0</M.Time>
    				<Ref.EL>D</Ref.EL>
    				<Ref.Val Unit="V">0.700</Ref.Val>
    				<Ref.Fig Unit="V">0.7</Ref.Fig>
    				<Test.EL No="1">D</Test.EL>
    				<Test.Val No="1" Unit="V">2.652</Test.Val>
    				<Test.Fig No="1" Unit="V">2.652</Test.Fig>
    				<Test.EL No="2">D</Test.EL>
    				<Test.Val No="2" Unit="V">2.652</Test.Val>
    				<Test.Fig No="2" Unit="V">2.652</Test.Fig>
    				<AccessProbe>( N. N. +. -)</AccessProbe>
    				<Pin Pol.="+" NET="$633">375</Pin>
    				<Pin Pol.="-" NET="$554">374</Pin>
    				<Pin Pol.="G1" NET="*">0</Pin>
    				<Pin Pol.="G2" NET="*">0</Pin>
    				<Contact No="3" XYUnit="mm">199.0175 -0.9438</Contact>
    				<Contact No="4" XYUnit="mm">201.6638 -4.7075</Contact>
    				<D.Status>---</D.Status>
    				<T.Info>
    					<D.Pass>0</D.Pass>
    					<D.Fail>1</D.Fail>
    					<T.Pass>85</T.Pass>
    					<T.Fail>92</T.Fail>
    					<M.Name>C:\TAKAYA\board\Carte B003382AA\B003382AA-BOTTOM-FLAN.SWX</M.Name>
    					<DateOfTest>2017-06-06</DateOfTest>
    					<TimeOfTest>04:40:37+02:00</TimeOfTest>
    					<TestTime>00:00:53</TestTime>
    					<TesterID>9411_1</TesterID>
    					<M.Index>P=B003382AA X=24B</M.Index>
    				</T.Info>
    			</Step>
    		</Group>
    	</ABSide>
    </Faildata>
    
    <Faildata>
    	<Header>
    		<Judge>PASS</Judge>
    		<D.Total Pass="1" Fail="1">2</D.Total>
    		<Total Pass="86" Fail="92">178</Total>
    		<M.Name>B003382AA-BOTTOM-FLAN.SWX</M.Name>
    		<DateOfTest>2017-06-06</DateOfTest>
    		<TimeOfTest>04:42:26+02:00</TimeOfTest>
    		<TestTime>00:00:49</TestTime>
    		<M.Version>2.0-9g</M.Version>
    		<TesterID>9411_1</TesterID>
    		<M.Index>P=B003382AA X=24B</M.Index>
    		<Message>.\n.-------------------------B003382AA\n.\n.- BOTTOM\n.- Connecteur vers le bas</Message>
    	</Header>
    	<ABSide AB="A">
    		<Group G.No="1">
    		</Group>
    		<Group G.No="2">
    		</Group>
    		<Group G.No="3">
    		</Group>
    		<Group G.No="4">
    		</Group>
    		<Group G.No="5">
    		</Group>
    		<Group G.No="6">
    		</Group>
    		<Group G.No="7">
    		</Group>
    		<Group G.No="8">
    		</Group>
    		<Group G.No="9">
    		</Group>
    		<Group G.No="10">
    		</Group>
    		<Group G.No="11">
    		</Group>
    		<Group G.No="12">
    		</Group>
    		<Group G.No="13">
    		</Group>
    		<Group G.No="14">
    		</Group>
    		<Group G.No="15">
    		</Group>
    		<Group G.No="16">
    		</Group>
    		<Group G.No="17">
    		</Group>
    		<Group G.No="18">
    		</Group>
    		<Group G.No="19">
    		</Group>
    		<Group G.No="20">
    		</Group>
    		<Group G.No="21">
    		</Group>
    		<Group G.No="22">
    		</Group>
    		<Group G.No="23">
    		</Group>
    		<Group G.No="24">
    		</Group>
    	</ABSide>
    </Faildata>
    
    <Faildata>
    	<Header>
    		<Judge>PASS</Judge>
    		<D.Total Pass="2" Fail="1">3</D.Total>
    		<Total Pass="87" Fail="92">179</Total>
    		<M.Name>B003382AA-BOTTOM-FLAN.SWX</M.Name>
    		<DateOfTest>2017-06-06</DateOfTest>
    		<TimeOfTest>04:46:22+02:00</TimeOfTest>
    		<TestTime>00:00:49</TestTime>
    		<M.Version>2.0-9g</M.Version>
    		<TesterID>9411_1</TesterID>
    		<M.Index>P=B003382AA X=24B</M.Index>
    		<Message>.\n.-------------------------B003382AA\n.\n.- BOTTOM\n.- Connecteur vers le bas</Message>
    	</Header>
    	<ABSide AB="A">
    		<Group G.No="1">
    		</Group>
    		<Group G.No="2">
    		</Group>
    		<Group G.No="3">
    		</Group>
    		<Group G.No="4">
    		</Group>
    		<Group G.No="5">
    		</Group>
    		<Group G.No="6">
    		</Group>
    		<Group G.No="7">
    		</Group>
    		<Group G.No="8">
    		</Group>
    		<Group G.No="9">
    		</Group>
    		<Group G.No="10">
    		</Group>
    		<Group G.No="11">
    		</Group>
    		<Group G.No="12">
    		</Group>
    		<Group G.No="13">
    		</Group>
    		<Group G.No="14">
    		</Group>
    		<Group G.No="15">
    		</Group>
    		<Group G.No="16">
    		</Group>
    		<Group G.No="17">
    		</Group>
    		<Group G.No="18">
    		</Group>
    		<Group G.No="19">
    		</Group>
    		<Group G.No="20">
    		</Group>
    		<Group G.No="21">
    		</Group>
    		<Group G.No="22">
    		</Group>
    		<Group G.No="23">
    		</Group>
    		<Group G.No="24">
    		</Group>
    	</ABSide>
    </Faildata>
    
    <Faildata>
    	<Header>
    		<Judge>FAIL</Judge>
    		<D.Total Pass="2" Fail="2">4</D.Total>
    		<Total Pass="87" Fail="93">180</Total>
    		<M.Name>B003382AA-BOTTOM-FLAN.SWX</M.Name>
    		<DateOfTest>2017-06-06</DateOfTest>
    		<TimeOfTest>04:49:07+02:00</TimeOfTest>
    		<TestTime>00:00:50</TestTime>
    		<M.Version>2.0-9g</M.Version>
    		<TesterID>9411_1</TesterID>
    		<M.Index>P=B003382AA X=24B</M.Index>
    		<Message>.\n.-------------------------B003382AA\n.\n.- BOTTOM\n.- Connecteur vers le bas</Message>
    	</Header>
    	<ABSide AB="A">
    		<Group G.No="1">
    		</Group>
    		<Group G.No="2">
    		</Group>
    		<Group G.No="3">
    		</Group>
    		<Group G.No="4">
    			<Step AB="A" G.No="4" No="83">
    				<Aux>Non</Aux>
    				<Parts>D4</Parts>
    				<Value>*</Value>
    				<Comment>HH00003SA</Comment>
    				<Loc>*</Loc>
    				<Func>**</Func>
    				<P.Tol Unit="%">30</P.Tol>
    				<M.Tol Unit="%">30</M.Tol>
    				<Judge>OPEN</Judge>
    				<M.Mode>DC-CC</M.Mode>
    				<M.Range>4</M.Range>
    				<M.Time Unit="ms">1.0</M.Time>
    				<Ref.EL>D</Ref.EL>
    				<Ref.Val Unit="V">0.666</Ref.Val>
    				<Ref.Fig Unit="V">0.666</Ref.Fig>
    				<Test.EL No="1">D</Test.EL>
    				<Test.Val No="1" Unit="V">2.652</Test.Val>
    				<Test.Fig No="1" Unit="V">2.652</Test.Fig>
    				<Test.EL No="2">D</Test.EL>
    				<Test.Val No="2" Unit="V">2.652</Test.Val>
    				<Test.Fig No="2" Unit="V">2.652</Test.Fig>
    				<AccessProbe>( +. N. N. -)</AccessProbe>
    				<Pin Pol.="+" NET="$554">54</Pin>
    				<Pin Pol.="-" NET="$553">62</Pin>
    				<Pin Pol.="G1" NET="*">0</Pin>
    				<Pin Pol.="G2" NET="*">0</Pin>
    				<Contact No="1" XYUnit="mm">9.0750 129.6163</Contact>
    				<Contact No="4" XYUnit="mm">20.1650 140.4025</Contact>
    				<D.Status>---</D.Status>
    				<T.Info>
    					<D.Pass>2</D.Pass>
    					<D.Fail>2</D.Fail>
    					<T.Pass>87</T.Pass>
    					<T.Fail>93</T.Fail>
    					<M.Name>C:\TAKAYA\board\Carte B003382AA\B003382AA-BOTTOM-FLAN.SWX</M.Name>
    					<DateOfTest>2017-06-06</DateOfTest>
    					<TimeOfTest>04:49:07+02:00</TimeOfTest>
    					<TestTime>00:00:50</TestTime>
    					<TesterID>9411_1</TesterID>
    					<M.Index>P=B003382AA X=24B</M.Index>
    				</T.Info>
    			</Step>
    		</Group>
    		<Group G.No="5">
    		</Group>
    		<Group G.No="6">
    		</Group>
    		<Group G.No="7">
    		</Group>
    		<Group G.No="8">
    		</Group>
    		<Group G.No="9">
    		</Group>
    		<Group G.No="10">
    		</Group>
    		<Group G.No="11">
    		</Group>
    		<Group G.No="12">
    		</Group>
    		<Group G.No="13">
    		</Group>
    		<Group G.No="14">
    		</Group>
    		<Group G.No="15">
    		</Group>
    		<Group G.No="16">
    		</Group>
    		<Group G.No="17">
    		</Group>
    		<Group G.No="18">
    		</Group>
    		<Group G.No="19">
    		</Group>
    		<Group G.No="20">
    		</Group>
    		<Group G.No="21">
    		</Group>
    		<Group G.No="22">
    		</Group>
    		<Group G.No="23">
    		</Group>
    		<Group G.No="24">
    		</Group>
    	</ABSide>
    </Faildata>
    
    <Faildata>
    	<Header>
    		<Judge>FAIL</Judge>
    		<Judge>GROUP JUMP</Judge>
    		<D.Total Pass="2" Fail="3">5</D.Total>
    		<Total Pass="87" Fail="94">181</Total>
    		<M.Name>B003382AA-BOTTOM-FLAN.SWX</M.Name>
    		<DateOfTest>2017-06-06</DateOfTest>
    		<TimeOfTest>04:54:22+02:00</TimeOfTest>
    		<TestTime>00:00:05</TestTime>
    		<M.Version>2.0-9g</M.Version>
    		<TesterID>9411_1</TesterID>
    		<M.Index>P=B003382AA X=24B</M.Index>
    		<Message>.\n.-------------------------B003382AA\n.\n.- BOTTOM\n.- Connecteur vers le bas</Message>
    	</Header>
    	<ABSide AB="A">
    		<Group G.No="20">
    			<Step AB="A" G.No="20" No="499">
    				<Aux>Non</Aux>
    				<Parts>D4</Parts>
    				<Value>*</Value>
    				<Comment>HH00003SA</Comment>
    				<Loc>*</Loc>
    				<Func>**</Func>
    				<P.Tol Unit="%">30</P.Tol>
    				<M.Tol Unit="%">30</M.Tol>
    				<Judge>OPEN</Judge>
    				<M.Mode>DC-CC</M.Mode>
    				<M.Range>4</M.Range>
    				<M.Time Unit="ms">1.0</M.Time>
    				<Ref.EL>D</Ref.EL>
    				<Ref.Val Unit="V">0.666</Ref.Val>
    				<Ref.Fig Unit="V">0.666</Ref.Fig>
    				<Test.EL No="1">D</Test.EL>
    				<Test.Val No="1" Unit="V">2.652</Test.Val>
    				<Test.Fig No="1" Unit="V">2.652</Test.Fig>
    				<Test.EL No="2">D</Test.EL>
    				<Test.Val No="2" Unit="V">2.652</Test.Val>
    				<Test.Fig No="2" Unit="V">2.652</Test.Fig>
    				<AccessProbe>( +. N. N. -)</AccessProbe>
    				<Pin Pol.="+" NET="$554">310</Pin>
    				<Pin Pol.="-" NET="$553">318</Pin>
    				<Pin Pol.="G1" NET="*">0</Pin>
    				<Pin Pol.="G2" NET="*">0</Pin>
    				<Contact No="1" XYUnit="mm">163.1425 129.6138</Contact>
    				<Contact No="4" XYUnit="mm">174.2325 140.4000</Contact>
    				<D.Status>---</D.Status>
    				<T.Info>
    					<D.Pass>2</D.Pass>
    					<D.Fail>3</D.Fail>
    					<T.Pass>87</T.Pass>
    					<T.Fail>94</T.Fail>
    					<M.Name>C:\TAKAYA\board\Carte B003382AA\B003382AA-BOTTOM-FLAN.SWX</M.Name>
    					<DateOfTest>2017-06-06</DateOfTest>
    					<TimeOfTest>04:54:22+02:00</TimeOfTest>
    					<TestTime>00:00:05</TestTime>
    					<TesterID>9411_1</TesterID>
    					<M.Index>P=B003382AA X=24B</M.Index>
    				</T.Info>
    			</Step>
    		</Group>
    		<Group G.No="24">
    		</Group>
    	</ABSide>
    </Faildata>
    
    <Faildata>
    	<Header>
    		<Judge>PASS</Judge>
    		<D.Total Pass="3" Fail="3">6</D.Total>
    		<Total Pass="88" Fail="94">182</Total>
    		<M.Name>B003382AA-BOTTOM-FLAN.SWX</M.Name>
    		<DateOfTest>2017-06-06</DateOfTest>
    		<TimeOfTest>04:55:29+02:00</TimeOfTest>
    		<TestTime>00:00:02</TestTime>
    		<M.Version>2.0-9g</M.Version>
    		<TesterID>9411_1</TesterID>
    		<M.Index>P=B003382AA X=24B</M.Index>
    		<Message>.\n.-------------------------B003382AA\n.\n.- BOTTOM\n.- Connecteur vers le bas</Message>
    	</Header>
    	<ABSide AB="A">
    		<Group G.No="4">
    		</Group>
    	</ABSide>
    </Faildata>
    
    <Faildata>
    	<Header>
    		<Judge>FAIL</Judge>
    		<Judge>GROUP JUMP</Judge>
    		<D.Total Pass="3" Fail="4">7</D.Total>
    		<Total Pass="88" Fail="95">183</Total>
    		<M.Name>B003382AA-BOTTOM-FLAN.SWX</M.Name>
    		<DateOfTest>2017-06-06</DateOfTest>
    		<TimeOfTest>04:55:54+02:00</TimeOfTest>
    		<TestTime>00:00:03</TestTime>
    		<M.Version>2.0-9g</M.Version>
    		<TesterID>9411_1</TesterID>
    		<M.Index>P=B003382AA X=24B</M.Index>
    		<Message>.\n.-------------------------B003382AA\n.\n.- BOTTOM\n.- Connecteur vers le bas</Message>
    	</Header>
    	<ABSide AB="A">
    		<Group G.No="20">
    			<Step AB="A" G.No="20" No="499">
    				<Aux>Non</Aux>
    				<Parts>D4</Parts>
    				<Value>*</Value>
    				<Comment>HH00003SA</Comment>
    				<Loc>*</Loc>
    				<Func>**</Func>
    				<P.Tol Unit="%">30</P.Tol>
    				<M.Tol Unit="%">30</M.Tol>
    				<Judge>OPEN</Judge>
    				<M.Mode>DC-CC</M.Mode>
    				<M.Range>4</M.Range>
    				<M.Time Unit="ms">1.0</M.Time>
    				<Ref.EL>D</Ref.EL>
    				<Ref.Val Unit="V">0.666</Ref.Val>
    				<Ref.Fig Unit="V">0.666</Ref.Fig>
    				<Test.EL No="1">D</Test.EL>
    				<Test.Val No="1" Unit="V">2.652</Test.Val>
    				<Test.Fig No="1" Unit="V">2.652</Test.Fig>
    				<Test.EL No="2">D</Test.EL>
    				<Test.Val No="2" Unit="V">2.651</Test.Val>
    				<Test.Fig No="2" Unit="V">2.651</Test.Fig>
    				<AccessProbe>( +. N. N. -)</AccessProbe>
    				<Pin Pol.="+" NET="$554">310</Pin>
    				<Pin Pol.="-" NET="$553">318</Pin>
    				<Pin Pol.="G1" NET="*">0</Pin>
    				<Pin Pol.="G2" NET="*">0</Pin>
    				<Contact No="1" XYUnit="mm">163.1425 129.6138</Contact>
    				<Contact No="4" XYUnit="mm">174.2325 140.4000</Contact>
    				<D.Status>---</D.Status>
    				<T.Info>
    					<D.Pass>3</D.Pass>
    					<D.Fail>4</D.Fail>
    					<T.Pass>88</T.Pass>
    					<T.Fail>95</T.Fail>
    					<M.Name>C:\TAKAYA\board\Carte B003382AA\B003382AA-BOTTOM-FLAN.SWX</M.Name>
    					<DateOfTest>2017-06-06</DateOfTest>
    					<TimeOfTest>04:55:54+02:00</TimeOfTest>
    					<TestTime>00:00:03</TestTime>
    					<TesterID>9411_1</TesterID>
    					<M.Index>P=B003382AA X=24B</M.Index>
    				</T.Info>
    			</Step>
    		</Group>
    	</ABSide>
    </Faildata>
    
    <Faildata>
    	<Header>
    		<Judge>PASS</Judge>
    		<D.Total Pass="4" Fail="4">8</D.Total>
    		<Total Pass="89" Fail="95">184</Total>
    		<M.Name>B003382AA-BOTTOM-FLAN.SWX</M.Name>
    		<DateOfTest>2017-06-06</DateOfTest>
    		<TimeOfTest>04:59:06+02:00</TimeOfTest>
    		<TestTime>00:00:01</TestTime>
    		<M.Version>2.0-9g</M.Version>
    		<TesterID>9411_1</TesterID>
    		<M.Index>P=B003382AA X=24B</M.Index>
    		<Message>.\n.-------------------------B003382AA\n.\n.- BOTTOM\n.- Connecteur vers le bas</Message>
    	</Header>
    	<ABSide AB="A">
    		<Group G.No="20">
    		</Group>
    	</ABSide>
    </Faildata>
    
    <Faildata>
    	<Header>
    		<Judge>PASS</Judge>
    		<D.Total Pass="5" Fail="4">9</D.Total>
    		<Total Pass="90" Fail="95">185</Total>
    		<M.Name>B003382AA-BOTTOM-FLAN.SWX</M.Name>
    		<DateOfTest>2017-06-06</DateOfTest>
    		<TimeOfTest>05:03:19+02:00</TimeOfTest>
    		<TestTime>00:00:02</TestTime>
    		<M.Version>2.0-9g</M.Version>
    		<TesterID>9411_1</TesterID>
    		<M.Index>P=B003382AA X=24B</M.Index>
    		<Message>.\n.-------------------------B003382AA\n.\n.- BOTTOM\n.- Connecteur vers le bas</Message>
    	</Header>
    	<ABSide AB="A">
    		<Group G.No="17">
    		</Group>
    	</ABSide>
    </Faildata>
    </ROOT>
    jeudi 8 juin 2017 13:54