My problem is this: given a book id (4 - Numbers), a chapter number (2) and a verse number (3), produce the 51st letter, or at least the word in which the 51st letter resides, and a total of word lengths up to that word.
/* book chapter verse word_link word ==== ======= ===== ========= ==== id ------+ id -------+ id --------+ id +--- id - PK chapter +----> book_id +---> chapter_id +--> verse_id | word book chapter_num verse_num word_id <--+ length I can reproduce a list of words and their lengths, given a book ("Ezra"), a chapter number (2) and a verse number (3): PARAMETERS [@BOOK_NAME] Text ( 255 ), [@CHAPTER] Long, [@VERSE] Long; SELECT verse.id AS verse_id, chapter.chapter, verse.verse, word.word, word.length FROM word INNER JOIN (((book INNER JOIN chapter ON book.id=chapter.book_id) INNER JOIN verse ON chapter.id=verse.chapter_id) INNER JOIN word_link ON verse.id=word_link.verse_id) ON word.id=word_link.word_id WHERE (book.book=[@BOOK_NAME] Or book.called=[@BOOK_NAME]) And chapter.chapter=[@CHAPTER] And verse.verse=[@VERSE]; */
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
When asked, what has been your best career decision?
Deciding to stick with EE.
Being involved with EE helped me to grow personally and professionally.
Connect with Certified Experts to gain insight and support on specific technology challenges including:
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE