This is one of the most ridiculous things about sql insert errors. Somewhere there was a link to a requested fix but I can't find it just now. How dumb...

The OP posted this exact topic in another thread. Here are all the posts from that thread. :crazy:

Sean Lange (5/26/2011)

---

You just need to use nested replace statements.

replace(replace(MyCol, '&', ' '),...

Notice all the posts and responses you have gotten to your identical posts? This is why we try to discourage multiple postings.

Direct all further replies for this thread here.

Here is the link to Jeff's original article[/url].

And here is an example of how killer his code is with your example (and a few extra spaces).

declare @original varchar(100) = 'Alternative...

Are you saying that #SLA2_EvidToDesn has more than 1 row and that after you run this update all rows have the same value for app_date?

You just need to use nested replace statements.

replace(replace(MyCol, '&', ' '), '@', ' ')

just add as many nested replace calls as you need.

You will probably need to do this insert in batches. That is a huge amount of info to write to the transaction log all at once. Remember that just because...

These are called computer columns. Here is bol reference.

You know the people here are volunteers....

Are you saying that each of your tables has a composite key of 8 nchar fields? I have never tried doing something like your proposed MD5 idea but it seems...

I personally hacked into google's server to add this post to their search engine just to irritate you. If you actually read the post you would realize that the answer...

Excellent. I had not dug down to quite that level of understanding and was assuming it due to the NEWID() inside the case, especially since i was interested to see...

If you have a chance can you post your solution here so other may benefit from your work? Glad you got it figured out.

I was kind of intrigued by what you say happened so I had to run your code and discovered that you are correct with the way are doing it. I...

Since nobody clarified this for you...the temp tables reside on the server where the code is executed. So if Server1 calls a sproc on Server2 and the code in the...