jeudi 1 décembre 2016

recurring condition blocks SQL

I want to create a recurring IF ELSE or FOR LOOP condition blocks as per below conditions

I have a "created Date" column in a Data Table

I want to implement below condition

0-5 days from created date  
print text1  
6-10 from created date   
print text2  
11-15   
print text3  
16-20   
print text4  
21-25  
print text1  
26-30  
print text2  

and so on..
so after 20 days 1st text gets gets printed again and like that for 4 set of text after every 5 days.

Aucun commentaire:

Enregistrer un commentaire