Home changing step in the loop T-SQL
 Hello. I have some trouble. I have a table with dates for 4 years. I need to run loop through it using a day value = 7, month value = 30 and years = 365. How can I change this value inside the loop? WHILE @start_date <= @finish_date BEGIN -- SOME ALGORITHM SET @start_date = @start_date + 1 END  I would like to get changing value @start1 = 7 + 1; @start1 = 30 + 1 and @start1 = 365 + 1. I think it's possible, but I haven't any idea (haven't any working idea at the moment) I was trying to use CASE construction, but when I ran it - my DBeaver application was shut down immediately.