If you’d like to get the total number of rows in two Data Extensions (or whatever tables) and do it in a single query, you can leverage CROSS JOINs like this:
Doing it this way will get you past the no-ANSI-JOINs restriction in SFMC.
Reference:
Rocket and a Bomb
Michael Knott sings Rocket and a Bomb. Accompanied by Gene Eugene on the keyboard.
Studio version is here.
Mötley Crüe Reacts to Kids React to Mötley Crüe
Camp Winnipesaukee
Love it when they can stop laughing. Allergies. LOL.
Use AMPScript to find first and last days of the month
If you need to calculate the first and last day of the current month in AMPScript, you can do it like this:
Output:
@today: 7/30/2017 8:25:22 PM
@monthOfThisMonth: 07
@yearOfThisMonth: 2017
@firstDayOfThisMonth: 7/1/2017 12:00:00 AM
@nextMonth: 8/30/2017 8:25:22 PM
@monthOfNextMonth: 08
@yearOfNextMonth: 2017
@firstDayOfNextMonth: 8/1/2017 12:00:00 AM
@lastDayOfThisMonth: 7/31/2017 12:00:00 AM
Reference: