﻿<?xml version="1.0" encoding="utf-8"?><rss xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" version="2.0"><channel><title>SQLServerCentral.com Content tagged pivot</title><link>http://www.sqlservercentral.com/</link><description>Content tagged pivot posted on SQLServerCentral.com</description><language>en-us</language><ttl>360</ttl><managingEditor>sjones@sqlservercentral.com (Steve Jones)</managingEditor><item><title>Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs</title><description><![CDATA[In Part 1, we learned how to make both Cross-Tabs and Pivots. In Part 2, we'll learn how to automate a very common type of Cross-Tab report and maybe learn some extra tricks on the way.]]></description><guid>http://www.sqlservercentral.com/articles/Crosstab/65048/</guid><pubDate>2008/12/03</pubDate><link>http://www.sqlservercentral.com/articles/Crosstab/65048/</link></item><item><title>Split string into table, separator can be more than 1 char</title><description><![CDATA[Split string like ('123,43,5465,6788,1231,111', ',') into table, separator (,) can be more than 1 char]]></description><guid>http://www.sqlservercentral.com/scripts/split/68689/</guid><pubDate>2009/11/19</pubDate><link>http://www.sqlservercentral.com/scripts/split/68689/</link></item><item><title>Pivoting, Unpivoting and Aggregating</title><description><![CDATA[We asked Phil Factor to write a nice simple quick-start guide about aggregation, pivoting and un-pivoting techniques. To do so, he takes us all the way from getting the data from a published source, transferring it to SQL Server, un-pivoting it, storing it in a relational table, aggregating it and finally pivoting the data in a variety of ways.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/68782/</guid><pubDate>2009/11/18</pubDate><link>http://www.sqlservercentral.com/redirect/articles/68782/</link></item><item><title>Dynamic Columns with PIVOT Operator</title><description><![CDATA[Script to convert to N Columns the rows in a table with PIVOT Operator]]></description><guid>http://www.sqlservercentral.com/scripts/pivot/66954/</guid><pubDate>2009/06/05</pubDate><link>http://www.sqlservercentral.com/scripts/pivot/66954/</link></item><item><title>Simple Crosstab Procedure with Power</title><description><![CDATA[Create crosstab queries as easily as MS Access with a lot more power.]]></description><guid>http://www.sqlservercentral.com/scripts/Crosstab/66452/</guid><pubDate>2009/05/05</pubDate><link>http://www.sqlservercentral.com/scripts/Crosstab/66452/</link></item><item><title>Dynamic table not imposible</title><description><![CDATA[I needed to display my data in columns but could not use pivots or cross tables because it wasn't a fix amount of columns. so I created this script, I hope is useful.]]></description><guid>http://www.sqlservercentral.com/scripts/T-SQL/65735/</guid><pubDate>2009/02/20</pubDate><link>http://www.sqlservercentral.com/scripts/T-SQL/65735/</link></item><item><title>The Ultimate Index Width Stats Reporter</title><description><![CDATA[Reports index length stats for indexes who's lengths exceeding parametrized thresholds (defaults to 0 - get all) for total length and seek length, optionally filtering schemas and tables.<!-- SQL Server monitoring made easy -->
<table border="0" cellpadding="0" cellspacing="10" width="100%">
 <colgroup>
  <col width="68" />
  <col width="1266" />
 </colgroup>
 <tr align="left" valign="top">
  <td><a href="http://www.red-gate.com/products/SQL_Response/offers/easy_monitoring.htm?utm_source=ssc&utm_medium=rss&utm_content=easy_monitoring200912&utm_campaign=sqlresponse"><img alt="SQL Response" height="68" src="http://www.red-gate.com/images/marketing/SSC/response_ico.gif" width="68" border="0"/></a></td>
  <td><strong>SQL Server monitoring made easy </strong><br />"Keeping an eye on our many SQL Server instances<br> is much easier  with SQL Response." Mike Lile.<br><a href="http://www.red-gate.com/products/SQL_Response/offers/easy_monitoring.htm?utm_source=ssc&utm_medium=rss&utm_content=easy_monitoring200912&utm_campaign=sqlresponse">Download a free trial of SQL Response now. </a><img src="/Images/spacer.gif?d=ad_olr1"/></td>
 </tr>
