Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.
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)
Join the community of 500,000 technology professionals and ask your questions.