InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 21:27:38 GMT20http://www.sqlservercentral.com/Forums/Topic1381003-391-1.aspxTry this, unpivot logic:CREATE TABLE #Amt(Id INT, Monthly Float,Quaterly Float,HealfYearly Float,Yearly Float)INSERT INTO #Amt (Id ,Monthly ,Quaterly ,HealfYearly ,Yearly )VALUES (1,100,200,400,800),(2,200,400,600,900)--SELECT * FROM #Amt SELECT ID, PaymentTerm, Amount FROM ( SELECT Id ,Monthly ,Quaterly ,HealfYearly ,Yearly FROM #Amt ) p UNPIVOT (Amount FOR PaymentTerm IN ( Monthly, Quaterly, HealfYearly, Yearly ) )AS unpvtDROP TABLE #AmtMon, 05 Nov 2012 07:05:13 GMTdeepkthttp://www.sqlservercentral.com/Forums/Topic1381003-391-1.aspxWhat about[code]SELECT USERID, 'Monthly' as [PERIOD], SUM([MONTHLY] As [PERIOD_TOTAL]UNIONSELECT USERID, 'Quaterly' as [PERIOD], SUM([Quaterly] As [PERIOD_TOTAL]UNIONSELECT USERID, 'HealfYearly' as [PERIOD], SUM([HalfYearly] As [PERIOD_TOTAL]UNIONSELECT USERID, 'Yearly' as [PERIOD], SUM([Yearly] As [PERIOD_TOTAL][/code]HTH,BMon, 05 Nov 2012 05:14:26 GMTbleroyhttp://www.sqlservercentral.com/Forums/Topic1381003-391-1.aspxHi,I have one Table Userid Monthly Quaterly HalfYearly Yearly----------------------------------------------------1 30.00 0.00 0.00 0.002 0.00 300.00 0.00 0.00I want display the data in gridview based on above table.User PaymentTerm Amount--------------------------------Raja Monthly 30.00Ram Quaterly 300.00what is the query for aboveMon, 05 Nov 2012 05:09:34 GMTsidharthgs6