As a developer, when working with a database the need to script data often arises, especially if only a subset of the data is changed or added to a table in your Development environment. The new or changed data will need to be added to your Test and/or Production environment at some point or sent to a client. In my case, I was dealing with a number of rule tables in a SQL Server 2005 database that had new records add which needed to be applied to our Test environment.

On this post, I will talk about how to create a dynamic Pivot Table. As you may know the "Pivot" statement is a data summarization tool that can be used in order to analyze specific information. The Pivot Table is very common on BI Tools such as Microsoft Reporting Services. The first step would be creating the headers that will be used for our Pivot Table. Because the Pivot Table I am creating is dynamic the columns have to be created first. In order to do that, I will create a table that will have all the months.

We deliver the complete integration and development of sales, marketing and customer service technologies. TopLine Strategies’ project management is designed to achieve 100 percent user adoption of the technologies implemented, and deliver measurable returns on investment for clients.

Whether our clients are searching for an expert firm to analyze and execute a critical project, employees to augment an information technology team or contractors to assist with technology needs, we deliver on-time, cost-effective solutions that optimize client results. Over the years, our methods have remained the same: establish long-term relationships, assess requirements, research and analyze options, recommend appropriate solutions, implement, integrate and optimize performance.

We deliver the complete integration and development of sales, marketing and customer service technologies. TopLine Strategies’ project management is designed to achieve 100 percent user adoption of the technologies implemented, and deliver measurable returns on investment for clients.

Whether our clients are searching for an expert firm to analyze and execute a critical project, employees to augment an information technology team or contractors to assist with technology needs, we deliver on-time, cost-effective solutions that optimize client results. Over the years, our methods have remained the same: establish long-term relationships, assess requirements, research and analyze options, recommend appropriate solutions, implement, integrate and optimize performance.