CELKO (2/24/2015)
You should follow ISO-11179 rules for naming data elements. You failed!
But even worse than all of this, is that you have two tables with the same structure.
Oh? You're sure the OP actually wrote the sproc and designed the DB? That he's not some guy coming in after the fact, just trying to do his best?
Your posting is full of fundamental errors. Not little errors, but fundamental errors. I spent decades of my life developing SQL standards, so when I tell you to stop programming you know I have some authority.
I only respect authority that respects other people. You fail that test. All the SQL knowledge in the world can't replace basic social skills.
WOW! Do you know how few ISO standards ate the long??
Come on, CELKO!! Can't you even type correctly?? Stop typing and go home until you know how to do it perfectly! 😛
Can you take a year off to get a proper education before you program again?
This is just you being mean for no reason. If you can't say your piece nicely, please don't bother to post. We'll all feel better.
PS: Your contribution about one possible way to keep a transaction history was actually clear and helpful. For a change.
Sigerson
"No pressure, no diamonds." - Thomas Carlyle