sql Archives - matt thornton

Turbocharge your SQL development: get more out of SQL Server Management Studio

December 14, 2010 Matt Thornton 0

When SQL Server 2000 became SQL Server 2005, a huge number of things changed. DTS became SQL Server Integration Services, and as part of the package we saw the likes of Analysis Services and Reporting Services. All these additions to the SQL Server family necesitated a change in the suite […]

Quick tip: Use OVER to get row numbers in subsets

December 10, 2010 Matt Thornton 0

Consider the following. You have a set of data. Within the data are multiple subsets that share an identifier. WIthin your main set, you need to number the subsets for each item within it, e.g., Data ID SubsetID Name Lots more columns… ———- ———– 1 ABC Dave 2 DEF Trev […]