Why you should not spend money on expensive cars

SELECT ChannelSubClassAltDesc,SUM(CASE WHEN fact.currencytypehierarchyid = 5 THEN BudgetAmount END)*(-1) as BudgetAdjAmtCD,SUM(CASE WHEN fact.currencytypehierarchyid = 3 THEN BudgetAmount END) * (-1) as BudgetAdjAmtUSD–,SUM(CASE WHEN fact.currencytypehierarchyid = 4 THEN BudgetAmount END) * (-1) as BudgetAdjAmtLCFROM [MARS].dbo.vwFactIncomeStatementBudgetALTRestricted Fact (NOLOCK)JOIN [MARS].[dbo].[FinancialAccountAlt] FAON Fact.[FinancialAccountAltId]= FA.[FinancialAccountAltId]JOIN [Mars].[dbo].[ChannelSubClassAlt] CC ON CC.ChannelSubClassAltID = FA.ChannelSubClassAltID JOIN [MARS].dbo.productfamilyAlt PFAM (NOLOCK)ON PFAM.productfamilyAltid =fact.productfamilyAltidJOIN [MARS].[dbo].[FiscalMonth] FiscalMo83ON Fact.[FiscalMonthID]=FiscalMo83.[FiscalMonthID]JOIN… Read more