Sql Server Doubt

[sqlhelp]

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

 

 

ea just four codes kaavali??

 

random ga 4 combinations eh kavali ..

 

or poni ila  can you please help to create something like   ipudu TYUW  is the code ankundam  atleast  26 aplhabets lo nunchi   can we generate codes like  

 

ATFE    ---  where here  T is the answer

RYBE

QILU

WGTR

 

ila oka answer code include chesthu  from A-Z  emaina random sequence generate  cheyocha?

 

I have all these codes but vatini break down  chesi ela  anedi ardam avatledhu .

 

module or rand tho formula cheyali ankunta

[mtkr]

random ga 4 combinations eh kavali ..

or poni ila can you please help to create something like ipudu TYUW is the code ankundam atleast 26 aplhabets lo nunchi can we generate codes like

ATFE --- where here T is the answer
RYBE
QILU
WGTR

ila oka answer code include chesthu from A-Z emaina random sequence generate cheyocha?

I have all these codes but vatini break down chesi ela anedi ardam avatledhu .

module or rand tho formula cheyali ankunta

vaarinii... nen Q e tappu gaa ardam chesukunnanaa.. jeevitham...

aa code lo each letter use chesi any random word generate cheyyalaa!!!

nen anukunnadi.. aa word ne combinations cheyyali anukunna...

cool.. will tey n let u knw

[Chitralekha]

ltt

[sqlhelp]

vaarinii... nen Q e tappu gaa ardam chesukunnanaa.. jeevitham...

aa code lo each letter use chesi any random word generate cheyyalaa!!!

nen anukunnadi.. aa word ne combinations cheyyali anukunna...

cool.. will tey n let u knw

 

ninna cheppadam alage kavali anaru  but  ivala morning ila kavali for more complexity anaru.

 

Thank u 

TYUW  ane codes anni  inko table lo unayi  with column name 'code' so  using that table    indaka chepinatu  random ga generate cheysi  vere table lo insert cheyali.

[mtkr]

 

Declare @Alphanum Varchar(4) = 'TYUW'

select

(

(SELECT TOP 1 a.* FROM

(

SELECT CHAR(number) AS [UPPER CASE ALPHABET] FROM master..spt_values WHERE [type] = 'P' AND number BETWEEN 65 and 73 AND CHAR(number) <> (Select SubString(@Alphanum, 2 + ( Cast( 1 * Rand( cast(newid() as varbinary) ) as Int)), 1))

)a

ORDER BY NEWID())

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

+ (SELECT TOP 1 a.* FROM

(

SELECT CHAR(number) AS [UPPER CASE ALPHABET] FROM master..spt_values WHERE [type] = 'P' AND number BETWEEN 74 and 81 AND CHAR(number) <> (Select SubString(@Alphanum, 2 + ( Cast( 1 * Rand( cast(newid() as varbinary) ) as Int)), 1))

)a

ORDER BY NEWID())

+

(SELECT TOP 1 a.* FROM

(

SELECT CHAR(number) AS [UPPER CASE ALPHABET] FROM master..spt_values WHERE [type] = 'P' AND number BETWEEN 82 and 90 AND CHAR(number) <> (Select SubString(@Alphanum, 2 + ( Cast( 1 * Rand( cast(newid() as varbinary) ) as Int)), 1))

)a

ORDER BY NEWID())

)

UNION

select

(

(SELECT TOP 1 a.* FROM

(

SELECT CHAR(number) AS [UPPER CASE ALPHABET] FROM master..spt_values WHERE [type] = 'P' AND number BETWEEN 65 and 73 AND CHAR(number) <> (Select SubString(@Alphanum, 4 + ( Cast( 1 * Rand( cast(newid() as varbinary) ) as Int)), 1))

)a

ORDER BY NEWID())

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

+ (SELECT TOP 1 a.* FROM

(

SELECT CHAR(number) AS [UPPER CASE ALPHABET] FROM master..spt_values WHERE [type] = 'P' AND number BETWEEN 74 and 81 AND CHAR(number) <> (Select SubString(@Alphanum, 4 + ( Cast( 1 * Rand( cast(newid() as varbinary) ) as Int)), 1))

)a

ORDER BY NEWID())

+

(SELECT TOP 1 a.* FROM

(

SELECT CHAR(number) AS [UPPER CASE ALPHABET] FROM master..spt_values WHERE [type] = 'P' AND number BETWEEN 82 and 90 AND CHAR(number) <> (Select SubString(@Alphanum, 4 + ( Cast( 1 * Rand( cast(newid() as varbinary) ) as Int)), 1))

)a

ORDER BY NEWID())

)

UNION

select

(

(SELECT TOP 1 a.* FROM

(

SELECT CHAR(number) AS [UPPER CASE ALPHABET] FROM master..spt_values WHERE [type] = 'P' AND number BETWEEN 65 and 73 AND CHAR(number) <> (Select SubString(@Alphanum, 3 + ( Cast( 1 * Rand( cast(newid() as varbinary) ) as Int)), 1))

)a

ORDER BY NEWID())

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

+ (SELECT TOP 1 a.* FROM

(

SELECT CHAR(number) AS [UPPER CASE ALPHABET] FROM master..spt_values WHERE [type] = 'P' AND number BETWEEN 74 and 81 AND CHAR(number) <> (Select SubString(@Alphanum, 3 + ( Cast( 1 * Rand( cast(newid() as varbinary) ) as Int)), 1))

)a

ORDER BY NEWID())

+

(SELECT TOP 1 a.* FROM

(

SELECT CHAR(number) AS [UPPER CASE ALPHABET] FROM master..spt_values WHERE [type] = 'P' AND number BETWEEN 82 and 90 AND CHAR(number) <> (Select SubString(@Alphanum, 3 + ( Cast( 1 * Rand( cast(newid() as varbinary) ) as Int)), 1))

)a

ORDER BY NEWID())

)

UNION

select

(

(SELECT TOP 1 a.* FROM

(

SELECT CHAR(number) AS [UPPER CASE ALPHABET] FROM master..spt_values WHERE [type] = 'P' AND number BETWEEN 65 and 73 AND CHAR(number) <> (Select SubString(@Alphanum, 1 + ( Cast( 1 * Rand( cast(newid() as varbinary) ) as Int)), 1))

)a

ORDER BY NEWID())

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

+ (SELECT TOP 1 a.* FROM

(

SELECT CHAR(number) AS [UPPER CASE ALPHABET] FROM master..spt_values WHERE [type] = 'P' AND number BETWEEN 74 and 81 AND CHAR(number) <> (Select SubString(@Alphanum, 1 + ( Cast( 1 * Rand( cast(newid() as varbinary) ) as Int)), 1))

)a

ORDER BY NEWID())

+

(SELECT TOP 1 a.* FROM

(

SELECT CHAR(number) AS [UPPER CASE ALPHABET] FROM master..spt_values WHERE [type] = 'P' AND number BETWEEN 82 and 90 AND CHAR(number) <> (Select SubString(@Alphanum, 1 + ( Cast( 1 * Rand( cast(newid() as varbinary) ) as Int)), 1))

)a

ORDER BY NEWID())

)

 

 

 

 

 

But idi ne answer ni every tym oka fixed position lone isthadi....

[Usktapa]

ok