I'd love to see it, just don't seem to have the...

khanhdp (1/8/2010)

---

Lynn Pettis (1/8/2010)

---

Tested, and looks like the same as above.

create table dbo.TestTable (

A char(2),

B int,

C int,

...

You know what is really funny? It took me 15 minutes to put together that shot...

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...