Jack Corbett (3/30/2009)

---

Lynn Pettis (3/30/2009)

---

Jan Van der Eecken (3/30/2009)

---

Geez, you are quick to pull out the rule book. Admitted, the pic is about the red card in the finals of...

Bob Hovious (3/30/2009)

---

Let me interrupt to drag the conversation away from futbol.

Lynn!! Lynn!! I actually had someone say they had an "ah-hah" moment... with respect to setting...

Actually, it's called anticipating where play is going so that you can be there to make (or not make) the appropriate call.

We aren't out there to call the doubtful or...

Look carefully at the clustered index. That is what makes this work. Based on your sample data and expected results it is actualy based on BatchNo, ColID.

Edit:

Unfortunately, the...

This is the "Water Cooler", all topics are fair game here.

Also depends on how loud it is said. If it can be heard across the field by the coaches, no warning, gone, no questions asked.

Jan Van der Eecken (3/30/2009)

---

Geez, you are quick to pull out the rule book. Admitted, the pic is about the red card in the finals of a prof game, but...

Also, depending on what is said, when it is said, and to whom it is said, one warning if not directed at anyone and then gone.

Jan Van der Eecken (3/30/2009)

---

Lynn Pettis (3/30/2009)

---

FYI, Bob's correct. ...

Does the following code help you?

-- Create a test table for the sample code

create table dbo.TestTable (

ColID int,

BatchNo int,

...

Bob Hovious (3/30/2009)

---

I hear you, Lynn.

That thread reads like " I want the problem to be with the SQL Server. Tell me how to...

LOL. If...

FYI, Bob's correct. Foul or abusive language is a...

Just what do the users expect us to do???

This is why I'm not a help desk person!

Give this a try. It is untested as you didn't provide any DDL for the tables or sample data. For better help, try reading the first article I...