Oops, order of operation thing here

Select distinct TOP 5000 A.First_Name, B.Last_Name

From firstandlast A CROSS JOIN firstandlast B

ORDER BY NEWID()

However I think it limites to 5000 first then...

Simplest method I know of is to cross join the table to itself for distinct first and last name and order by newid() while using TOP n to limit the...

First and foremost the firing based on the concept it encourages underaged drinking is completely afoul of logic. Clearly the person is of age. I am sorry but that statement...

Depending on the number of matches you may need to use DISTINCT or GROUP BY to eliminate the duplicates becuase if a join enforces more than one row between CB/SL/EL...

I would suggest if you have a large number of servers you might want to approach MS on the enterprise agreement process and work with them to get a handle...

One other thing I forgot to mention and something me and my wife pondered.

We started referring to it as the GIN MOBILE as that is exactly what it started smelling...

Robert Hermsen (11/29/2007)

---

Ethanol -- Poor ROI - Yah it is cheap but it is subsidized and takes more fuel to create than it returns

Switchgrass ethanol and sugar cane ehtanol are...

OH the big one I just remembered, in India apparently "Yes" carries the connotation of I heard what you said versus in the US and UK of meaning "I Agree...

I agree with Loner points. US and UK culture are somewhat different. I had to do diversity training becuase I may deal with some off shore workers in the coming...

Steve Jones - Editor (12/13/2007)

---

Ah, no a Realist. Build a nice Fisher Price interface, similar to this one - http://www.fisher-price.com/img/product_shots/L3480_d_1.jpg, big buttons, lots of color, things moving, and...

Again there is no way to say what they will look for. But usually the one thing people look for and don't even realize is confidence and determination. If you...

What exactly do you mean? Was their submission incomplete or what?

Been there done that and think I have a t-shirt from a company stating the same thing on it. Fortunately over the years I have been able to get most...

Just a thought and I don't know why I didn't bring this up before but when was the last time you defragged the indexes, updated the statistics (sp_updatestats in 2K,...

Go to thinking about this and came up with an idea. The reason why it starts the path thru mdp.[/BIC/DZFIGL_C021] is because it has a fixed list to start with...