Monthly Archives: April 2012

Derived Table In Sql Server

By | April 15, 2012

Derived tables:-  Derived tables are the tables which are created on the fly with the help of the Select statement. It is different from the temporary table in the way that  in case of temporary table, first we have to create a temporary table,  insert the data into the table, select the data from the temporary table and… Read More »

Pivot and Unpivot table in SQL SERVER

By | April 14, 2012

Pivot Table:- Pivot tables are used to summarize and display the data, specially in case of report data by means of aggregating the values. Pivot table can be used if we want to display the unique values of the column of a table as the columns of another table. It turns the unique values of a specified… Read More »