How to update number series with other number series in SQL

Question

0.00/5 (No votes)

See more:

SQL-Server-2012

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 13-Sep-15 4:59am

Member 10418330

Updated 13-Sep-15 10:46am

Maciej Los

v3

Add a Solution

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

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

OriginalGriff · Accepted Answer · 2015-09-13T05:35:00

Solution 1

Um...

SQL

UPDATE MyTable SET [No] = [No] + 9

Posted 13-Sep-15 5:35am

OriginalGriff

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 ;)