...-1.33/DShield/DShield.pm' [MSG] [Wed May 7 13:57:06 2008] Extracted 'LaBrea-Tarpit-1.33/DShield/dshield.result1' [MSG] [Wed May 7 13:57:06 2008] Extracted 'LaBrea-Tarpit-1.33/DShield/dshield.result2' [MSG] [Wed May 7 13:57:06 2008] Extracted 'LaBrea-Tarpit-1.33/DShield/dshield.result3' [MSG] [Wed May 7 13:57:06 2008] Extracted 'LaBrea-Tarpit-1.33/DShield/Changes' [MSG] [Wed May 7 13:57:...

...-1.33/DShield/DShield.pm' [MSG] [Sun Mar 23 23:50:08 2008] Extracted 'LaBrea-Tarpit-1.33/DShield/dshield.result1' [MSG] [Sun Mar 23 23:50:08 2008] Extracted 'LaBrea-Tarpit-1.33/DShield/dshield.result2' [MSG] [Sun Mar 23 23:50:08 2008] Extracted 'LaBrea-Tarpit-1.33/DShield/dshield.result3' [MSG] [Sun Mar 23 23:50:08 2008] Extracted 'LaBrea-Tarpit-1.33/DShield/Changes' [MSG] [Sun Mar 23 23:50:...

...'EekBoek-1.03.02/t/ivp/ref/balans2.txt' [MSG] [Fri Feb 8 00:26:46 2008] Extracted 'EekBoek-1.03.02/t/ivp/ref/btw.txt' [MSG] [Fri Feb 8 00:26:46 2008] Extracted 'EekBoek-1.03.02/t/ivp/ref/result2.txt' [MSG] [Fri Feb 8 00:26:46 2008] Extracted 'EekBoek-1.03.02/t/ivp/ref/balans2.csv' [MSG] [Fri Feb 8 00:26:46 2008] Extracted 'EekBoek-1.03.02/t/ivp/ref/grootboek2.txt' [MSG] [Fri Feb 8 00:26:...

...'EekBoek-1.03.02/t/ivp/ref/balans2.txt' [MSG] [Fri Feb 8 00:25:38 2008] Extracted 'EekBoek-1.03.02/t/ivp/ref/btw.txt' [MSG] [Fri Feb 8 00:25:38 2008] Extracted 'EekBoek-1.03.02/t/ivp/ref/result2.txt' [MSG] [Fri Feb 8 00:25:38 2008] Extracted 'EekBoek-1.03.02/t/ivp/ref/balans2.csv' [MSG] [Fri Feb 8 00:25:38 2008] Extracted 'EekBoek-1.03.02/t/ivp/ref/grootboek2.txt' [MSG] [Fri Feb 8 00:25:...

...FROM @x.nodes('/gpx/rte/rtept') AS Result2(rtept) RETURN END Alternatively you could just ... @x.nodes('/gpx/rte/rtept') AS Result2(rtept) RETURN end This won't compile... @inX.nodes('/gpx/rte/rtept') AS Result2(rtept) ) and create function fnGetGPX(@inCourseID int... @x.nodes('/gpx/rte/rtept') AS Result2(rtept); "Alain Quesnel" <alainsansspam@logiquel.com> ...

...1]', 'decimal(20, 2)') AS ele, rtept.value('geoidheight[1]', 'decimal(20, 6)') AS geoidheight FROM @x.nodes('/gpx/rte') AS Result1(rte) CROSS APPLY @x.nodes('/gpx/rte/rtept') AS Result2(rtept); "Alain Quesnel" <alainsansspam@logiquel.com> wrote in message news:uIa%%23kBPOIHA.3852@TK2MSFTNGP06.phx.gbl... I've been trying to return a regular result set from an XML typed field. I've ...

... test4 UNTIL result4 ELSE result3 THEN result2 THEN result1 .... A complex control structure. Can't be ... result1 ELSE action1 test2 0= IF result2 result1 ELSE action2 test3 0= IF result3 ...> test1 test2 OR test3 OR test4 OR UNTIL result4 result2 result1 ; Just as complex, but it can be easily ...

... THEN action1 test2 0= IF result2 result1 UNLOOP EXIT THEN action2...ELSE action1 test2 0= IF result2 result1 ELSE action2 test3 0...OR test4 OR UNTIL result4 result2 result1 ; Is it thus you...check3 test3 0= IF result3 result2 result1 ELSE action3 THEN ; I...

...> BEGIN test1 WHILE action1 test2 WHILE action2 test3 WHILE action3 test4 UNTIL result4 ELSE result3 THEN result2 THEN result1 .... Yes, this is a very complex control structure and I would say it is also .... It looks to me like leaving the loop by the UNTIL executes result4 as well as result2 and result1. I think that it will be hard to come up with examples that require such ...

...EXIT THEN action1 test2 0= IF result2 result1 UNLOOP EXIT THEN action2 ...EXIT THEN action3 test4 UNTIL result4 result2 result1 ; This is what I get...> ELSE action1 test2 0= IF result2 result1 ELSE action2 test3 0=... check3 test3 0= IF result3 result2 result1 ELSE action3 THEN ; I ...