const vendorResult: IResult<GPVendor> = await pool
    .request()
    .input('vendorId', vendorId).query(`SELECT top 1
      rtrim(VENDORID) as vendorId,
      rtrim(VENDNAME) as vendorName,