Sunday, March 12, 2006 - Posts

Custom date formats in TSQL

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Custom date formats in TSQL
The new RSS feed is here

If you are anything like me then you will never be able to remember the right number to use with CONVERT to get the dateformat you want.

For this reason the most visited page in BOL is "CAST and CONVERT (Transact-SQL)". If BOL was a printed book this page would surely have perished long ago.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Custom date formats in TSQL

posted Sunday, March 12, 2006 5:45 PM by SimonSabin with 2 Comments

Running Sums the sequel part x

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Running Sums the sequel part x
The new RSS feed is here

If you've been following the trillogy (Adams posts 1,2 Jamies post ) of attempts at getting a running sum out of TSQL you will appreciate that there are many ways to solve a problem. Following my previous post on partitions and aggregates I thought that might be an avenue. Well it is, and i've thrown in a use of the unpivot as well. I know this could have been written using CASE statements, but that wasn't the point.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Running Sums the sequel part x

posted Sunday, March 12, 2006 5:39 PM by SimonSabin with 0 Comments

Multi level aggregates in SQL 2005

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Multi level aggregates in SQL 2005
The new RSS feed is here

I was looking to answer a users question on the forums this evening when I realised there is another big feature thats been added to SQL 2005 that I wasn't fully up to speed on. The user wanted to, for each row, provide a percentage that was related to the whole resultset. i.e.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Multi level aggregates in SQL 2005

posted Sunday, March 12, 2006 3:43 PM by SimonSabin with 2 Comments