No Image

Excel VBA function for writing to a file

August 25, 2019 jlion 0

Every so often I work on a project that involves extracting data from excel where it’s easier just to code the extraction up as a macro. For these projects, these two functions serve me well by enabling my macros to …

No Image

Naming conventions for sql

August 10, 2019 jlion 0

I have some coworkers that haven’t worked a lot with sql subqueries. Subqueries are a great tool, but can be confusing for folks who have limited sql experience. It’s my opinion that, like any code, good naming, proper formatting and …