THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » T-SQL Tuesday   (RSS)
Showing page 3 of 3 (23 total posts)
  • T-SQL Tuesday #002: Non-aggregated columns in a GROUP BY query

    It's time for the second T-SQL Tuesday, once again managed by Adam Machanic. Since my first T-SQL Tuesday post dealt with my long years with the SQL Server product, I decided to continue in that vein.  Adam asked for us to write something about a puzzle we had to deal with, involving TSQL. I decided to write about one of the most puzzling ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on January 11, 2010
  • Unambiguous date formats : T-SQL Tuesday #001

    One of the most commonly used data types in SQL Server is [datetime] which unfortunately has some vagaries around how values get casted. A typical method for defining a [datetime] literal is to write it as a character string and then cast it appropriately. The cast syntax looks something like this: DECLARE @dt ...
    Posted to Jamie Thomson (Weblog) by jamiet on December 8, 2009
  • T-SQL Tuesday #001: My Datetime FAQ

    I am rising to Adam's challenge for his very first T-SQL Tuesday, and blogging about datetime issues. Since I just finished a 9-hour teaching day in Stockholm, and I'm incredibly jetlagged, I decided to keep this simple. I'm very much looking forward to what everyone else is going to say! For as long as I've been providing TSQL support, starting ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on December 8, 2009
Privacy Statement