571 reputation
513
bio website
location
age
visits member for 3 years, 1 month
seen Jul 21 at 20:52

Sep
8
awarded  Popular Question
Jul
2
awarded  Curious
May
1
awarded  Popular Question
Mar
5
asked Export to csv using db2 v10 for z/os
Jul
30
comment update statement with self join
@AndriyM- However, since it's not a single column (It's many) It really doesn't make sense to use a subquery.
Jul
30
accepted update statement with self join
Jul
30
answered update statement with self join
Jul
30
comment update statement with self join
@AndriyM, How would you use a subquery to do this?
Jul
28
awarded  Yearling
Jun
13
awarded  Notable Question
Apr
24
comment update statement with self join
@孔夫子, thanks. For some reason I thought that would cause a syntax error. However, for reference, that's not the sybase manual. It's the Sybase IQ manual, which is a different beast. Either way, it does seem to work.
Apr
24
revised update statement with self join
added 200 characters in body
Apr
24
comment update statement with self join
@JonSeigel, Thanks anyway :)
Apr
24
comment update statement with self join
@JonSeigel, specifying a table alias on the first line produces a syntax error. This does not.
Apr
24
asked update statement with self join
Apr
11
revised Why use both TRUNCATE and DROP?
deleted 4 characters in body
Feb
25
awarded  Popular Question
Nov
5
awarded  Notable Question
Jul
28
awarded  Yearling
Jul
3
comment Can MySQL reasonably perform queries on billions of rows?
My company has multiple billion row tables that use sybase. Runs fine as long as you have the correct indexes and know how to look at a query plan.