PIVOTING #28 In the following example, age,ORIG_POST_DATE is the date a charge was posted, age.POST_DATE is the dote a charge was extracted as still outstanding, and age. AMOUNT is the amount of the charge in dollars. SQL Server: SUM( CASE WHEN DATEDIFF( doy, age,ORIG_POST_DATE, Oge.POST_DATE )