query formatting in helper functions

[andybeet]

remove semicolon from end of sql statement in supporting functions. Causes issues with ROracle