I know when we talk about the pivoting & unpivoting the data then most of the time we are making our faces and we feel it would be a tough task. Trust me after reading this post you feel unpivot is super easy. Before jumping directly into unpivot want to share pivot link to take … Continue reading How easily you can unpivot the pivot data in SQL Server?
In the series of step by step SSIS learning, this is another interesting article. In this article we will try to implement PIVOT transformation in few easy steps. Let’s understand the PIVOT by below example. Suppose, you have a salary data of employee as shown below. Employee Name Salary($) Year Sandeep 110000 2016 Sunil 120000 … Continue reading Why Do People Think Learn Step by Step PIVOT Transformation is a Good Idea ? TIP #125
Hello friends, We have left the last topic with definition of Pivot Viewer now in this post we are going to make a sample which use pivot viewer. Our sample is “Cricket World Cup 2011” so here we go Step 1:- First checks on your machine following things are installed if not then please installed … Continue reading Pivot Viewer Example ” Cricket World Cup 2011″
Hi Folks, Sorry for such a late post. I know you were waiting for the new post from last 2 week. So here I am with a new interesting area which will help in data visualization. “Pivot Viewer” control is great tool supported by Silverlight 4. I know that I am bit late to explore … Continue reading What is Pivot Viewer in Silverlight 4?
Hello friends, Today I will explain you how to use pivot table. It’s very useful. For example just take a look on below statements DECLARE @tblTest AS TABLE (strName VARCHAR(50), fltTotalAmount DECIMAL(10,3), intMonth TINYINT, intYear INT) INSERT INTO @tblTest (strName, fltTotalAmount, intMonth, intYear) VALUES (‘RAJAT’, ‘10000’,1,2006) INSERT INTO @tblTest (strName, … Continue reading Pivot in SQL SERVER
Learn & Share ASP.NET & SQL SERVER 