Two questions:

(1) Does the deleted table contain rows which have been deleted from...

You can't insert values into calculated columns. The answer is to list all the columns.

Also, you are looking for trouble by doing a...

Hey Seth,

Work got busy so I had to leave this behind. Please let us know if you pursue it. I don't expect my cte-on-cte...

(Conceding in advance that if you answer Jeff's question he will know a better way...)

This approach can handle your search, but comes with two caveats: (1) It involves creation of...

Without seeing it, there is not much way to see if there is a way to locate the value to be replaced and fix it with string manipulation. ...

Mark, please consider something like this as an alternative solution to the cursor approach. On my box, this is running in under 1 ms, while the cursor...

Arrrrrrgggggggggg CURSORS!!!!

MY EYES!!! :w00t:

I'm blind...........:cool:

Look at your where clause: @col = @search !!!

Using your input parms you are asking for rows where '[1]'='how'.

Usually you have to...

Glad you got an answer Mark. Sorry I couldn't get back to check on this quicker.

I just have to ask... does this have to be a view? If you call a stored procedure you can build a solution that will run more...

Michael, I'm posting this message a lot today, but it would be really helpful if you could post up some sample data and expected results.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

How complicated is your malformed XML? Can you paste a sample here? You may have a potential solution just using string manipulation. This...

Mark, it would be most helpful if you could provide an example (or better yet examples) of input data in table form and what you would expect the output from...

Here's an example of parsing using a tally table, but the article is really worth reading. This example creates the tally table on the fly from CTE's,...

smunson (11/3/2008)

---

---

Just a thought, but why would a set of data that starts with rows 1 thru 3 as duplicates, having only rows 2 and 3 be marked, and yet,...