nocount wrapper for vega

        /*
        Adds a SQL-server specific callRows() method to Groovy Sql that functions like rows() against stored
        procedures that perform DML before doing a select.

        Essentially, it's just a set nocount on/off wrapper.

        Usage:

        sql.callRows(
            "someProcName",
            [
                paramOne: 'valOne',
                paramTwo: 'valTwo',
            ]
        )

         */
        Sql.metaClass.callRows << { String procName, Map params ->
            // build a statement
            String statement = "{call ${procName}("
            params.eachWithIndex { k, v, i ->
                statement+= i>0 ? ',' : '' + ':' + k
            }
            statement += ')}'

            // do the wrapped call
            def result
            sql.withTransaction {
                sql.execute('set nocount on')
                result = sql.rows(statement, params)
                sql.execute('set nocount off')
            }

            return result
        }