[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 379
  • Last Modified:

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?

0
rutgermons
Asked:
rutgermons
  • 3
  • 3
1 Solution
 
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
 
rutgermonsAuthor Commented:
any feedback on this?

tia

roger
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 
awking00Commented:
See attached. This one wasn't easy.
plans.txt
0
 
rutgermonsAuthor Commented:
super,thank u
0
 
awking00Commented:
You're quite welcome.
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now