thanks, I'll try it, albeit without the first part as I have 162,000 records. 🙂

Thanks, Drew. My CIO, who was in meetings all day, suggested row_number--I'll look at NTILE as well as his version and your version of row_Number. Pretty sure what...

Thanks, but the problem is not the randomization--I can accomplish that with a local variable and newid().

the problem is getting unique values from a table that has

aaa ...

I have a newbie question: SSAS has a neural net algorithm. So, obviously it can be produced in SQL Server. How did your results...

I was on a phone job interview, and one of the question was: How do you know when you have done a good job?

I replied, If it pleases...

No, I don't believe that at all--what I believe is that that is the reason they would not transfer the technology to create secure phones to the private sector--unless they...

C'mon, Steve. Do you really think NSA wants you to have a cellphone that can't be scanned or eavesdropped on? 🙂

Just what I needed--thanks, Gary.

Sam

I have a similar but different problem--perhaps someone can steer me right:

I want to add a column (field) to a table if it doesn't exist but not if it does...

Of course, one problem is that the company may view their competition more broadly than any reasonable individual would--they may see it as the entire sphere (e.g. healthcare, retail clothing,...

The non-competes I have been asked to sign also ask/insist that I assert that my ability to find work has not been impaired. When my last employer came up...

There is the opposite side of the coin as well: non-solicitation agreements. I was not party to the non-solicitation agreements among corporations, whereas I semi-voluntarily signed a...

Steve,

I found your response of interest as I was faced with a similar problem 6 months ago and ended up using a lot of CAST() as decimal in the formulas...