Example: Cumulative Weekday Sales during First Week of All Quarters - Teradata Calendar - 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;

Sales_Tbl:

Jan 2009 Calendar: