-
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 ... -
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 ... -
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, ... -
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 ...
Programming
Because nothing says fun like nested IF statements and joins
- View more
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+ years I have a messy ... - View moreI have a need to determine the distinct number of ...
- View moreWe're using SSRS caching for a number of reports in ...
