>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, > >