hi there,
am new to SQL and now am trying to do row split.
e.g currently i have two group of record sets in the table like this below.
id records keys date
1 196 100 1/2/2000
2 49 100 2/7/2000
so now all i want is split this 2 rows into multiple rows. if i have "chunk_row_size" variable =50 then i want to split it to 5 rows instead of 2.
output should like this below.
id records keys date
1 50 100 1/2/2000
2 50 100 1/2/2000
3 50 100 1/2/2000
4 46 100 1/2/2000
5 49 100 2/7/2000
any idea/scripts will be appreciate !
thanks!!