- Thanks received
- 18
Well done DP, more or less all that's needed.DimPrawn said:@my-value='false' and not(ancestor::*/preceding-sibling::row/entry/@my-value='false')
You sort of miss the point AtW, perhaps in this instance XSLT might be slower, certainly if the preceding clause requires a recursive lookup of all the previous nodes, but that's not what it was designed for.AtW said:You have not offered the solution - DimPrawn did, even though I strongly suspect that performance will suffer for long sets, but then again I would not use XSL for performance critical operations, even though clearly having small loop that will abort quickly will always be faster - so much for functional way of doing things being better, eh?
Like my comment about SQL, sometimes the best way to do something is simply using pure ANSI SQL, e.g, bulk update etc. "UPDATE blah blah blah WHERE...", sometimes you need another sort of control.
In which case why b*rstardise the thing and add TSQL/PLSQL etc. as a hack, instead of simply leaving it to do what it does best and using something like ADO etc. to access a resultset when you need to manipulate things in another way?

.