Skip to content

sprignaturemoves

the personal blog of adam spriggs

  • Home
  • About Me
  • Salesforce Marketing Cloud
    • Known Issues
    • AMPscript Syntax Highlighter for Sublime Text
    • All SFMC Posts
    • AMPScript
    • API
    • Automation
    • Journey Builder
    • Server-side JavaScript
    • SQL Queries
  • The AMPscript Guide
  • Coffee
    • Coffee Prep
    • Empty Coffee Bags
  • Dadverbs

All of Jim’s Dwight Pranks

Posted on2017-09-202019-05-11 Categoriesfun

Super-cut of Jim’s Dwight pranks in The Office.

Why are you littering?

Posted on2017-09-16 Categoriescommentary

WHY ARE YOU LITTERING?
✓ I am a Jerk
✓ I don’t care about natural areas
✓ Mommy still cleans up after me
✓ All of the above

LEGO 75192 Millennium Falcon

Posted on2017-08-312020-06-27 CategoriesLEGO

Hans and Maddy review the LEGO 75192 Millennium Falcon.

Kosta Koufos Floaters

Posted on2017-08-24 Categoriessports

Kings big man Kosta Koufos demonstrating his floater repertoire.

Counts from two tables in one query

Posted on2017-08-172017-08-17 CategoriesSalesforce Marketing Cloud, SQL Queries

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:

MSDN – Using Cross Joins

Posts navigation

Older posts
Newer posts
Search
Post Categories

Where to Find Me

  • BitBucket
  • GitHub
  • LinkedIn
  • StackExchange

Popular Posts

  • AMPScript Lookup Examples
  • Retrieving and Starting an Automation with SSJS
  • Journey Logging using Update Contact
  • One-Click Unsubscribe with AMPscript
  • Troubleshooting Queries in SFMC
  • Updating Salesforce Objects with Server-Side JavaScript
  • Determining Business Unit Subscriber Status
  • Coupon Claiming in AMPscript
  • Timezones in SFMC
  • Geolocation in the Salesforce Marketing Cloud

My Favorite Things

  • Bucks
  • Smith & Wesson
  • PK Grills
  • The AMPscript Guide
  • Crema.co
United States Flag
06.24.22
Copyright © 2026 sprignaturemoves. All Rights Reserved.
Catch Starter Child Theme by Adam Spriggs
Scroll Up