adam spencer (11/23/2009)

---

(smipped...)

If I did go ahead and show them a comparison written your way and a their Cursor way, what would be the biggest advantage? less code? runs faster?

I...

Make sure that your solution is sign-sensitive, because you will now get opposite results for positive and negative numbers

i.e. +7.044444449 => +7.05

however...

By the way, I'm sorry I missed the candle and cakes, but -

Happy 1st birthday to the Thread.

That's right - the Thread turned 1 last week.....

C# Screw (11/21/2009)

---

Matt Miller (#4) (11/21/2009)

---

actually there's a bg thread a few years back with Jeff and I doing the friendly footrace competition on CLR versus native T-sql solutions. ...

Technically,...

nice - glad I could help!

Indianrock (11/19/2009)

---

Access to cluster administrator is a secondary issue. We had a meeting on this today and we may try to use 8 drive letters instead of mount points....

The name isn't your issue. This works:

declare @f xml

set @f='

<rt bob="">

<matt fun="1" notfun="2"><joe>uu</joe><comment> abcdefgh</comment></matt>

<matt fun="3" notfun="6"><comment> 987654asfd</comment></matt>

<matt fun="4" notfun="7"><comment> oooooooooooooooo</comment></matt>

</rt>'

select @f

select @f.query('for $b in /rt/matt

...

The cluster can also be set to NOT keep trying over and over. After 3 "round trips, for example, just plain fail (which then gives you something to alert...

This has "concurrency issue" written all over it, so you will need to ensure noone else is actively inserting during this process.

That said - if you can squeeze this in...

well - you can use the OSQL command-line tool to check on an instance.

For example :

Osql -E -S<server instance> -Q "Select @@servername"

Should return the name if the server...

Have you tried sending ith through a generic string writer to do the replacements, and then push it so XML?

and - you need to escape the " or it will...

Please don't cross-post.

conversation is already ongoing over here:

http://www.sqlservercentral.com/Forums/FindPost821231.aspx

Phil is showing you what is called a Common Table Expression. Unless you put that calculated column in your table, that's the way to do what you are asking.

You...

Maybe I'm reading that wrong - , but two places dont' look right:

1. if you're worried about the XML being valid - why load the stuff into an XMLdocument BEFORE...