-
Hide #DIV/0! From Excel Pivot Table
Conditional formatting #DIV/0! within Excel is easy enough, but that doesn't work in Pivot Tables. Luckily, there's an option within Pivot Table options that allows ... -
Create CSV from file names in Windows folder
I have several hundred files in a windows directory that I need to get into a CSV list for import into a SQL table. This ... -
Find the datatypes of a SQL #temp table
I'm sure you've done it a million times like I have: selected a chunk of data into a #temp table for some quick and dirty ... -
Excel Lookup - Maintain Date Format
Consider the following spreadsheet in Excel: I wish to perform a lookup on these fields to build a dirty INSERT into SQL list, however when ... -
Sort In Original Order When Grouping
I am working on analysis against the Soccer World Cup in Brazil and have one small problem; for some reason a handful of event actions ... -
Get First Day & Last Day of Last Week
I have a requirement to generate data for reporting for the previous week, where the week starts on a Monday and ends on a Sunday.The requirement ... -
Find all tables with specific column name
Ever need to find out if or where a column exists within one of your tables? MSSQL and MySQL are remarkably very similar with at ... -
Goodbye Solutions Outsourced, Oran Park
After two years and a few months it was time to say goodbye to work life in South Western Sydney. I had just accepted a ... -
PHP POST method not posting "type=file" variable
I am updating some old PHP to move away from global variables and use $_GET, $_POST, etc (among plenty of other things). I bumped into an ... -
MySQL Fulltext Index not working
I recently moved from a standard wildcard search of my news table to making use of a MySQL Fulltext Index. At first everything seemed fine, ...
