Can you provide a table definition, some sample data, and a sample of what you want the output to look like from the sample data?

I'm having a little trouble visualizing...

Jack Corbett (3/31/2009)

---

Steve Jones - Editor (3/30/2009)

---

The definition is in the ear of the victim/beholder. However they have to let you know.

Overhearing something isn't harassment. If they say something, like...

I've had a basically psychotic person stalk me at work, does that count? I didn't even have to complain about that one, because she was doing the same to...

Putting something in the Where clause will take more processing power than using the updated columns function.

That's generally best done in the underlying query. Do you have that?

If you need to find out which table in a database has a certain column, you can use something like this:

select

(select name

from sys.tables

where object_id = columns.object_id), *

from sys.columns

where name...

You can use a unique index. The constraint will actually create a unique index. That's how it works.

I can't tell from the original post if it's included in...

My wife and I own a 2006 Ford Taurus and a 1999 Mazda Protege. They are both good cars.

The Protege gets about 27 mpg city, close to 50 highway....

I would say there's always a precise reason for a computer to fail, but not always a clear one. 🙂

Glad you found the cause. Were you able to solve...

What you need to do is trace the deadlocks and find what's competing with what. The deadlocks portion of Books Online has instructions on how to do that. ...

Try this:

SELECT *,

isnull(

(select min(t2_ts)

from tbl2

where act2 = a.act1

and t2_ts between dateadd(second, 30, a.t1_ts) and dateadd(second, 120, a.t1_ts)),

(select max(t2_ts)

from tbl2

where act2 = a.act1

and t2_ts between a.t1_ts and dateadd(second, 30, a.t1_ts))) as...

Nah. I do miss stuff. Challenging me is a good thing. 🙂

Santa Ana (3/27/2009)

---

A question gents :

If i place a NOLOCK for an update on a row (Update triggered by the background process) Say Transaction 1

If there is a ROWLOCK for...

Two simultaneous updates to the same row of the same table isn't a deadlock. Would have a block, and resolve the updates sequentially, but it's not a deadlock. ...

I think I created a Facebook account once several years ago. Haven't logged in since.

I do have a LinkedIn account. I've signed in a few times in the...