Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone!!!
I ave following records.
Emp no. name start_date end_date grade
1 rhv 01-Jan-10 31-Mar-10 M1
1 rhv 01-Apr-10 30-Apr-10 M2
1 rhv 01-May-10 31-Dec-10 M3
2 abc 01-Mar-10 31-May-10 M1
2 abc 01-Jun-10 30-Jun-10 M2
I want to generate records for each month from above range of start date & end date i.e.
Emp no. name start_date end_date grade INTERMIDATEMONTH
1 rhv 01-Jan-10 31-Mar-10 M1 JAN-2010
1 rhv 01-Jan-10 31-Mar-10 M1 FEB-2010
1 rhv 01-Jan-10 31-Mar-10 M1 MAR-2010
1 rhv 01-Apr-10 30-Apr-10 M2 APR-2010
1 rhv 01-May-10 31-Dec-10 M3 MAY-2010
1 rhv 01-May-10 31-Dec-10 M3 JUN-2010
1 rhv 01-May-10 31-Dec-10 M3 JUL-2010
1 rhv 01-May-10 31-Dec-10 M3 AUG-2010
1 rhv 01-May-10 31-Dec-10 M3 SEP-2010
1 rhv 01-May-10 31-Dec-10 M3 OCT-2010
1 rhv 01-May-10 31-Dec-10 M3 NOV-2010
1 rhv 01-May-10 31-Dec-10 M3 DEC-2010
2 abc 01-Mar-10 31-May-10 M1 MAR2010
2 abc 01-Mar-10 31-May-10 M1 APR2010
2 abc 01-Mar-10 31-May-10 M1 MAY2010
2 abc 01-Jun-10 30-Jun-10 M2 JUN2010