T-SQL - Generate rows from Field with Number

Question

I have a Table with the following Fields:

----------------------------------------
| Start Date        | Recurrences      |
----------------------------------------
| 01-01-2015        | 12               |
----------------------------------------
| 01-06-2015        | 10               |
----------------------------------------

What I need to output is a total of 22 rows (12 + 10). Each row should contain the 'Start Date' field plus the increment of days depending on which recurrence.

I was able to generate a number of rows with an increment using this table of SQL Server:

SELECT 
    DISTINCT n = number 
FROM 
    master..[spt_values] 
WHERE 
    number BETWEEN 1 AND 1000

But what I need is to trigger this select per each row of my table and set the MAX to Recurrences field and not to 1000

Luaan · Accepted Answer · 2015-08-05 08:36:41Z

2

Since you're multiplying, a simple inner join should do:

select
 Number,
 StartDate
from YourTable
inner join master..[spt_values] on number between 1 and YourTable.Recurrences

answered Aug 5, 2015 at 8:36

Luaan

64.1k7 gold badges108 silver badges126 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Raffaeu Over a year ago

So easy ... I think I need more coffe. Thanks work perfect

Collectives™ on Stack Overflow

T-SQL - Generate rows from Field with Number

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related