Here is the article from Jason Strate that Grant was mentioning.

http://www.jasonstrate.com/2012/06/the-side-effect-of-nolock/%5B/url%5D

And here are a couple of others ones that are also quite good.

http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/11/10/1280.aspx

http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx

haha. it seems I forgot the closing [ code] tag. Will fix that now. 😀

The biggest issue by far of that hint is not reading in a row that is being inserted/updated and getting an incorrect value. Most people think that is the issue....

Hi and welcome to the forums. In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form...

I ran this through a code formatter...the columns "names" are so painful that no amount of formatting is going to make this a lot better. Add to that the sheer...

OK all this nonsense about how painful NOLOCK can be has prompted me to write this again. I know I have posted this on this site a few other times....

kwoznica (6/4/2014)

---

Sean,

That's money!! I'll run it on my actual table in the morning. This way isn't that expensive either when compared to the windowing function. Thanks for your input....

I was hopeful when I saw that you had posted some details. However, what you posted scares me to death. In addition to Chris' comment about not having sample data...

What is this? It seems you need help with something but...

Glad it worked for you. The question is do you understand what it is doing?

Kind of a unique requirement but not too bad. Just using the case suggestion from Koen. I also removed the LTRIM and RTRIM functions wrapping your constant -00 as that...

That is the alias he used for ROW_NUMBER.

Related NewTitle with that fields[/quote]

But your output...

Looks like Luis coded what I was thinking. 😀

Which values of NewId, CatId and NewDate do you want when there...

eccentricDBA (6/4/2014)

---

Sean Lange (6/4/2014)

---

JAZZ Master (6/4/2014)

---

Ed Wagner (6/4/2014)

---

Sean Lange (6/4/2014)

---

SQLRNNR (6/4/2014)

---

crookj (6/4/2014)

---

Sean Lange (6/4/2014)

---

SQLRNNR (6/4/2014)

---

Sean Lange (6/4/2014)

---

crookj (6/4/2014)

---

whereisSQL? (6/4/2014)

---

Sean Lange (6/4/2014)

---

SQLRNNR (6/4/2014)

---

Ed Wagner (6/3/2014)

---

jasona.work (6/3/2014)

---

Ed Wagner (6/3/2014)

---

Sean Lange (6/3/2014)

---

crookj (6/3/2014)

---

jasona.work...