While pulling the rows from the SQL server view needs to update a table based on some condition

Question

I have a requirement to pull some table(let say table A) data by using a view. In that case based on some condition, I need to update the table A and will return the rows from that table.

Please let me know if anybody knows the solution for this...

Answer 1

Let's flip the question. How about you use MERGE to update what you need in TableA, including some records that don't necessarily need changing, and then use the OUTPUT clause to turn your data modification into something that returns data?