CODEWITHSUNDEEP
sqlloops
user13624923
user13624923

Reputation: 13

Inserting Multiple of same records into SQL temp table based on value in column

So I have table with the following records:

Source table

I want to create a script to iteratively look at the Cnt_Repeat column and insert that same record in a temp table X times depending on the value in Cnt_Repeat so it would look like the following table:

Table of results

Upvotes: 0

Views: 43

Answers (1)

Gordon Linoff
Gordon Linoff

Reputation: 1271151

One method supported by most databases is the use of recursive CTEs. The exact syntax might vary, but the idea is:

with cte as (
      select loannum, document, cnt_repeat, 1 as lev
      from t
      union all
      select loannum, document, cnt_repeat, lev + 1
      from cte
      where lev < cnt_repeat
     )
select loannum, document, cnt_repeat
from cte;

Upvotes: 1

Related Questions