DORSETRIGS
Home

gaps-and-islands (10 post)


posts by category not found!

Calculate streaks at scale

Calculating Streaks at Scale A Comprehensive Guide Streaks are a vital part of user engagement in various applications from fitness tracking to educational plat

2 min read 26-09-2024 35
Calculate streaks at scale
Calculate streaks at scale

How can I find the longest number of consecutive nulls in a column in MySQL?

Finding the Longest Sequence of Consecutive NULLs in a My SQL Column When working with databases its common to encounter NULL values in your columns You may nee

2 min read 24-09-2024 53
How can I find the longest number of consecutive nulls in a column in MySQL?
How can I find the longest number of consecutive nulls in a column in MySQL?

SQL query that returns all dates not used in a table

How to Write an SQL Query to Find All Unused Dates in a Table In the world of database management it is often necessary to determine which dates have not been u

3 min read 21-09-2024 36
SQL query that returns all dates not used in a table
SQL query that returns all dates not used in a table

How to performantly self-join same table multiple times with ascending and descending sort order?

How to Performantly Self Join the Same Table Multiple Times with Ascending and Descending Sort Order When working with relational databases it s not uncommon to

3 min read 20-09-2024 51
How to performantly self-join same table multiple times with ascending and descending sort order?
How to performantly self-join same table multiple times with ascending and descending sort order?

Get a list of dates between two dates

Generating a List of Dates Between Two Given Dates in My SQL The problem presented asks how to create a list of all dates between two specified dates in a My SQ

3 min read 07-09-2024 37
Get a list of dates between two dates
Get a list of dates between two dates

How do I a gap and island analysis with a power query?

Demystifying Gap and Island Analysis with Power Query A Step by Step Guide Gap and island analysis is a powerful technique for identifying and analyzing groups

3 min read 31-08-2024 38
How do I a gap and island analysis with a power query?
How do I a gap and island analysis with a power query?

Calculate Total Continuous Date Range

markdown Calculating Total Continuous Date Range in SAS Calculating the total continuous date range from a dataset can be challenging especially when dealing wi

3 min read 30-08-2024 35
Calculate Total Continuous Date Range
Calculate Total Continuous Date Range

SQL Grouping based on one field and a flag

Grouping SQL Records Based on a Flag A Step by Step Guide This article delves into a common SQL challenge grouping records based on a field and a flag as encoun

2 min read 30-08-2024 36
SQL Grouping based on one field and a flag
SQL Grouping based on one field and a flag

Finding Product Switches on Account Between Dates

Tracking Product Switches on Accounts A Guide to Finding the To and From Dates This article explores a common data challenge in business how to track product sw

3 min read 28-08-2024 36
Finding Product Switches on Account Between Dates
Finding Product Switches on Account Between Dates

The problem of extracting consecutive dates in SQL query

The Problem of Extracting Consecutive Dates in SQL Queries Extracting consecutive dates in SQL queries can be a tricky task especially when you need to identify

2 min read 27-08-2024 42
The problem of extracting consecutive dates in SQL query
The problem of extracting consecutive dates in SQL query