Monthly Archives: October 2012

Recently we came across one scenario in our project where we have to decide best option to store spreadsheet data in the database. we have finalized four options and out of those options one is to store the data in … Continue reading

Posted on by Suril Patel | Leave a comment

Pivoting in SQL

This post has good example of using PIVOT to get the row data in column format. http://beyondrelational.com/modules/2/blogs/88/Posts/14196/changing-rows-to-columns-using-pivot-dynamic-columns-for-pivoting-in-sql-server.aspx Here is example created by taking reference of this. create table #table(tid int,tname varchar(10)) create table #column(cid int,tid int,cname varchar(10)) create table #data(tid … Continue reading

Posted in SQL | Leave a comment