newenglander

200 reputation

113

bio	website	erike.net
	location	Hanover, Germany
	age	32
visits	member for	1 year, 9 months
	seen	Jun 7 at 12:10
stats	profile views	20

	200 reputation	bio	website	erike.net	visits	member for	1 year, 9 months
113 badges		location	Hanover, Germany		seen	Jun 7 at 12:10

summary answers questions tags badges favorites bounties reputation activity

54 Actions

suggestions reviews revisions comments badges posts accepts all

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
Feb 15	awarded	Popular Question
Dec 24	accepted	Is there a way to access temporary tables of other sessions in postgres?
Sep 26	comment	connection to Informix still active despite closing? That was it, thanks for doing the research for me ;)
Sep 26	accepted	connection to Informix still active despite closing?
Sep 25	asked	connection to Informix still active despite closing?
Sep 21	comment	What's a good (free) client for Informix on Windows? I finally found a good client (with free version): serverstudio.com
Sep 21	awarded	Popular Question
Jun 11	awarded	Citizen Patrol
Jun 11	awarded	Promoter
May 30	accepted	What joins are available in Informix 9.2?
May 9	comment	What joins are available in Informix 9.2? @ypercube: Newer versions of Informix have `LEFT`, `RIGHT`, and `FULL` outer joins. I mentioned `OUTER JOIN` and `OUTER` referring to different possibilities for the syntax, not different joins. @RolandoMySQLDBA: Thanks for jumping in with an example and link.