title: Transpose a set of rows as columns in SQL Server 2000
body: <p>Is there any facility of transposing rows to columns in SQL Server (it is possible in MS-Access)? 
  I was befuddled because this facility is available in MS-Access but not in SQL Server. Is it by design that this feature has not been included in SQL Server?</p>