lobbymuncher (1/10/2010)

---

Lynn Pettis (1/10/2010)

---

Do you think you could edit your post and put the [ url ] [ /url ] (no spaces inside the brackets) around the url's? This...

Agreed here as well, even with the ID10T's that sometimes visit.

I probably would too (not get involved, that is). Too much of a visual problem solver which is why I wouldn't make a good telephone support person unless I...

lobbymuncher (1/10/2010)

---

See also http://www.sqlservercentral.com/Forums/FindPost844653.aspx

See also http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/50ebe46e-2ef5-41d9-b915-b4405ed4a15f

See also http://forums.asp.net/t/1447537.aspx :w00t:

See also http://sjc.ironspeed.com/post?id=3575239&goto=nextnewest

The earliest of these posts is six months ago.

Surely it's worth spending fifteen minutes setting up a...

Sacrasm, good. Now try answering the question instead.

Matt Miller (#4) (1/10/2010)

---

CirquedeSQLeil (1/10/2010)

---

Paul White (1/10/2010)

---

Indeed. i was thinking...

Troubled I am by your lack of discussion. Two-way street discussions are. Question you asked, but information unwilling you are to give.

Not knowing what it is you are...

I'm sorry, but why should...

ifila (1/10/2010)

---

SELECT COUNT(DISTINCT(variablename))

Let's assume i have 1000 variable names, with duplicates, which is why i need DISTINCT.

I only want to display the TOP 50.

SELECT TOP 50 COUNT(DISTINCT(variablename)) does...

ifila (1/10/2010)

---

Lynn,

This is the ONLY forum i have used in 10+ years, that virtually makes it a requirement to provide tons of upfront 'stuff' just to get a simple answer.

What...

Add to this, if the OP is able to solve their own problem and still takes the time to post the information, they may be shown other ways to solve...

Good, you provided much more information and this is what we needed to help you. One more thing I would add, however, is the expected results based on your...

ifila (1/9/2010)

---

--SELECT DISTINCT TOP 1000 Email

SELECT COUNT(DISTINCT(Email))

FROM(SELECT Email1,Email2,Email3, Email4,Email5,Email6,Email7,Email8,Email9,Email10 FROM outputresume3

WHERE ((contains (originalresume, '"project" and "manager" and "php"'))

AND...

bitbucket-25253 (1/9/2010)

---

Take a look at this one

http://www.sqlservercentral.com/Forums/Topic844889-392-1.aspx

It is one of the worst I have seen on SSC in a long long time.

Lynn - I must compliment you on your restraint...

Gail calls South Africa home. Can't recall off hand what town (or city).