Viewing post 31 (of 31 total)
you could take what theSQLGuru wrote and make it generalizable for all years with Datepart functions.
select sum(case when datepart(mm,Invoice_date)=1 then Total_Amount else 0 end ) as Jan,
sum(case...
December 4, 2009 at 10:01 am
#1087864