Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
6
Impact
~1k people reached

  • 0 posts edited
  • 0 helpful flags
  • 1 vote cast
Aug
21
awarded  Autobiographer
Jun
9
awarded  Popular Question
Feb
25
accepted Improve performance with the WHERE NOT IN sub-select clause
Feb
25
awarded  Supporter
Aug
27
revised Improve performance with the WHERE NOT IN sub-select clause
added 6 characters in body
Aug
27
awarded  Editor
Aug
27
revised Improve performance with the WHERE NOT IN sub-select clause
added 165 characters in body
Aug
27
comment Improve performance with the WHERE NOT IN sub-select clause
I have to exclude from the result set entirely, customers that have a transaction older than one year.
Aug
27
asked Improve performance with the WHERE NOT IN sub-select clause
Sep
6
comment According to the SQL92 spec, can I store the value 1 in a field where the precision = scale?
That is what we were thinking. We were confused when we were able to store the value 1 in a column like this in Firebird version 1.2 and version 2.5. This SQL returns 1 => SELECT CAST(1 AS DECIMAL(3,3)) FROM RDB$DATABASE
Sep
6
awarded  Scholar
Sep
6
accepted According to the SQL92 spec, can I store the value 1 in a field where the precision = scale?
Aug
6
awarded  Student
Aug
5
asked According to the SQL92 spec, can I store the value 1 in a field where the precision = scale?