Viewing 2 posts - 1 through 2 (of 2 total)
I got it. Here is the recursive solution to add 4 rows per each original row
with org as
(SELECT * FROM (VALUES (1, 'EXO',3 ),(7, 'SPO',4 ),(15, 'LYO',10)) AS X...
January 26, 2015 at 2:40 pm
#1773240
I implemented similar task in PLSQL with functions 'lag' and 'lead' to generate recursively ids between sorted ids current row and next row.
Could not find them in 2008 MSSQL... So...
January 26, 2015 at 7:53 am
#1773114