Reputation
2,102
Top tag
Next privilege 2,500 Rep.
Create tag synonyms
Badges
9 33
Impact
~167k people reached

May
13
awarded  Caucus
Apr
16
awarded  Popular Question
Mar
19
comment Enforce data integrity with a recursive table
I'm not able to implement all of your solution as it requires changing existing constraints but I can adapt your solution to solve the problem. Thanks!
Mar
19
accepted Enforce data integrity with a recursive table
Mar
15
comment Enforce data integrity with a recursive table
This looks very interesting! I will try it out Monday and report back to see if this answers the question.
Mar
15
comment Database Design question, calculate or save financial positions
I reread your question. You can store the tax amounts as long as you also store a reference to which tax rate was used. Rates go up and down and you need to show the accountants which transactions used which rates.
Mar
14
revised Enforce data integrity with a recursive table
added 283 characters in body
Mar
14
revised Enforce data integrity with a recursive table
added sample data
Mar
14
revised Enforce data integrity with a recursive table
added 91 characters in body
Mar
14
revised Enforce data integrity with a recursive table
added 207 characters in body
Mar
14
asked Enforce data integrity with a recursive table
Feb
5
reviewed Excellent Recovery time effects of Availability Groups
Feb
5
reviewed Excellent Finding longest matching prefix
Feb
5
reviewed Satisfactory Simplify and optimize a complex query
Feb
5
awarded  Custodian
Feb
5
reviewed Satisfactory Is there a way to speed up an ALTER statement in SQL Server
Jan
11
comment Database can be accessed by all
I am a little bit uneasy about the idea of installing a production database on a non server operating system that will no longer be supported by Microsoft soon and using wireless for transmitting the data. There are just so many ways this can go wrong.
Jan
10
awarded  Custodian
Dec
18
comment Read ancient Oracle database into current Oracle version
I believe you can still download 9i which is not too far from 8. If this is worth the time you could install 9i on a test box and see if the files are recognized.
Dec
5
revised Periodic Oracle restarts…intentionally
clarification