How to update a column till the value changed in SQL server

Question

I've table like the following

TData   Ucode   Fla
Data1   123 w
Data2   123 NULL
Data3   123 NULL
Data4   123 n
Data5   123 NULL

The excepted result

TData   Ucode   Fla
Data1   123 w
Data2   123 W
Data3   123 W
Data4   123 n
Data5   123 n

I need to update "Fla" where "Ucode" till the "Fla" changes

Possible duplicate of [How to get Previous Value for Null Values](https://stackoverflow.com/questions/16669620/how-to-get-previous-value-for-null-values) — Jeroen Mostert, Jul 07 '17 at 17:54

score -1 · Answer 1 · answered Jul 07 '17 at 18:01

-1

you need to use an update statement

UPDATE table_name SET w='w'. WHERE w is NULL;

answered Jul 07 '17 at 18:01

Matthew Proudman

If you read his question or look at his sample data and expected output, you'll see that this isn't what he wants to do. – Stan Shaw Jul 07 '17 at 18:09
Thanks for you kind replay. But I need to update "Fla" till changes by Ucode – George Mouner Mikhail Jul 07 '17 at 18:15
your answer is not what I mean. – George Mouner Mikhail Jul 07 '17 at 19:12

1 Answers1