Updating columns in sql
(The issue is explained in this thread.)Thank you so much guys, I just realized that I misunderstood the meaning of "nesting"; I confused "levels of nesting" with "levels of condition".The CASE expression with more than 10 conditions works perfectly fine on my database.(Bug #11758262, Bug #50439) See Section 22.214.171.124, “Determination of Safe and Unsafe Statements in Binary Logging”, for more information.
To add new records to a database you use an append query, and to delete whole records from a database you use a delete query.You use update queries in Access databases to add, change, or delete the information in an existing record.You can think of update queries as a powerful form of the Find and Replace dialog box.Yours is not a case of nested CASEs, if you pardon the pun.The only way your normal CASE could break is if it had more than 10 conditions and was executed against a linked server, which is why Aaron has asked you about it.