http://www.sqlservercentral.com/Content tagged T-SQL, SQL Server 2005, SQL Server 2005 - TSQL posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)New to SQL Server 2005 is the PIVOT operator, which gives you the ability to rotate row level data into tabular data without the use of the CASE statement, as was necessary in previous versions of SQL Server.http://www.sqlservercentral.com/redirect/articles/2791/2007/01/11http://www.sqlservercentral.com/redirect/articles/2791/Processing text or long strings usually reduces SQL to a prosaic procedural language. Learn a few techniques for facilitating speedy text processing in SQL. http://www.sqlservercentral.com/redirect/articles/2401/2006/05/10http://www.sqlservercentral.com/redirect/articles/2401/