Click here to Skip to main content
15,393,377 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Actually i have a table with Items as,

No.   Name.
2      abc
2      def
3      jkl
4      MNO
4      PQR


Here it number series needs to be changed but in the following way and records are in thousands.

No.   Name.
11      abc
11      def
12      jkl
13      MNO
13      PQR
Posted
Updated 13-Sep-15 10:46am
v3
Comments
Patrice T 13-Sep-15 11:34am
   
What is your question ?
What is your problem ?
What is the usage of the number, is it indexed ?
Member 10418330 13-Sep-15 11:45am
   
Yes it is an index but it may repeat and i want to replace these indexes with new values and should also repeat

1 solution

Um...
SQL
UPDATE MyTable SET [No] = [No] + 9
   
Comments
Suvendu Shekhar Giri 13-Sep-15 11:49am
   
5ed :)
Maciej Los 13-Sep-15 16:47pm
   
What is logic?
OriginalGriff 13-Sep-15 17:08pm
   
"A branch of philosophy and mathematics that deals with the formal principles, methods and criteria of validity of inference, reasoning and knowledge. Logic is concerned with what is true and how we can know whether something is true."
http://dictionary.reference.com/browse/logic

:laugh:
Maciej Los 13-Sep-15 17:16pm
   
:laugh:
Years ago, when i was a student (of law) i said: logic is illogical. Now i know how much i was wrong ;)
Cheers, Maciej
OriginalGriff 13-Sep-15 17:28pm
   
You? Law?
I dunno, accountants, solicitors, we're letting anyone in these days! :laugh:
Maciej Los 13-Sep-15 18:10pm
   
Yeah... Law is my occupation, but programming is my hobby (and the second source of income).
I hope to gain a civil law doctorate in next 2 years ;)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900