Example: Cumulative Weekday Sales During First Week of All Quarters - Teradata Calendar - Analytics Database - Teradata Vantage

This example finds cumulative sales of an item during weekdays of the first week of all quarters.

SET SESSION calendar = Teradata;
/* Setting SUNDAY and SATURDAY as weekend days. */
exec dbc.createbusinesscalendarpattern('teradata','SUNDAY','OFF',);
exec dbc.createbusinesscalendarpattern('teradata','SATURDAY','OFF',);
SEL Item_Code, SUM(Sale_Amt) FROM Sales_Tbl,
       Sys_Calendar.BusinessCalendar
WHERE WeekNumber_Of_Quarter(Sale_Date) = 1
AND calendar_date = Sale_Date
AND IsBusinessDay  = 1
GROUP BY Item_Code
ORDER BY 1;

SET SESSION calendar = Teradata;