I want to figure out a way to update multiple rows that depend on a couple of variables. I don't really know the syntax in SQL, but I know what I would do in C, so maybe if you could translate this...
switch (x) case 0: switch(y) case 0: myVar = var; case 1: myVar = someOtherVar; case 1: . . .
Something like that is what I need to do. I could do it all with a bunch of queries but I don't really want to do it that way.