We help IT Professionals succeed at work.

recurring sequences

rutgermons
rutgermons asked
on
389 Views
Last Modified: 2013-12-18
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?

Comment
Watch Question

awking00Information Technology Specialist
CERTIFIED EXPERT

Commented:
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?

Author

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

Author

Commented:
any feedback on this?

tia

roger
Information Technology Specialist
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
super,thank u
awking00Information Technology Specialist
CERTIFIED EXPERT

Commented:
You're quite welcome.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.