recurring sequences

folks

i have a sequence on plans

item      interval
plan1      1
plan2      3
plan3      5

the interval shows after which turn the plan is to be performed, for example a car service
,i would like to to display the output in its sequence, plan2 will occur on the 3rd time when the service is due and plan 3 the 5th time is due like so

plan1
plan1
plan2
plan1
plan3
plan1
plan1
plan2
plan1
plan3

how do i build this in a query?

rutgermonsAsked:
Who is Participating?
 
awking00Connect With a Mentor Commented:
See attached. This one wasn't easy.
plans.txt
0
 
awking00Commented:
Do you want the results in a table or just as the results of a select statement? How far do you want these sequences to go and what might determine that?
0
 
rutgermonsAuthor Commented:
well id l,ike to have input the amount of times i want to output it as a variable

,just the results in a select will be great thanks

im assume a mod function could assist this feature
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
rutgermonsAuthor Commented:
any feedback on this?

tia

roger
0
 
rutgermonsAuthor Commented:
super,thank u
0
 
awking00Commented:
You're quite welcome.
0
All Courses

From novice to tech pro — start learning today.