Zero Sperm

My husband and I just found out he had zero sperm count. Our urologist appointment isn't until January 5, so I'm doing as much research as possible before then. We're any of you successful with a pregnancy after this diagnosis? Any suggestions as we begin this journey?