Mr. Worf, I Always Knew This Day Would Come
Embed

Picard: Mr. Worf, I always knew this day would come. Are you prepared to face the charges?
Troi: Answer him.
Worf: I am prepared.
Picard: "We the officers and crew of the U.S.S. Enterprise, "being of sound mind and judgment, "hereby make the following charges against Lieutenant Worf. "One: that he did knowingly "and willfully "perform above and beyond the call of duty "on countless occasions. "Two: most seriously, "that he has earned the admiration and respect of the entire crew."
Picard: Mr. Worf, I hereby promote you to the rank of lieutenant commander, with all the rights and privileges thereto. And may God have mercy on your soul.

78 years after Jim disappears from the Enterprise-B, another Enterprise crew celebrates a promotion aboard a sailing ship, also named the USS Enterprise.