It would help if you could give us some sample data ( in a readily consumable format).

Please read through the link in my signature line and post table defs and...

Charlotte

Org.....uh, nevermind.

I think part of the male instinct is the desire to pee on stuff.

relief

Ice

This example has not been tested, but this should give you the first message for each threads for a specific To-User. This should at least get you started in...

CirquedeSQLeil (9/27/2010)

---

Brandie Tarvin (9/27/2010)

---

CirquedeSQLeil (9/27/2010)

---

Brandie Tarvin (9/27/2010)

---

Because he can't afford all the others. @=) It's not just the dentist he has to pay, you know. Daughters expect kickbacks whilst they...

edaboin (9/22/2010)

---

delete from afrom(select Emp_Name, Company, Join_Date, Resigned_Date

,ROW_NUMBER() over (partition by Emp_Name, Company, Join_Date

...

That's what I figured, but I was hoping to verify this from the OP.

There are several factors that will go into how much space will be required to...

I would recommend converting a sampling of them and then using that to estimate average DB size and extrapolate from there.

What exactly is a 'flat file database'?

CirquedeSQLeil (9/20/2010)

---

John Rowan (9/20/2010)

---

Pheasant death....had a great hunt this weekend with a bunch of good friends. Shot a bunch of birds, clays, high-powers, and blew some stuff up.....video/pics on...

Good location, central to about anywhere in the mid-west. ...

Brandie Tarvin (9/20/2010)

---

John Rowan (9/20/2010)

---

Yes, we have Omaha steaks...and in the airport too. Don't get me wrong, Omaha steaks has good steaks, but I don't think they can compete...

John Rowan (9/20/2010)

---

Yes, we have Omaha steaks...and in the airport too. Don't get me wrong, Omaha steaks has good steaks, but I don't think they can compete with an...