drewsx2 (7/7/2009)

---

I have a text field that has {@CR} inserted into the paragraphs where the Carriage returns were. The script below will remove them all but I have to execute...

Thanks for pointing that out... I've edited the post to include the necessary hints...

shadigirgis (7/7/2009)

---

Can anyone tell me what is the right way to code the following. Simply, when I do the insert without the where clause, its works. I add...

Here you go.

Note that you don't actually have a NULL value in Field2; instead you have the string "NULL'. The code handles this.

-- with this clustered index, the following update...

kenny_scriber (7/7/2009)

---

Hi Guys, I am trying to write an update query that will update null rows with the last non null row. My data looks like this:

PK ID...

Ooooookay.... and I thought I had a good idea here.:sick:

Duplicate post, please post replies here.

Duplicate post, please post replies here.

Sorry, post appeared to hang and accidentally double-posted.

Jeff,

I'm pretty sure I know what your Tally table test is doing... but what is the difference between your "XML" and "XML2" tests? Would you be able to post your...

If you go back to the original post, and press the quote button, you well see that the element are in mixed case. Your browser may display them as upper...

This web site has a history of mucking up xml text. I suggest that you attach a file with your xml code in it - save it as a .txt...

http://www.microsoft.com/sqlserver/2008/en/us/whats-new.aspx

You don't have to give "blocks" of numbers out.

If you had tables like:

CREATE TABLE Company (

CompanyID int NOT NULL identity PRIMARY KEY,

...

Edward (7/6/2009)

---

Hi thanks for that but I only want the oldest record for each ID. That is why I am using the cursor. get all the disinct IDs from...