John Rowan (3/30/2010)

---

You belong here in Nebraska with me Jason. One of the small towns outside of Omaha has a Testical Festival every year. It's a big attraction....

Here's a little example of what you're looking to do:

DROP table #Fruits

create table #Fruits (FruitGroup CHAR(1), FruitName varchar(20), iLike BIT)

INSERT INTO #Fruits (FruitGroup, FruitName, iLike)

SELECT 'B', 'Strawberry', 1 UNION ALL

SELECT...

Crab

(Still hot, with fresh crusty French bread, salad, home-made pickled onions, and a bottle of cava = hog heaven)

gastropod

Fingerprint

Tuner

RBarryYoung (3/29/2010)

---

lmu92 (3/29/2010)

---

Just being curious: How close is that particular behavior of that specific person to be qualified as being a Troll? (disclaimer: limited to that particular thread due to...

Just my 1p worth, and brief (still knackered from 6 weeks of non-stop need-it-yesterday development).

Each shop I've worked at has put a different set of criteria up front when hiring....

skedaddle

S Hodkinson (3/18/2010)

---

Just because I am paraniod does not mean that they are not after me. And yes, I have been doing this job for more years than I...

It fooled the hippo?

RBarryYoung (3/14/2010)

---

Well, my back surgery is tomorrow (it got moved up). They've been putting me through medication withdrawal the last two weeks in preparation, so apologies if I've been...

P Jones (3/11/2010)

---

No, Swindon's...

nvrwrkn2 (3/11/2010)

---

Any idea on the code necessary to pull the top 2 distinct records, based on two date fields sorted datefield 1, datefield 2, for days of the week 1...

else x <> 1

But...you can't CASE a part of an expression:

WHERE x = CASE @var = 1 THEN 1 ELSE x END

AND x <> CASE WHEN @var <> 1...