Share

Find SSRS subscriptions of an email address

• On: July 24, 2014
• 16 Comments

I recently had the need to remove an email address from ...

Share

Conditionally display end date if different to start date

• On: July 18, 2014
• 0 Comments

With SQL Server Reporting Services (SSRS) and the power of AD ...

Share

Hide #DIV/0! From Excel Pivot Table

• On: July 10, 2014
• 3 Comments

Conditional formatting #DIV/0! within Excel is easy enough, but that doesn't ...

Share

Create CSV from file names in Windows folder

• On: July 6, 2014
• 0 Comments

I have several hundred files in a windows directory that I ...

Share

Find the datatypes of a SQL #temp table

• On: July 4, 2014
• 0 Comments

I'm sure you've done it a million times like I have: ...

Share

Excel Lookup – Maintain Date Format

• On: July 1, 2014
• 0 Comments

Consider the following spreadsheet in Excel: I wish to perform a ...

Share

Sort In Original Order When Grouping

• On: June 26, 2014
• 0 Comments

I am working on analysis against the Soccer World Cup in ...

Share

Get First Day & Last Day of Last Week

• On: June 24, 2014
• 0 Comments

I have a requirement to generate data for reporting for the previous ...