• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 382
  • 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
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

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