Can you explain how Moe is a "winner"?

INSERT INTO #Candidates VALUES ('Moe', 'Perl'); --winner

INSERT INTO #Candidates...

Nice work.

There are a number of different ways of achieving the same thing with TSQL, even in the version you are using. Here's one of them:

SELECT ...

Ryan Keast (12/16/2009)

---

Oh my lord thats worked.

THANK YOU!!!!

I can understand the logic from this now.

Out of intrest at the very end of the SELECT statement you have a ...

Try this, Ryan:

SELECT *,

[Age Range] = CASE

WHEN [Age] < 18 THEN 'Juvenile'

WHEN [Age] BETWEEN 18 AND 31 THEN '18 TO 31'

WHEN [Age] BETWEEN 32 AND 41 THEN '32 TO 41'

WHEN...

This should get you started, Dean:

DROP TABLE #MySampleTable

CREATE TABLE #MySampleTable (col1 INT, col2 INT, col3 INT, col4 INT, col5 INT, col6 INT, col7 INT)

INSERT INTO #MySampleTable (col1, col2, col3, col4,...

Ryan Keast (12/9/2009)

---

How would I incorporate multiple age ranges?

So take it a bit further and say if between age 25 and 48 then "25-48" and add more if I need...

This expression for returning age range bears little resemblance to TSQL:

(SELECT CASE WHEN (SELECT DATEDIFF(year, PERSON.[D-O-B], GETDATE())

- CASE

WHEN MONTH(GETDATE()) > MONTH(PERSON.[D-O-B]) THEN 0

WHEN MONTH(GETDATE()) = MONTH(PERSON.[D-O-B]) AND...

Something like this:

WHERE headcount = 'transfercluster'

OR headcount = CASE WHEN @Consolidate <> '(Retail Consolidate)' THEN 'TransferConsolidate' ELSE CAST(NEWID() AS CHAR(36)) END

You can use CASE in a WHERE clause, but that's not the problem - you are trying to construct a list on-the-fly for the IN operator. The syntax of your...

There's an alternative syntax which you may find more intuitive:

SELECT IDENTITY(int, 1, 1) AS RowID, ...

INTO #temp

FROM ...

GSquared (12/14/2009)

---

CirquedeSQLeil (12/11/2009)

---

By the time the thread hits 10,000 y'all will be flatlined, passed out drunk from all the bear being passed around - bwahahaha 10,000 shall be mine (or...

<<from dual>> Oracle?

sibir1us (12/10/2009)

---

My question was to get the aggregation for every 5 rows of data, no matter how many rows there are in the table. If I have 503 records in...

GSquared (12/11/2009)

---

On the subject of beer, one of my favorite jokes is that the human body is the world's most efficient machine at turning European beer into American beer. ...

CirquedeSQLeil (12/11/2009)

---

Thanks Chris for following up.

As for the requirements and desired output, Chris was spot on. If this does not do exactly what you envisioned - we need to...