Fresh details have emerged after a couple tragically died in a motel room after partying at a nightclub. Just hours before, they had been celebrating their little girl's birthday