DARPA. Because they're DARPA.

I'm not sure I'm completely following, but if this is a performance issue, you could load a snapshot of the report and cache that, then the users wouldn't really be...

[Jim].[dba].[Murphy] (5/3/2011)

---

GilaMonster (5/3/2011)

---

Between exchange control fees and taxes I might get to keep maybe 40% of anything donated, and spend several hours in the bank filling out paperwork explaining where...

Stefan Krzywicki (5/2/2011)

---

Fal (5/2/2011)

---

Stefan Krzywicki (5/2/2011)

---

Fal (5/1/2011)

---

After a horror week in which half my mirrors crashed, a royal wedding saturated the TV, radio, newspapers (as well as my dreams after...

I took a Systems Analysis class recently, and they were "explaining" the Cloud as anything you access that doesn't run on your computer. I made a nuisance of myself by...

Thanks for the alternative, Peso

GilaMonster (4/27/2011)

---

Brandie Tarvin (4/27/2011)

---

Wow. Gail, I loved the ice spirit story. That's beautiful and deserves a...

Yep, that works even better! Thanks again!

Excellent!

SELECT

carriermemid,

CASE

WHEN NOT EXISTS(SELECT * FROM #enrollment AS e2 WHERE e2.carriermemid=#enrollment.carriermemid AND e2.effdate<'1/1/2011' AND e2.termdate>'11/30/2010') THEN 'fail'

...

Dammit! Yes, I think I am, although that's not quite perfect. Here's some better info from me to build the #enrollment table, with a member who has two separate spans...

See Itzik Ben-Gan's blog for another alternative, we used this to create our own modified membership table for reporting:

http://www.sqlmag.com/blogs/puzzled-by-t-sql

Tom.Thomson (4/26/2011)

---

Grant Fritchey (4/26/2011)

---

I used to work for a medical software company. it...

GSquared (4/26/2011)

---

Haiku would be fun.

Shakespearian iambic pentameter would be even...

Stefan Krzywicki (4/26/2011)

---

That is something that would strongly tempt me...

Personally, I learn a lot by being a wallflower in these kinds of conversations, so if it's not in the Thread but you are having it elsewhere, can we get...