SELECT
  PH.PhoneCallID,
  PH.InovoCallID,
  PH.InovoCaller,
  PH.InovoAgent,
  PH.InovoQCode,
  PH.InovoRecordingID,
  PH.ContactID,
  PH.ContactName,
  PH.ContactPosition,
  PH.ContactEmail,
  PH.DateTimeInitiated,
  PH.DateTimeConcluded,
  PH.PhoneCallTypeID,
  TIMESTAMPDIFF(MINUTE,PH.DateTimeInitiated,PH.DateTimeConcluded) AS Duration,
  PH.ConsultantID,
  PH.ClientID,
  PH.ProductID,
  PH.ClientProductID,
  PH.ClientBranchID,
  PH.ClientBranchProductID,
  PH.AttendanceTypeID,
  PH.AttendanceSubTypeID,
  PH.AppointmentID,
  PH.Particulars
FROM
  taPhoneCall AS PH
WHERE
  @pCallID
