How to update value in a Column which value is null in a table with specific condition

Question

1.00/5 (1 vote)

See more:

SQL-Server-2008R2

I have table name T1
and values are as follows:-

SQL

Name
---
A
Null
Null
B
Null
Null

How to update like this

SQL

Name
-----
A
A
A
B
B
B

Posted 22-Apr-15 20:25pm

DINESH K MAURYA

Updated 23-Apr-15 0:49am

v2

Add a Solution

Comments

Maciej Los 23-Apr-15 3:13am

Is there any Primary Key?

DINESH K MAURYA 23-Apr-15 6:49am

No

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)

E.F. Nijboer · Answer 1 · 2015-04-23T01:19:00

There doesn't seem to be a real condition. The values are presented in no particular order and now you just assign the last non null value to any null value up until the next non null value.

By the way, if name is the only column without any other columns or index there really isn't any need to duplicate the values. A single A and B is enough. The other rows simply have no meaning and can be removed.

Good luck!