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

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!

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

1 solution

Solution 1

Add your solution here

Preview 0

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

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us