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: 116
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'.

Report message to a moderator

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: 7901
Registered: March 2000
Senior Member
search this board for row generator.

Report message to a moderator

Previous Topic: How to execute unicode format SQL script
Next Topic: delete clause
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 05 14:02:03 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.