or you might be able to set up a local / domain user with spanish region settings and just run SSMS as that user using the "runas" command...

not nice, but...

Sorry, I...

so you want to INSERT into "some_other_table" where "value" and "rn" don't EXIST in #tgt

and UPDATE #tgt WHERE value and rn match to #src ?

Is that right? 😉

go to the Action section again and select "Go to URL"

Enter an expression for the url to get an alert window:

= "alert(""" & Field!Description.Value & """);"

Of course, you should URL...

Gosh, I hope that was a mistake?

That code was not the best version of the XML split for that problem by...

Hi, I think you have missed a very simple suggestion from Jeff, which was to check the length in the stored procedure you are calling.

If you are expecting anything up...

Jeff Moden (12/21/2012)

---

Steven Willis (12/21/2012)

---

First test used the same data as generated in a post above using a Tally table CTE. I generated test data with 100 rows, 1,000 rows,...

Jeff Moden (12/19/2012)

---

I'm getting some conflicting results on the performance testing. A 10 year old single cpu desktop computer and a laptop probably aren't the best places for me...

And the nice thing is this method works nicely on varchar(MAX)...

I used 2000 rows of 2000 pairs of values to test :

Duration_AvgCpu_AvgReads_AvgWrites_AvgRowCounts_Avg

106994.000000985614196918 36806...

Dwain,

Performance wise, the main "speed ups" in this version are the use of our old friend FOR XML PATH('') to bolt everything into one XML fragment (means only handling one...

Maybe 😉 I am just testing other data patterns...