Advertisements I have a SQL query like SET THIS_YEAR_END = ‘2022-11-01’; SET THIS_YEAR_START = DATEADD(DAY, -4*7+1, $THIS_YEAR_END); SET LAST_YEAR_END = ‘2021-11-02′; SET LAST_YEAR_START = DATEADD(DAY, -4*7+1, $LAST_YEAR_END); select end_date from ( select * from data where DATE>= DATEADD(DAY, -27 * 7, $LAST_YEAR_START)) AND END_DATE BETWEEN CUST.END_DATE – 26 * 7 AND CUST.END_DATE – 7 I’m… Read More unable to understand the dateadd function in SQL

Advertisements I’m not an expert of ANSI SQL and I need to write the following query. This is the table from which I start: ID Max_Recurrency Priority abc 2 1 abc 2 450 abc 2 12 def 1 827 def 1 44 def 1 112 ghi 2 544 ghi 2 4 ghi 2 95 ghi… Read More Select a record a variable number of times based on two different fields on the same table