PIVOT and UNPIVOT turn rows into columns and back. Jacob Sebastian’s examples cover SQL Server 2005 and 2008, plus a cross tab query for SQL Server 2000.
SQL SERVER – Puzzle – Solution – Computed Columns Datatype Explanation
Solution to the Computed Columns Datatype Explanation puzzle: if a computed column comes out as TINYINT, here is how to create it as INT instead.
SQL SERVER – Puzzle – Computed Columns Datatype Explanation
Jacob Sebastian explains that SQL Server casts to the data type with the highest precedence. That leads to my puzzle on computed columns datatype.
SQLAuthority Author Visit – Ahmedabad User Group Meeting September 2008
Every third Saturday is the Ahmedabad User Group Meeting. Today I present SQL Server CTE and Recursive CTE, followed by a real life CTE example by Jacob.
SQLAuthority News – 700 Articles and Author Updates
The blog has reached 700 articles. Here is why I write, plus updates since article 600: the SQL Server MVP award, user group work and 4 million visitors.
SQLAuthority Author Visit – SQL SERVER – User Group Meeting – Ahmedabad – August 30, 2008
At the August 30 Ahmedabad User Group meeting we talked about the quality of programmers and hiring, and why free user groups are great for developers.
SQLAuthority Author Visit – Microsoft Student Partner Conference
On August 30, 2008 I presented a technical session at the Microsoft Student Partner conference in my city, and I explain what the MSP program offers students.