Monthly Archive for July, 2006

Podcast Mania

I stumbled across Podcasting last year when I’m browsing on MSDN’s website and came across the DotNetRocks! page. I downloaded few of their episodes and immediately got hook by the show. That’s when I switched to iTunes as my primary music player for downloading a podcast is a breeze on that player.

Over the past months, I accumulated dozens of podcast episodes from different category. From the latest in technology, programming, movies, fashion, music, business, and humor. Here are some of the podcasts I’m currently listening and recommend:

Continue reading ‘Podcast Mania’

Dynamically number rows in a SELECT T-SQL statement (SQL Server 2000)

I encountered some TSQL Select problem where I want my result set to have a “number” on the first column. If for example you have a simple select statement

USE Northwind
SELECT CustomerID
, CompanyName
FROM Customers
ORDER BY CustomerID

which outputs

Continue reading ‘Dynamically number rows in a SELECT T-SQL statement (SQL Server 2000)’