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 ...

Share

Find all tables with specific column name

• On: May 25, 2014
• 0 Comments

Ever need to find out if or where a column exists ...

Share

Update value from SUM(values) in another table

• On: March 6, 2014
• 2 Comments

I recently found myself forgetting the exact syntax to update a ...

Share

Find text in Stored Procedures

• On: January 14, 2014
• 0 Comments

I can't express how useful this has been to me when ...

Share

Most Active Databases in SQL Server

• On: November 17, 2013
• 0 Comments

I recently had someone ask what the most active databases were ...

Share

Add a column with a default and foreign key constraint

• On: October 15, 2013
• 0 Comments

Every so often you may be presented with the requirement to ...

Share

Get First Day of the Quarter

• On: July 15, 2012
• 0 Comments

I’m building a Stored Procedure and Report that needs to limit ...

Share

Get first & last day of the month

• On: July 2, 2012
• 0 Comments

I'm building a Stored Procedure and Report that sets the default ...