For example, if I had a table named “Periods”, with column (type:date)
Would I be able to make a stored procedure, where given (date), i will add an entry to the table for every 2 weeks from the given date, until it reaches lets say 10 weeks?
So If i enter like July 1st, it will add table entries that are, July 15th, July 30th , something like that?
could this be accomplished in SQL maybe in a stored procedure or just with queries? or am I better off writing something like a trigger/ api
I see that there are options, but I see that loops are frowned upon in SQL? wondering if there is a good solution to this problem