Ars Technica

SQL Server 2005: Pivot Help

I have a SQL Script that produces the following pivot query:<BR><BR> <pre class="ip-ubbcode-code-pre">SELECT ClientID, FirstName, LastName, SSN, 05/01/2009],[05/02 ...
Ars Technica

SQL Server PIVOT (with calendar weeks)

This has been driving me crazy. Can anyone help me understand how I can dynamically create a sort of calendar view for a promotional schedule? I can't seem to get anything to work My table ...
InfoWorld

SQL unleashed: 9 ways to speed up your SQL queries

A common SQL habit is to use SELECT * on a query, because it’s tedious to list all the columns you need. Plus, sometimes those columns may change over time, so why not just do things the easy way? But ...