Welp, we barked up the wrong tree... those plans are nearly a match.

*takes the problem to his pillows and sleeps on it*

EDIT: I take that back. Dug a little...

See above, islanded on the ostid..something and then sorted by the...

NOTE: You need the #tmp here, it's not the source data build. It works off the sample data you gave us earlier. What this does is basically create...

There's a couple of different techniques and approaches to this and I don't want to give you an over-complicated one if unnecessary. You've posted in the 7.0/2k forums. ...

naidu4u (11/1/2010)

---

but for any refotsid for the first row XYZ should be a datediff(minute, DateChanged, OTtime)

and for the remaining rows in the same refotsid, XYZ should be datediff(minute, DateChanged of...

I still need to have a better understanding of this before I can even ask what to do with the non-datetimes:

refotsid = 48242 then for the first row I need...

Can someone swing through here and see if they can understand what he's looking for better than I can? Or can maybe phrase what we need in a way...

Why does oldLocal have 16.00 and a real datetime value in it? Barring the rest, what are the non datetime values supposed to mean? You're overloading the column,...

mymail.default (11/1/2010)

---

Craig,

I will do it now, but just to make sure I understand:

This change is going to go on the test system right, and being executed on the test system...

SwedishOrr (11/1/2010)

---

I meant that if one of the activation procedures was receiving and processing messages until the queue was empty, would the others be able to receive and process messages...

SQL33 (11/1/2010)

---

A real puzzler for me.... I don't know how I'd create a test table for someone to play with from this.. but here's my question. The text...

Each message in the queue is supposed to be either unique, or your procs are supposed to deal with them in conversations. So, each of the queue's only deals...

Sorry for the slight necro, was a heck of a 2 weeks and catching up on some older stuff.

Jeff Moden (10/16/2010)

---

I just ended up writing about it in a very...

Naidu,

Let's figure a few things out here. First, if you could take a look at the first link in my signature, and setup DDL and sample data that way,...

It will seek when selectivity makes sense for it. Now, can you give us more context of if this is the same proc/query on both servers? You might...