-
Excel 2010 - Set Default Template
You'd think that saving a workbook as a template and have that template load automatically when you start Excel shouldn't be that hard, right? You'll ... -
Find SSRS subscriptions of an email address
I recently had the need to remove an email address from all SSRS subscriptions as a certain person was no longer with the company. Rather than ... -
Conditionally display end date if different to start date
With SQL Server Reporting Services (SSRS) and the power of AD HOC reporting, we'll offer a StartDate and EndDate picker for many, if not all ... -
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 Column in Any Table with SQL (MySQL, MSSQL, PostgreSQL)
Ever needed to find out if or where a specific column exists within your database tables? Whether you are doing a schema audit, reverse engineering ...
