Software Development Blog

Sample of Pivot SQL

Tuesday, 06 April 2010 14:16 Ajay Majgaonkar Software Development - SQL

As a part of reporting, my friend faced a simple looking problem. He was struggling for almost half a day to solve this by a SQL query. When he showed me the problem, I just realized that it is something that we usually do in excel called pivot tables and I asked him to look over the internet if there is something called "pivot query" and to our surprise there is something called as that...we just didn't know, so I am going to document it.

( 0 Votes )

Write comment (0 Comments)

Last Updated on Monday, 19 April 2010 17:52 Read more...

Custom generation of identity values in SQL Server

Monday, 11 May 2009 06:13 Roopmay Roy Software Development - SQL

An identity column in SQL Server creates an auto-incrementing numeric sequence of values. When an insert is made into a table with an identity column, a value does not need to be put in the identity column. The value of the identity column is automatically filled in.

Identity columns are used when it is required to automatically number each row as it comes into the table. The identity column’s seed (starting value) and increment can be set at the time of creation of the identity column. So every time a row is added to the table it is assigned a number obtained by adding the increment to the old value (this value will be the seed for the first row)