I'd query each account number, and then cross apply to get the date with the most records for each.

Evil Kraig F (12/29/2011)

---

True, good catch....

I don't think WriteText/UpdateText work on the (max) datatypes. They do work on Image, but you're right that it's unusual to do so.

How many values are you looking at and what SQL Server version? ...

Brian.cs (12/29/2011)

---

GSquared (12/29/2011)

---

patrickmcginnis59 (12/29/2011)

---

Brian.cs (12/29/2011)

---

RCSI really puts SQL Server running in a similar mode to what Oracle does by default, which is really what all robust modern RDBMS platforms should...

Brandie Tarvin (12/29/2011)

---

GSquared (12/29/2011)

---

Brandie Tarvin (12/29/2011)

---

Question for those of you commenting on external drives. The few times I have tried it (both on a local db on my laptop and...

GilaMonster (12/29/2011)

---

David Moutray (12/29/2011)

---

It occurred to me that you could do exactly that (forget about transactions) by setting the transaction isolation level to SERIALIZABLE. (Sometimes I just amaze myself...

Stefan Krzywicki (12/29/2011)

---

Revenant (12/29/2011)

---

Brandie Tarvin (12/29/2011)

---

Question for those of you commenting on external drives. The few times I have tried it (both on a local db on my laptop and...

When I need to read from one table and write to another, but can't do it in a single query.

I've had to do that in a couple of complex queries...

David Moutray (12/29/2011)

---

GSquared (12/29/2011)

---

patrickmcginnis59 (12/29/2011)

---

Brian.cs (12/29/2011)

---

RCSI really puts SQL Server running in a similar mode to what Oracle does by default, which is really what all robust modern RDBMS platforms...

Brandie Tarvin (12/29/2011)

---

Question for those of you commenting on external drives. The few times I have tried it (both on a local db on my laptop and from a server...

Fraggle-805517 (12/29/2011)

---

On a different tangent, as C#/VB is pretty darn fast for loops and such, any thoughts on potential performance gain/loss by doing the stuff in a CLR? By...

patrickmcginnis59 (12/29/2011)

---

Brian.cs (12/29/2011)

---

RCSI really puts SQL Server running in a similar mode to what Oracle does by default, which is really what all robust modern RDBMS platforms should support. Locking...

Grant Fritchey (12/29/2011)

---

Stefan Krzywicki (12/29/2011)

---

I can't even get them...

GilaMonster (12/29/2011)

---

GSquared (12/29/2011)

---

Stefan Krzywicki (12/29/2011)

---

I suppose it doesn't help that sometimes re-attaching the database files works, like if you're re-installing SQL Server and just make sure the files are where...