Eugene Elutin (3/5/2013)

---

prakashr.r7 (3/5/2013)

---

Eugene, I forgot to tell this functionality.....

For example, if we have 150 rows to be updated with two character values, first we have to update PnxCodeValue feild...

Eugene, I forgot to tell this functionality.....

For example, if we have 150 rows to be updated with two character values, first we have to update PnxCodeValue feild with 99,98,97,...10 so...

Yes, Eugene, I did a mistake by using cursor....This one is very simple.. but how can i modify this set based operation to generate 2 character, 3, 4 and so...

Declare an integer-typed variable @Iteration or something outside the cursor loop and assign a value of 1. Inside the loop, SELECT @value = value FROM table WHERE key = @Iteration....

Sorry, but I don't.

I have asked what should happen with rows which cannot have unique on-character code set as all unique values already were used. Should such rows be...

You can solve your immeditate problem by using the solution I proposed above - generate a table of all 36 values (or whatever) randomised relative to an incrementing numeric key....

Jeff Moden (3/4/2013)

---

I hardly ever use the word "stupid" in describing something but the people asking you to do this are freakin' stupid to their core! How many lawsuits...

Eugene Elutin (3/4/2013)

---

and if you have more than 36 (or, as per your sample which already contains two of one-char codes, 34) ...

Since i don't want to update the rows with the existing values...i do row by row operation to avoid duplicates.....well, some function can be able to give unique values, but...

Create TAble Coded (JurisID int,CodeID int, srcCodeValue varchar(50), Description varchar(100), PnxCodeValue varchar(10))

insert into Coded(JurisId,CodeID, srcCodeValue,Description)

Select 0,1034,'BLU','BLUE'

union

Select 0,1034,'O','ORANGE'

union

Select 0 , 1034,'R','RED'

union

Select 0 , 1034,'GR','GREEN'

union

Select 0 , 1034,'BW','BROWN'

If...

First of all, Sorry Eugene...i am not a native speaker of english...so bare with me

yes..Eugene....generating 36 and skipping the the next incoming rows...since we can not generate more than unique...

Eugene,

I can generate unique values....what i am asking is " How do you generate unique values for 40 rows ? " We can generate upto 36 right? How to...

[quote-0

So, if table #tempSrcCodeDB contains more than 36 rows, it's okay to process 36 and throw away the rest?

Next thing - why not pick 36 rows at random from...

Eugene,

that topic was posted by me and from there, i was able to get some of the ideas at that time.. Thank you for reminding me. But still i can...

Eugene Elutin (3/4/2013)

---

if you want unique values then use 36-base encoding function from here:

http://www.sqlservercentral.com/Forums/Topic1267659-391-2.aspx

That one will generate unique values and it will "automatically" determine the size required based on how...