Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: How to add missing IDs in a SQL table?

    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...

  • RE: How to add missing IDs in a SQL table?

    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...

Viewing 2 posts - 1 through 2 (of 2 total)