InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 13:45:10 GMT20http://www.sqlservercentral.com/Forums/Topic1407061-392-1.aspx[quote][b]imfairozkhan (1/15/2013)[/b][hr]data what i havedivision 2012 2013 2016xyz 1 0 10abcd 11 1 9lmn 9 4 11regards[/quote]I think I speak from experience when I say that people here really want to help you. However we're all volunteers. So to get good, tested code you really need to follow the guidelines that are in the article link that I posted. You have not, which leads me to believe you didn't read it.Tue, 15 Jan 2013 02:08:08 GMTdwain.chttp://www.sqlservercentral.com/Forums/Topic1407061-392-1.aspxdata what i havedivision 2012 2013 2016xyz 1 0 10abcd 11 1 9lmn 9 4 11regardsTue, 15 Jan 2013 02:03:46 GMTimfairozkhanhttp://www.sqlservercentral.com/Forums/Topic1407061-392-1.aspxHi there!You've given us your expected results, but we need some DDL and test data to show you how to get them.This article provides excellent guidelines: [url=http://www.sqlservercentral.com/articles/Best+Practices/61537/]Forum Etiquette: How to post data/code on a forum to get the best help[/url]Tue, 15 Jan 2013 01:34:21 GMTdwain.chttp://www.sqlservercentral.com/Forums/Topic1407061-392-1.aspxhi all,how do i achieve this resultdivision 2012 2013 2014 2015 2016xyz 1 0 0 0 10abcd 11 0 0 0 9lmn 3 0 0 0 5i have data for year 2012 and 2016 there is no data for 2013,2014,2015.please help me achieve this.any help is highly appreciated.regardsfairozkhanTue, 15 Jan 2013 01:01:01 GMTimfairozkhan