InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 19:12:51 GMT20http://www.sqlservercentral.com/Forums/Topic1398947-391-1.aspxTHANKS MEN!Thu, 20 Dec 2012 07:01:04 GMTdavdam8http://www.sqlservercentral.com/Forums/Topic1398947-391-1.aspxUse a CASE expression in your SUM statement, something like this:[quote]...SUM(CASE WHEN Year = 2010 THEN Amount ELSE 0 END) AS Total2010,SUM(CASE WHEN Year = 2011 THEN Amount ELSE 0 END) AS Total2011...[/quote]Alternatively, you could use PIVOT. Or you could write a report in Reporting Services to display your data in the way you need.JohnThu, 20 Dec 2012 06:52:25 GMTJohn Mitchell-245523http://www.sqlservercentral.com/Forums/Topic1398947-391-1.aspxHi geniuses!I have this query[code="xml"]SELECT DISTINCT chapter, Sum(dbo.FGG.Value) AS FGG2010FROM FGG WHERE (FGG.YEAR= 2010) and (dbo.FGG.valueType = '02 - FGG01l') Group by chapter[/code]It retrieves : chapter | FGG2010 A | 1$ B | 2$ C | 3$What I want is to add in 'Sum(dbo.FGG.Value) AS FGG2011' where FGG.YEAR=2011 in the same query, in order to retrive:chapter | FGG2010 | FGG2011 A | 1$ | 2$ B | 2$ | 33$ C | 3$ | 11$Thanks in advance!RegardsThu, 20 Dec 2012 06:39:56 GMTdavdam8