-
MYSQL - Find Starting With Lowercase Letter
I recently wanted to update the taxonomy within a CMS to set the name of all tags to begin with an uppercase letter. Over 10+ ... -
Distinct Combination Selection in SQL
I have a need to determine the distinct number of combinations of selections in a fantasy competition - where the competition is to guess the ... -
Clear SSRS Report Cache
We're using SSRS caching for a number of reports in our organization; typically, those with relatively fixed date ranges and brands. Many of our reports ... -
Subtract days, weeks etc in SSRS
Yet another useful date subtraction technique, this time via SSRS and expressions. If you're not using SQL datasets to calculate your dates and times, then ... -
Create a Custom Sort Order in SSRS and Paginated Reports
There are times when alphabetical or numerical sorting just will not cut it. Whether you are designing dashboards for executive review or producing print-ready Paginated ... -
SSRS and Project Subfolders
If you're like me, you like to keep your reports well organized. This gets harder when you start to deal with hundreds of reports across ... -
Multiple labels on bar chart
I'm building a "dashboard" in SSRS that updates every minute to show the results of a particular horse race. One area on the page displays ... -
Download all Report Server RDL's
Thanks kindly to Vinay: http://bit.ly/1mfZY5n There is no option to download all RDL's at once from Report Server. This handy script will at least collect them ... -
An error occurred within the report server database
Today I experienced an error within SSRS Report Manager when attempting to modify the site schedules. I'd later find that editing any subscription on any ... -
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 ... -
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 ...
Programming
Because nothing says fun like nested IF statements and joins
