Home Forums Article Discussions Article Discussions by Author Discuss content posted by Dwain Camps Double Counting and Sign Reversals RE: Double Counting and Sign Reversals

  • January 8, 2013 at 1:30 pm

    #1574988

    Great article Dwain! It also inspired me to read the N-Tuple article which I liked.

    It’s almost a shame (not really! J) that I no longer support Accounting applications because these scripts would undoubtedly save me countless hours of manual reconciliation.

    I supported accounting applications and could have used these (my first SQL job was supporting an accounting app that ran on NT4, SQL 6.5). I could have also used this then or during the parts of my college classes where I where we had to figure out why the books did not balance.

    Edit: Didn't run out of stuff to say... accidently hit enter and posted incomplete comment...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001