SELECT
  CR.ChangeRequestID,
  CR.ChangeRequestName,
  CR.ChangeRequestDescription,
  CR.BusinessBenefit,
  CR.Outcome,
  CR.RequestedByID,
  U1.FullName AS CreatedBy,
  LEFT(CreateDate, 10) AS CreateDate,
  LEFT(LastChangeDate, 10) AS LastChangeDate,
  CR.ChangeRequestCategoryID,
  CR.ChangeRequestStatusID,
  CR.Priority,
  CR.Estimate,
  CR.ActualHours,
  CR.IsBugFix,
  @pNavFields
FROM
  taChangeRequest AS CR
LEFT JOIN taUsers AS U1 ON (U1.UserID = CR.CreatedByID)
WHERE
  CR.ChangeRequestID = @nChangeRequestID