No , but it may be unique enough...

Because by sheer luck ( not true, but the phrase will do) the rows are returned in an ordered list.

This is cannot be guaranteed.

If you need a resultset ordered you HAVE to specify order by.

So remove it if you dont care about order , but use it if you do.

Check out the dense_rank function is BOL to achieve that

Create a table such as....

Create Table MonthOrder

(

MonthCode char(3),

SortOrder tinyint)

insert into MonthOrder('Jan',1)

insert into MonthOrder('Feb',2)

insert into MonthOrder('Mar',3)

etc...

Join to that , and order by sortorder....

Something like this ?

with cteemails

as(

SELECT distinct(Email)

FROM(

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

WHERE ((contains (originalresume, '"j2ee" and "java"'))

AND

...

You cant generate a unique random number , you will have to generate a random number then test for uniqueness.

Heres how i generate random strings

http://sqlblogcasts.com/blogs/sqlandthelike/archive/2009/08/27/a-faster-tsql-random-length-random-string-generator.aspx

-- EDIT : Apologies , only...

Something like this ?

with cteuser

as

(

Select user_id,LastName,FirstName,row_number() over (partition by user_id order by LastName) as RowN

from <yourtable>

)

Select * from cteUser where RowN > 1

This Proc is probably a good starting point

http://sqlblog.com/blogs/adam_machanic/archive/2009/12/03/who-is-active-v9-57-fast-comprehensive-dmv-collection.aspx

No issue at all. Each session will have its own unique version of the table.

Apologies , Link sorted

A simple search would of pointed you here

http://www.sqlservercentral.com/Forums/Topic459626-146-1.aspx

Gianluca Sartori (1/11/2010)

---

CirquedeSQLeil (1/10/2010)

---

It's probably slumber time.

Or he is waiting just to talk to his developers in India. Which developers will be asking the same questions, if they're worth...

Try this link

http://www.sommarskog.se/arrays-in-sql-2005.html

ifila (1/9/2010)

---

I think 'the drill' is BS! By the time i go thru all the things that email asks for, i can get the response elsewhere, for a LOT less...