SELECT
  IL.CMSInvNo,
  IL.CMSLineNo,
  IL.DocumentNumber,
  IH.AppointmentID,
  IL.GLAccount,
  IL.Description,
  IL.BranchRegion,
  IL.ProductCategory,
  IL.TaxRate AS VATRate,
  (IL.TaxRate * 100.0) AS VATRatePercentage,
  IL.LineQuantity,
  IL.UnitPriceExcl,
  IL.UnitPriceIncl,
  IL.ExclusivePrice,
  (IL.ExclusivePrice * IL.TaxRate) AS VAT,
  IL.InclusivePrice
FROM
  taInvoiceLine AS IL
    INNER JOIN taInvoiceHeader AS IH ON (IH.CMSInvNo = IL.CMSInvNo)
WHERE
  1
  @pCMSInvNo
ORDER BY
  IL.CMSInvNo,
  IL.CMSLineNo


