We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
here is a snippet of my code --incoming in_eff_date: 1991-01-16 --incoming in_term_date: 1999-12-31 CURSOR cs_overlapping_dates IS SELECT 'x' FROM subscriber_group where group_nbr = in_group_nbr AND section_id = in_section_id AND lob_code = in_lob_code AND cvg_nbr = in_cvg_nbr AND participant_type_code = g_participant_type_cardholder AND ((in_eff_date BETWEEN eff_date AND term_date) OR (in_term_date BETWEEN eff_date AND term_date)); --end snippet OUTPUT of this is when code ran: l_dummy1 (this is incorrect because the eff_date of the record in the subscriber table is 1/15/1991 and the term date is 12/31/1999. I should be seeing 'x' indicating a record has been found)
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.