255 reputation
110
bio website
location
age
visits member for 2 years, 5 months
seen Oct 7 at 18:10

Oct
15
awarded  Popular Question
Oct
7
comment Schema Design Inquiry
Yes, sorry I used the word `role'.
Oct
7
asked Schema Design Inquiry
Oct
1
awarded  Critic
Jul
15
awarded  Popular Question
Jul
2
awarded  Curious
Mar
11
comment Need some recommendations on organizing data
This is really a question of natural vs. surrogate key for primary key. You can see more here and the links pointed to from there.
Feb
27
awarded  Commentator
Feb
27
comment Table Field to Reference Field in Other Tables
@Zane: Care to explain?
Feb
27
asked Table Field to Reference Field in Other Tables
Nov
28
awarded  Popular Question
May
9
awarded  Yearling
Nov
30
accepted Load Numerical Column with Variable Comma
Nov
30
comment Load Numerical Column with Variable Comma
OK, this works; I ended up doing something similar before seeing your answer. I guess, at first, my brain had been looking for a way of using the format model to 'logically' say that the value may or may not contain commas.
Nov
29
asked Load Numerical Column with Variable Comma
Sep
5
accepted Regular Expression Difficulty
Sep
5
asked Regular Expression Difficulty
Aug
30
comment Using Multi-table Insert for Parent and Child Table
@VincentMalgrat: I'm inserting rows returned by a subquery. It is this subquery that determines the parent-child relationship; two insert statements wouldn't work.
Aug
29
comment Using Multi-table Insert for Parent and Child Table
@Phil: Yes I am.
Aug
29
asked Using Multi-table Insert for Parent and Child Table