Sean Lange (5/8/2012)

---

rabisco (5/8/2012)

---

Sean Lange (5/8/2012)

---

Well it certainly demonstrated the problem. Is this a one time thing or something you...

Sean Lange (5/8/2012)

---

Well it certainly demonstrated the problem. Is this a one time thing or something you need to run...

rabisco (5/7/2012)

---

rabisco (5/7/2012)

---

Sean Lange (5/7/2012)

---

How about since you...

rabisco (5/7/2012)

---

Sean Lange (5/7/2012)

---

How about since you never...

Sean Lange (5/7/2012)

---

How about since you never actually...

Sean Lange (5/7/2012)

---

Isn't this just a continuation of your thread from a couple months ago? It does not look like we ever found a resolution for that one.

http://www.sqlservercentral.com/Forums/Topic1255283-145-1.aspx

How about we...

michael vessey (5/4/2012)

---

rabisco (5/3/2012)

---

From the following string.....

<p style="text-align: justify;">Embedded link <a class="productLink href=";" macro="productLink" code1="1055288" uid="_13360741834971941">code1</a>sku</p>

I'm trying to detemine the position of "<a class="productLink" working backwards from the position of...

rabisco (2/28/2012)

---

Sean Lange (2/28/2012)

---

rabisco (2/28/2012)

---

What I'm trying accomplish is this.

The ideal.

For every paragraph , users should enter a value for code1 and code2.

The current situation.

Users have created some documents which...

Sean Lange (2/28/2012)

---

rabisco (2/28/2012)

---

What I'm trying accomplish is this.

The ideal.

For every paragraph , users should enter a value for code1 and code2.

The current situation.

Users have created some documents which have...

rabisco (2/22/2012)

---

rabisco (2/22/2012)

---

There really is no need for a cursor. Cursors are one of the worst constructs in t-sql for performance. This update can be accomplished in a single update...

rabisco (2/22/2012)

---

There really is no need for a cursor. Cursors are one of the worst constructs in t-sql for performance. This update can be accomplished in a single update statement....

There really is no need for a cursor. Cursors are one of the worst constructs in t-sql for performance. This update can be accomplished in a single update statement. I...

Each trip through your cursor it will update the ENTIRE table if @prereplace is null.

More than anything else there is no need for a cursor. I will ask again for...

Sean Lange (2/21/2012)

---

rabisco (2/21/2012)

---

derek.colley (2/21/2012)

---

It's updating all rows because what you are basically saying is for every row, set the bodytext equal to 'code=1' and concatenate other parameters onto it....

derek.colley (2/21/2012)

---

It's updating all rows because what you are basically saying is for every row, set the bodytext equal to 'code=1' and concatenate other parameters onto it. If those...