SELECT
  BranchID,
  BranchRegion,
  BranchName,
  TrackingCategory,
  Status,
  BranchManagerID,
  ProvinceID,
  Longitude,
  Latitude,
  @pNavFields
FROM
  taBranches
WHERE
  (BranchID = @nBranchID)