Home » SQL & PL/SQL » SQL & PL/SQL » filling up missing records query
filling up missing records query [message #204944] Wed, 22 November 2006 15:15 Go to next message
jinga
Messages: 115
Registered: January 2003
Senior Member

ICODE     MTH     LINE  CATEGORY

I1      200512     1    B
I1      200512     2    C
I1      200603     1    A
I1      200604     1    A



i want my result set as



icode    mth    line       category
I1      200512     1         B
I1      200512     2         C
I1      200601     1         B
I1      200601     2         C
I1      200602     1         B
I1      200602     2         C
I1      200603     1         A
I1      200604     1         A
I1      200605     1         A



Please help me with this query. Please see records '200601' & '200602' made up from '200512'. A record for '200605' is made up from '200604'.




Re: filling up missing records query [message #204996 is a reply to message #204944] Thu, 23 November 2006 00:30 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
search this board for row generator.
Previous Topic: How to execute unicode format SQL script
Next Topic: delete clause
Goto Forum:
  


Current Time: Sat Dec 03 01:34:57 CST 2016

Total time taken to generate the page: 0.16266 seconds