</table>]]></description><guid>http://www.sqlservercentral.com/scripts/T-SQL/65598/</guid><pubDate>2009/01/28</pubDate><link>http://www.sqlservercentral.com/scripts/T-SQL/65598/</link></item><item><title>Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs</title><description><![CDATA[In Part 1, we learned how to make both Cross-Tabs and Pivots. In Part 2, we'll learn how to automate a very common type of Cross-Tab report and maybe learn some extra tricks on the way.]]></description><guid>http://www.sqlservercentral.com/articles/Crosstab/65048/</guid><pubDate>2008/12/03</pubDate><link>http://www.sqlservercentral.com/articles/Crosstab/65048/</link></item><item><title>The Ultimate Prospective-Index Column(s) Selectivity Analyzer</title><description><![CDATA[Gets single-column and cumulative-column selectivity stats and @Top largest dupe sets for each cumulative column stepping for a set of one or more columns for a table.]]></description><guid>http://www.sqlservercentral.com/scripts/Index+Management/63936/</guid><pubDate>2008/10/24</pubDate><link>http://www.sqlservercentral.com/scripts/Index+Management/63936/</link></item><item><title>The Ultimate Duplicate Index Finder</title><description><![CDATA[Searches database-wide for multiple indexes in the same table which has the same column as the first seek key.  Optionally limits to LIKE wildcard patterns of table and schema names.]]></description><guid>http://www.sqlservercentral.com/scripts/Index+Management/63935/</guid><pubDate>2008/10/17</pubDate><link>http://www.sqlservercentral.com/scripts/Index+Management/63935/</link></item><item><title>The Ultimate Index Usage Reporter</title><description><![CDATA[Reports index stats, index size+rows, member seek + include columns as two comma separated output columns, and index usage stats for one or more tables and/or schemas.]]></description><guid>http://www.sqlservercentral.com/scripts/Index+Management/63934/</guid><pubDate>2008/10/13</pubDate><link>http://www.sqlservercentral.com/scripts/Index+Management/63934/</link></item><item><title>Demonstration on how to pivot data using temp tables </title><description><![CDATA[This script was designed to 'pivot' data that couldnt easily be pivoted in any other way. i used temporary tables to eventually achieve the result i was looking for :)]]></description><guid>http://www.sqlservercentral.com/scripts/Dynamic+SQL/64607/</guid><pubDate>2008/10/10</pubDate><link>http://www.sqlservercentral.com/scripts/Dynamic+SQL/64607/</link></item><item><title>The Ultimate Index Lister (Pivoted)</title><description><![CDATA[Lists details for all indexes on one or more tables / schemas, including row count and size. This version outputs the member seek + include columns as two comma separated output columns.<!-- SQL Server monitoring made easy -->
<table border="0" cellpadding="0" cellspacing="10" width="100%">
 <colgroup>
  <col width="68" />
  <col width="1266" />
 </colgroup>
 <tr align="left" valign="top">
  <td><a href="http://www.red-gate.com/products/SQL_Response/offers/easy_monitoring.htm?utm_source=ssc&utm_medium=rss&utm_content=easy_monitoring200912&utm_campaign=sqlresponse"><img alt="SQL Response" height="68" src="http://www.red-gate.com/images/marketing/SSC/response_ico.gif" width="68" border="0"/></a></td>
  <td><strong>SQL Server monitoring made easy </strong><br />"Keeping an eye on our many SQL Server instances<br> is much easier  with SQL Response." Mike Lile.<br><a href="http://www.red-gate.com/products/SQL_Response/offers/easy_monitoring.htm?utm_source=ssc&utm_medium=rss&utm_content=easy_monitoring200912&utm_campaign=sqlresponse">Download a free trial of SQL Response now. </a><img src="/Images/spacer.gif?d=ad_olr1"/></td>
 </tr>
</table>]]></description><guid>http://www.sqlservercentral.com/scripts/Index+Management/63931/</guid><pubDate>2008/10/09</pubDate><link>http://www.sqlservercentral.com/scripts/Index+Management/63931/</link></item><item><title>PIVOT working incorrectly?</title><description><![CDATA[One developer's journey through PIVOTing incorrectly.]]></description><guid>http://www.sqlservercentral.com/articles/pivot/62808/</guid><pubDate>2008/05/13</pubDate><link>http://www.sqlservercentral.com/articles/pivot/62808/</link></item></channel></rss>