-
Distinct combination selection
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 ... -
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 ... -
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 ... -
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 ... -
Update value from SUM(values) in another table
I recently found myself forgetting the exact syntax to update a value in a table based on the sum of another set of values in ...
SQL Server
All things SQL and SQL Server
