procedure for inserting rows
dear members,
i have a table with some missing numbers in a col1.
how can i add rows containing missing numbers.
starting and ending number is given in the procedure.
let us say starting from 1 to 10.
table
id col1
1 2
2 3
3 4
4 9
Required Result after running the procedure.
table
id col1
1 2
2 3
3 4
4 9
5 1
6 5
7 6
8 7
9 8
10 10
can i have that procedure.
regards
teefu.
Edited by: user_teefu on Aug 23, 2010 2:19 PM