October 23, 2019 at 3:30 pm
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!!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply