Reputation
280
Top tag
Next privilege 300 Rep.
Create new tags
Badges
1 6 18
Impact
~43k people reached

  • 0 posts edited
  • 1 helpful flag
  • 3 votes cast
Feb
11
awarded  Nice Question
Feb
10
awarded  Famous Question
Jan
5
awarded  Notable Question
Sep
3
awarded  Popular Question
Jul
2
awarded  Curious
Jun
17
awarded  Notable Question
May
8
awarded  Notable Question
Apr
1
awarded  Notable Question
Mar
30
awarded  Nice Question
Jan
2
awarded  Popular Question
Oct
30
awarded  Yearling
Apr
12
awarded  Notable Question
Apr
12
comment Use CASE to select columns in UPDATE query?
Thanks to both of you for the tips, in my case the single update statement worked fine.
Apr
12
accepted Use CASE to select columns in UPDATE query?
Apr
12
comment Use CASE to select columns in UPDATE query?
Thanks for the tip about everything being updated, if this is slow, I may take @Colin 't Hart's suggestion to have multiple update statements.
Apr
12
comment Use CASE to select columns in UPDATE query?
Thanks for the answer. I've added some more information to my question, I hope it's understandable. That's a good alternative with multiple update statements (I'd prefer one update statement, but I see there's an advantage there).
Apr
12
revised Use CASE to select columns in UPDATE query?
added 323 characters in body
Apr
12
asked Use CASE to select columns in UPDATE query?
Apr
4
awarded  Popular Question
Mar
29
awarded  Popular Question