Browse by Tags

• calendar
• CASE
• date
• datetime
• iterate days
• join
• sort
• Summary
• time

• SQL Join Summary Query Example

  Heres a short exmaple to get you thinking about how SQL query results can be joined to tables for purposes such as attaching summary data.... Posted Nov 04 2009, 06:57 PM by Mike McIntyre with Filed under: join, sql, Summary

• MS SQL Server - Use Transact SQL CASE Expression To Sort Query Results

  The transact SQL 'CASE' expression is useful for a lot of things but did you know you can use it to sort your query results in special ways? Here's a simple example...... Posted Sep 28 2009, 08:00 PM by Mike McIntyre with Filed under: sql, CASE, sort

• MS SQL Server Date without Time Solution for MS SQL Server versions 2005 and 2000

  SQL Server versions prior to 2008 did not provide Date and Time data types. Below is a solution for SQL Server 2005 and 2000 that will strip time off a DateTime data type value. SELECT DATEADD ( DAY , DATEDIFF ( DAY , 0 ,[ DateTime] ), 0 ) Example Use... Posted Jan 27 2009, 07:44 AM by Mike McIntyre with Filed under: sql, datetime, time, date

• Welcome 2009! Create a Calendar with Microsoft Transact SQL (How to iterate days in a series)

  One puzzle SQL developers face from time to time is creating a calendar containing a series of days. Below is some SQL code that will create an in-memory calendar for every day from a begin date to an end date. By adding more columns to the #Calendar... Posted Dec 31 2008, 03:35 PM by Mike McIntyre with | with no comments Filed under: sql, calendar, iterate days