Try this:

Be aware, this uses a serial updating methodology and I don't always follow every rule from Jeff's Quirky Update post here on SSC. This will work, however, as...

Something like this, perhaps?

SELECT

Code,

MaxTime,

CASE WHEN CODE = 'XX' AND MaxTime >= '2010-10-02' THEN 'DELAY'

WHEN CODE = 'XY' AND MaxTime >= '2010-10-05' THEN 'DELAY'

ELSE 'SUCCESS' END AS SuccessDelay

FROM

(SELECT

Code,

MAX( [Time]) AS MaxTime

FROM

#Temp...

Problem is this portion of your query, in regards to the error:

(select ("timestamp") from X where refeventid=b.refeventid

and "timestamp"< b."timestamp")

It needs to return a single entry for the function, and...

James, thank you for the kindness. It's appreciated... especially recently.

Hahah, okay, now that the selectivity is frying the 0.3% rule (1 day in a year, as a rule of...

An alternative is going to be a #tmp with specific indexes using the Quirky Update method, inverting the row numbering, using quirky to carry values down the nulls, then inverting...

Well, every now and then I get lucky. :w00t: Honestly though, my...

Were you able to try this in a copy of the proc?

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;

I'm curious if we can completely absolve the system of the locking issue.

There's been a number of timing tests out there...

There's a third option that may may your life easier for concurrency, but will add significant complexity if you're unfamiliar with it.

Use Service Broker.

The basic layout would be this. ...

That's kinda what we'd end up doing. Part of the reason I'm trying to get to the core of the data is because I'd actually completely rebuild from scratch...

jamesniesewand (11/1/2010)

---

Personally I felt I was missing something with CTEs, and that "felt" like a Eureka moment for me (I've only just moved up to 2008 from 2000, and CTEs...

Templar,

Trying to turn that into a usable test set and running into some issues. Biggest one is you trimmed (not sure how) some of the PRIMARY KEY builds.

For example:

CONSTRAINT...

James,

First, nice work on the sampleset and work shown. Helped a lot.

I usually use a variant on your Method 2 and 3, along these lines:

select

et.ExampleTableID,

et.ExampleProduct,

et.ExampleValue as...

I'm 98% sure it's possible to get you out of the cursor based methodology here. Can you post the DDLs for the involved tables and a bit of sample...

homebrew01 (11/1/2010)

---

I suspect that what was meant was that less experienced SQL DBA's, or people thrust into the role of DBA are the "weekend warriors" trying to make things work...