Viewing 5 posts - 1 through 5 (of 5 total)
I see - I can't use FLWOR just to substitute the problem area - I have to recreate from scratch? - As I mentioned earlier my actual problem XML is...
July 26, 2011 at 4:56 am
I'm not sure a function is required for this. Have you considered:
declare @ToFind varchar(10)
declare @InString varchar(20)
set @ToFind = 'llo'
set @InString = 'Hello World, Hello World'
select LEN(@InString) - CharIndex(reverse(@ToFind),reverse(@InString)) - 1
This...
July 25, 2011 at 9:31 am
@mm.
I think the answer you propose is the best I've seen so far.
I like the suggestion of using FLWOR for this - may not be nicer but an...
July 25, 2011 at 3:06 am
What do you consider a large XML file and how many levels are we talking about? Would it be possible to provide a basic example of the structure?
The XML I...
July 25, 2011 at 2:41 am
That's a nice idea and I'll have a think about it, however my real world example has these problem nodes buried quite deeply in a large xml document stored stored...
July 22, 2011 at 3:27 pm
Viewing 5 posts - 1 through 5 (of 5 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy