select id
  , FirstDay, LastDay, RequestedOn, TotalDays, LeaveCode, ReasonCode, Department
  , [Location], Recalled, UserId, AccountingSystemEmpNo
  , REPLACE(Comments, CHAR(13), '|') AS Comments
  , Exported, LeaveTypeDescription, EmployeeName
  , JobNo
from LeaveRequest
ORDER BY id desc