Hi there,
I want to write an update query to do the following...
---
If (Condition A) = TRUE
Perform update no. 1.......
Else If (Condition B) = TRUE
Perform update no. 2.......
Else If (Condition C) = TRUE
Perform update no. 3.......
Else (Condition D) = TRUE
Perform update no. 4.......
---
How can I achieve this in SQL?
Many thanks!