I'm pretty sure we told you already but you really need to read this and THEN decide if you risk using nolock.

http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx

krypto69 (7/19/2011)

---

I'm having trouble with the syntax when I try to add this to my query:

SELECT Count('x') FROM PayeeMaster PM

INNER JOIN PayeeLink PL...

It checks if the previous value is different than the currentvalue (that's the start of a new group).

Runningvalue keeps a count of # of impressions. So in your case...

That's the closest I've ever come to doing what you need to do. This code is running in a matrix. I hope you have a way to change...

SELECT

...

The only possible suggestion I can provide is to either use left join or flush the isnull. But I'm also certain that this would change the results.

Moreover the optimizer...

Yes.

I just did a quick check in the download center of MS and apparently Sql express has its own SP.

http://www.microsoft.com/download/en/details.aspx?id=26729

Any other level :

http://www.microsoft.com/download/en/details.aspx?id=26727

The sps and cus are always for all versions of sql. With that in mind. this is what you see to be after :

http://www.sqlservercentral.com/articles/administration/2960/

Wow Jeff must make a nice santa in real life too,...

HTH

and 1 more thing. I think you might better of with a join rather than in. If you have a null in there for ref2 then the...

WITH CTE

select Ref2

from V1

group by Ref2

having COUNT(Ref2)>1

SELECT * FROM V1 WHERE V1.Ref2 IN (SELECT Ref2 FROM CTE)

Keep in mind that NOT IN is not 100% equivalent to the other 2. In you have a null in the in list the results will be different.

Moreover left...

Use datalength(columnname) and then add all those to get the sum of the row.

You might want to look for a shutdown command while you're at it. However unlikely it could explain the issue.

Jeff Moden (7/18/2011)

---

Ninja's_RGR'us (7/18/2011)

---

Holly Koch (7/18/2011)

---

I am in need of a SQL Server DBA for a client based in Lansing, MI. If you would be interested in more information,...