quote:

---

Originally posted by ashishashish

Ohkk Its Seems Godd and i also found my Solution but one more thing,,,if i generate Randoms Number like this,,,,,


select left(newid(),6)


then if this...always give me unique num,bers,,,as i want,,mean alphabets and numbers mixx...
i just want to confirm that it always gime me,,Unique,,,,,


Thnaks In Advance,,,,

---

quote:

---

Originally posted by ashishashish

yea
i know here is not only numbers but alphanumeric values well it goes well with me if it always provide me UNIQUE....
Thanks,,,,
it is always provide UNIQUE????

---

select number/power(10,len(number)-8) as number from
(
select top 10000 abs(checksum(newid())) as number 
from sysobjects s1 cross join sysobjects s2
) as T

quote:

---

Originally posted by visakh16

try this

select number/power(10,len(number)-8) as number from
(
select top 10000 abs(checksum(newid())) as number 
from sysobjects s1 cross join sysobjects s2
) as T

---

quote:

---

Originally posted by visakh16

select number/nullif(power(10,len(number)-8),0) as number from
(
select top 10000 abs(checksum(newid())) as number 
from sysobjects s1 cross join sysobjects s2
) as T

---

quote:

---

Originally posted by ashishashish

How to generate Random Numbers In Sql 2005...
I know How to use NEWID() But I like to generate the random numbers of 8 digits n only numeric fields r there..........
but dont know how to generate this one,,,,,,,,

i tried only this ,,,,,but the result is always zero for me,,,,,

select cast(cast(newid() as binary)as bigint)

so any help will be useful,,,
Thanks In Advance,,,,,,

---

quote:

---

Originally posted by ashishashish

Is there Any Another way from which i get always unique alphanumeric value of 8 digits only,,,,,,,,,,

Any Suggestions that whats the logic behind this,,,,or any kind of suggestions ,,,,

Thanks In Advance,,,,

---

declare @alpha_numeric varchar(8)
set @alpha_numeric=''

select @alpha_numeric=@alpha_numeric+char(n) from
(

	select top 8 number as n from master..spt_values 
    where type='p' and (number between 48 and 57 or number between 65 and 90)
    order by newid()
) as t
select @alpha_numeric

quote:

---

Originally posted by madhivanan

quote:

---

Originally posted by ashishashish

Is there Any Another way from which i get always unique alphanumeric value of 8 digits only,,,,,,,,,,

Any Suggestions that whats the logic behind this,,,,or any kind of suggestions ,,,,

Thanks In Advance,,,,

---

If you want alphanumeric values

declare @alpha_numeric varchar(8)
set @alpha_numeric=''

select @alpha_numeric=@alpha_numeric+char(n) from
(

	select top 8 number as n from master..spt_values 
    where type='p' and (number between 48 and 57 or number between 65 and 90)
    order by newid()
) as t
select @alpha_numeric

Modified from http://sqlblogcasts.com/blogs/madhivanan/archive/2007/11/20/random-password-generator.aspx

Madhivanan

Failing to plan is Planning to fail

---

quote:

---

Originally posted by ashishashish

quote:

---

Originally posted by madhivanan

quote:

---

Originally posted by ashishashish

Is there Any Another way from which i get always unique alphanumeric value of 8 digits only,,,,,,,,,,

Any Suggestions that whats the logic behind this,,,,or any kind of suggestions ,,,,

Thanks In Advance,,,,

---

If you want alphanumeric values

declare @alpha_numeric varchar(8)
set @alpha_numeric=''

select @alpha_numeric=@alpha_numeric+char(n) from
(

	select top 8 number as n from master..spt_values 
    where type='p' and (number between 48 and 57 or number between 65 and 90)
    order by newid()
) as t
select @alpha_numeric

Modified from http://sqlblogcasts.com/blogs/madhivanan/archive/2007/11/20/random-password-generator.aspx

Madhivanan

Failing to plan is Planning to fail

---

Ohhh Thanks Sir..........

Its gr88 to get your help there its solved my problem i get numbers from this,,,,,,thanks for your support and help its gr8888,,,,
Its work perfectly fine for me....

U saved my Day

Thanks Again....

---