And that raises another of the basic tenets of data design - we should hold only that which is required and that which we do hold should be correct -...

I'd suggest it would probably be better to store genetic phenotype rather than birth sex for medical purposes i.e. XX, XY which would correspond to birth sexes of female and...

This should not be a problem at the database tier in your tiered architecture. Do this in the input, before it even gets near the tables. You'll find ETL...

• This reply was modified 5 years ago by  crmitchell.
• This reply was modified 5 years ago by  crmitchell.

I'd argue the version starting with the + is the "correct" format - that should be valid for calling from anywhere in the world. By convention the international access code...

Yes your right the GPExpess is on the RHS so as Jeff pointed out that would effectively turn it into an INNER JOIN.
That's what I get for not trying...

I tend to prefer keeping join criteria separate from filtering criteria so would generally go with a third option

LEFT OUTER JOIN Company.schema.GeneralParameter

An excellent point there Chris. I would want this set on any development machine but probably not on production machines. This is the same issue as we get in choosing...