I am trying to set up an automatic city of the week for a coupon, but there are more than 52 or 53 cities, so I would like to set up a cycle that repeats after the last city is reached.
I have a table with two columns (CityID as int, Identity) and (CityName as varchar(50))
If I have 100 cities, I want to be able to cycle through all 100 cities, but only every seven days beginning on Sundays.
1. Should I rather set up a date column?
2. How would I set this up since week dates change from year to year, and I want it to be a maintenance free recurring event (maybe adding cities as my service area increases)
3. should I rather have multiple cities and say have 2 cities of the week to maintain a 52 week annual cycle?
Setting up a monthly cycle was easy, but there is no coding for weeks, just seconds, minutes, hours, days, months, and years
I am doing this in VB for now, until I finish learning C# I ...
Go to the complete details ...