Maybe try multiple update statements,

UPDATE [Staging_TABLE] SET Data_clean = REPLACE(Data_clean, ',||,','^')

UPDATE [Staging_TABLE] SET Data_clean = REPLACE(Data_clean, ',||',',"')

UPDATE [Staging_TABLE] SET Data_clean = REPLACE(Data_clean, '^',',||,')

Are you storing the original XML requests so you can look at those and try to recreate the failure?

below86 (3/10/2015)

---

Nevyn (3/10/2015)

---

below86 (3/10/2015)

---

I quess erything I deal with...

dwain.c (3/9/2015)

---

ZZartin (3/9/2015)

---

dwain.c (3/8/2015)

---

I don't really subscribe (generally) to the notion that breaking a query into separate pieces using temp tables makes it any easier to understand.

To me, properly formatting...

As has been said just that...

dwain.c (3/8/2015)

---

I don't really subscribe (generally) to the notion that breaking a query into separate pieces using temp tables makes it any easier to understand.

To me, properly formatting the query...

sqlguy-736318 (3/5/2015)

---

One benefit of breaking the query into temp tables is that allows the SQL writer to logically group related tables/data.

For example, course-related tables/data could be grouped into 1 temp...

sqlguy-736318 (3/5/2015)

---

Because you would be breaking the problem into pieces which inherently simplifies the...

Why do you think the process of create and populating temp tables will be less confusing?

While I totally understand the value of knowing what's going on behind the scenes why anyone willingly subjects themselves to a command line interface unless given absolutely no other choice...

Well on the MySQL Front, it's free and the general rule of thumb applies, every dollar you save in software costs you pay for in development time and maintenance.

As for...

Jeff Moden (3/2/2015)

---

ZZartin (3/2/2015)

---

Jeff Moden (3/2/2015)

---

Ah, yeah... we need to you move that smiley face one pixel to the right and change...

Jeff Moden (3/2/2015)

---

Ah, yeah... we need to you move that smiley face one pixel to the right and change the color on...

adonetok (3/2/2015)

---

One member table store member ID like this format for the same member:

(not all member has 4 ID, some has 2 some may have 3...)

12345P ...

Shrink database will shrink all the files, shrink file let's you specify the file you want to shrink. Unless you really need to reclaim drive space there's not too...