Sql Server Doubt

[Usktapa]

are you getting any output for your query?

Declare @Alphanum Varchar(4) = 'TYUW'

 

Select SubString(@Alphanum, 1 + ( Cast(  4 * Rand( cast(newid() as varbinary) ) as Int)), 1)

+ SubString(@Alphanum, 1 + ( Cast(  4 * Rand( cast(newid() as varbinary) ) as Int)), 1)

+ SubString(@Alphanum, 1 + ( Cast(  4 * Rand( cast(newid() as varbinary) ) as Int)), 1)

+ SubString(@Alphanum, 1 + ( Cast(  4 * Rand( cast(newid() as varbinary) ) as Int)), 1)

 

if so..could you post the result set here..

[SeelamleniAunty]

are you getting any output for your query?

Declare @Alphanum Varchar(4) = 'TYUW'

 

Select SubString(@Alphanum, 1 + ( Cast(  4 * Rand( cast(newid() as varbinary) ) as Int)), 1)

+ SubString(@Alphanum, 1 + ( Cast(  4 * Rand( cast(newid() as varbinary) ) as Int)), 1)

+ SubString(@Alphanum, 1 + ( Cast(  4 * Rand( cast(newid() as varbinary) ) as Int)), 1)

+ SubString(@Alphanum, 1 + ( Cast(  4 * Rand( cast(newid() as varbinary) ) as Int)), 1)

 

if so..could you post the result set here..

baa mattalodi naa Id ,alli ban chesi 10garu 

[Usktapa]

baa mattalodi naa Id ,alli ban chesi 10garu 

ipudu sesara..epdoooo sesi 10gali..mods ipde lesinatunar..

[Nellore_peddareddi]

baa mattalodi naa Id ,alli ban chesi 10garu 

 

theduulu alantivi mari.

[Nellore_peddareddi]

ipudu sesara..epdoooo sesi 10gali..mods ipde lesinatunar..

[mtkr]

sorry ardam avaledhu how would that generate a code of 4 letters ?

 

 

TYUW nundi em em combinations expecting??

[mtkr]

 

 

drop table table_comb

 

create table table_comb

(

Name varchar(10)

)

 

insert into table_comb values ('TYUW')

 

select * from table_comb

 

 

drop table #Temp

 

 

 

create table #Temp (id varchar(1))

 

Insert into #Temp(id) (select substring(Name,1,1) from table_comb)

Insert into #Temp(id) (select substring(Name,2,1) from table_comb)

Insert into #Temp(id) (select substring(Name,3,1) from table_comb)

Insert into #Temp(id) (select substring(Name,4,1) from table_comb)

 

 

select t1.id,t2.id, t3.id, t4.id

from  #Temp t1 cross join

        #Temp t2 cross join

        #Temp t3 cross join

        #Temp t4

where t1.id <> t2.id

   and t1.id <> t3.id

   and t1.id <> t4.id

   and t2.id <> t3.id

   and t2.id <> t4.id

   and t3.id <> t4.id

 

[SeelamleniAunty]

ipudu sesara..epdoooo sesi 10gali..mods ipde lesinatunar..

report nokki 10ga 

[Usktapa]

report nokki 10ga 

ne mouse ki oka click waste aindhi..

 

report seyakuna 10gestha..

[SeelamleniAunty]

ne mouse ki oka click waste aindhi..

 

report seyakuna 10gestha..

[sqlhelp]

drop table table_comb

 

create table table_comb

(

Name varchar(10)

)

 

insert into table_comb values ('TYUW')

 

select * from table_comb

 

 

drop table #Temp

 

 

 

create table #Temp (id varchar(1))

 

Insert into #Temp(id) (select substring(Name,1,1) from table_comb)

Insert into #Temp(id) (select substring(Name,2,1) from table_comb)

Insert into #Temp(id) (select substring(Name,3,1) from table_comb)

Insert into #Temp(id) (select substring(Name,4,1) from table_comb)

 

 

select t1.id,t2.id, t3.id, t4.id

from  #Temp t1 cross join

        #Temp t2 cross join

        #Temp t3 cross join

        #Temp t4

where t1.id <> t2.id

   and t1.id <> t3.id

   and t1.id <> t4.id

   and t2.id <> t3.id

   and t2.id <> t4.id

   and t3.id <> t4.id

 

This is generating different combinations with same code .

I just need four codes

[Usktapa]

This is generating different combinations with same code .

I just need four codes

nen seppindhi workout kaale?

[mtkr]

This is generating different combinations with same code .

I just need four codes

 

 

ade nen adigedhi.. nuv cheppedi.. naak ardam kaanidi...

 

 

ea just four codes kaavali??

[sqlhelp]

nen seppindhi workout kaale?

 

no kaledhu
 

[Usktapa]

no kaledhu
 

that is the only way..adhi kakpothe nek inka edhi workoiut kadh..