Stefan Krzywicki (3/31/2011)

---

Chad Crawford (3/31/2011)

---

Kiara (3/31/2011)

---

Hm - I'd love to know which brand it was, since the stuff I've used (albeit on fairly small areas) seemed to work fine....

Awww, my duckie's pretty good at tech problems. His answer to all my relationship questions though is "Go jump in...

john.arnott (3/30/2011)

---

Kiara (3/29/2011)

---

I'm going to take a moment and thank you all yet again for help that you didn't know you just provided.

I just spent about 45 minutes writing out...

Random topic swap: You know, I've always hated sitcoms. I can't stand watching someone doing something with the obvious idiot ball, it's like reality TV for me. ...

Stefan Krzywicki (3/30/2011)

---

GilaMonster (3/30/2011)

---

Craig Farrell (3/30/2011)

---

Grant Fritchey (3/30/2011)

---

And that blank spot is...

Short and easy form:

Yes, you want a subquery (not a correlated one) that will go in and find the max() date for each patientID, filtered only on dates after x...

Nope, notice...

freedom_nut (3/30/2011)

---

Awesome, Craig, thank you very much!!! You are the only person who seems to have understood my question correctly. I'll now pick it apart so I can...

Sean Pearce (3/30/2011)

---

GilaMonster (3/30/2011)

---

I suspect that you may need to get a specialist in (on-site) for a couple of days. I can recommend some good people here. Sounds like it's...

9 month old topic.

Ah, the old quotes instead of doubled apostrophes... nice catch opc.

pjlewis (3/29/2011)

---

I am trying to execute a sql query (using a stored procedure) to retrieve lookup table data from SQL Server 2008 R2 (using an .asp page) and populate a...

Nah, no test data so...

Mark Rice (3/29/2011)

---

I need to output the result set of a query to a text file, but each row should only have a carriage return (13) and no line feed....

A quick and dirty solution is to do this:

RIGHT( REVERSE( cola), CHARINDEX( '-', REVERSE( cola) ) - 1 )