First you have to define what you mean by previous. I am guessing you mean InvoiceID? If you can post some consumable ddl and sample data I can help you...

Ed Wagner (7/18/2014)

---

I think that Old Ironsides was the name of the...

Ok you got me on that one...can't find the connection.

old ironsides

I have plausible deniability, I did not...

plank

jcrawf02 (7/18/2014)

---

SQLRNNR (7/17/2014)

---

Jack Corbett (7/17/2014)

---

Sean Lange (7/17/2014)

Sadly I will not. I need to find a way to get to one though. It is a large chunk of change...

Karthik posted some excellent code that will do what you are asking. However, I would suggest that in your case you don't do it like this. The minimum across a...

This gets asked around...

Jack Corbett (7/17/2014)

---

Greg Edwards-268690 (7/17/2014)

---

The Dixie Flatline (7/16/2014)

---

Cafe du Monde in the French Quarter? Probably a few miles as the crow flies. I'd...

SQLRNNR (7/17/2014)

---

Jack Corbett (7/17/2014)

---

Sean Lange (7/17/2014)

Sadly I will not. I need to find a way to get to one though. It is a large chunk of change for...

SQLRNNR (7/17/2014)

---

Sean Lange (7/17/2014)

---

I assume that Summit will be in Bellevue or Redmond. That makes for a length bus trip. Depending on how you hit the timing it could be...

SQLRNNR (7/17/2014)

---

Sean Lange (7/17/2014)

---

SQLRNNR (7/17/2014)

---

The Dixie Flatline (7/16/2014)

---

Woohoo!! Done with work for the evening, and in the morning we're heading to New Orleans for a long weekend. 😀 :-D...

SQLRNNR (7/17/2014)

---

The Dixie Flatline (7/16/2014)

---

Woohoo!! Done with work for the evening, and in the morning we're heading to New Orleans for a long weekend. 😀 😀 😀 ...

Evil Kraig F (7/16/2014)

---

Sean Lange (7/16/2014)

---

Lynn Pettis (7/16/2014)

---

patrickmcginnis59 10839 (7/16/2014)

---

Jack Corbett (7/16/2014)

---

Eirikur Eiriksson (7/16/2014)

---

No implied either, my respect on handling the situation! So far, JC is the only...