Help with Update Query

Question

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Mark Cowne One Orange Chip Points: 26984 More actions · Answer 1

Maybe this?

select a.FEILD1,a.LEVEL1,a.SCORE,a.Rank,

(select b.Rank as "text()"

from mytable b

where b.LEVEL1<>a.LEVEL1

order by Rank

for xml path('')) as Result

from mytable a

____________________________________________________

Deja View - The strange feeling that somewhere, sometime you've optimised this query before

How to get the best help on a forum

GAry Botto Grasshopper Points: 16 More actions · Answer 2

SSC Veteran

'Spot On' thanks for your help most appreciated.

Gary