update the column status based on other columns

Question

update the column status based on other columns

Naresh y 146

Hi team i have this table where the status are present in the table. i have three status columns Value_new/Value_old/IMNT_Status i need to update the IMT_Status whenever the value_new/Value_old column get updated., how do i update this IMT_Status for the given logic please share the logic input table User's image

Output table (desired o/p) User's image

LiHongMSFT-4306 31,616 Reputation points

2024-02-19T07:52:39.2066667+00:00

Hi @Naresh y Is there any update on this issue? If any answer helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)

Answer accepted by question author

0 additional answers

Your answer

LiHongMSFT-4306 31,616 Reputation points

2024-02-19T07:52:39.2066667+00:00

Hi @Naresh y Is there any update on this issue? If any answer helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)

Answer 1

Viorel 125.7K

Maybe like this:

update MyTable
set IMT_Status = coalesce(nullif(VALUE_NEW, ''), nullif(VALUE_OLD, ''))

Naresh y 146 Reputation points

2024-02-28T17:53:55.6733333+00:00

Small change in the requirement,as mention above, condition is : if Imt_status is empty it look for the value_new/value_old take and update the imt_status,if im_status is empty/contains value it should look for the latest value in the value_old column and get update the imt_status,please share the updatelogic for this

Naresh y 146

Small change in the r> ```

equirement,if imt_status is empty if will look for the value_new/value-old ,second case if imt_sttaus is empty /contain a value it looks for the value_old staus and update info the imt_status column ,I have shared some sample data and also with the screenshot ,please check and provide the update query

Naresh y 146 Reputation points

2024-02-28T18:18:47.57+00:00
Naresh y 146 Reputation points

2024-02-29T07:44:06.98+00:00

small correction in the above condition 1 : if the imt_status is empty then it will pick for the new value_new/value_old(not null value from both the columns ) will update into the imt_status table ,condition 2 : if the imt_status is empty/contains a value it should take the latest value from the value_old and update into the imt_status column.Please share the update condition logic for the above logic,attached is the data screeahooof which expectation
Viorel 125.7K Reputation points

2024-02-29T08:40:43.1966667+00:00
Check if this works:

update MyTable set IMT_Status = coalesce(nullif(Value_old, ''), nullif(Value_new, ''), IMT_Status)

If it does not work, then show the specific cases.
Naresh y 146 Reputation points

2024-02-29T11:19:53.4633333+00:00

thank for sharing this code,i will test more closely with this logic and update you shortly

Share via

update the column status based on other columns

0 additional answers

Your answer