case dbo.ChargeReportLog.ChargeType when 'I' then COALESCE((select coInv.primedesc from dbo.coinv where coinv.invid=dbo.ChargeReportLog.invID), (select coCaseData.ManualDesc from dbo.CoCaseData where coCaseData.Meetingnumber=meetings.Meetingnumber and coCaseData.CaseDataID=ChargeReportLog.CaseDataID)) else (select description from dbo.coProc where coProc.procID=dbo.ChargeReportLog.InvID) end as PrimeDesc,