Introduction to Gaps and Islands Analysis - Simple Talk
Jan 2, 2020 ... Defining Gaps and Islands. Within a data set, an island of data is any ordered sequence where each row is in close proximity to the rows around ...
Search results for "gaps and islands"
Your search for "gaps and islands" returned 100 results:
Advanced grouping for gaps and islands
Hi, I'm trying to figure out how to group a set of data based on how many days a person is sick. The problem is a gaps and island issue combined with running streak, with a twist. The records are either of type Work or Sick and are only saved on it's registered date. So […]
2023-02-20
208 reads
Gaps and Islands Across Date Ranges
Watch this week’s episode on YouTube.In a traditional gaps and islands problem, the goal is to identify groups of continuous...
2019-03-12
1,597 reads
An Efficient Set-based Solution for Islands and Gaps
Comments posted to this topic are about the item An Efficient Set-based Solution for Islands and Gaps
2004-11-11
416 reads
Gaps and Islands with multiple simultaneous insurance coverage?
Most examples of "gaps and islands" queries I've seen focus on an identity column or when tracking a change in a status flag (similar to win/loss streaks for a sports team). I've run into a situation that is a bit more complex than mentioned above. I'm working with healthcare data where a person could have […]
2011-05-26
97 reads
Efficient Solutions to Gaps and Islands Challenges - Simple Talk
Jan 21, 2020 ... The simplest analysis we can perform is to determine winning and losing streaks. From a data perspective, streaks can be described as islands of ...
Counting the number of unique days between ranges of dates
This feels like an easy problem to solve, but I have not yet been able to find a solution. I have a table containing an IdentityID, UnitID, StartDate and EndDate. A person can be a member of more than 1 unit at a time. A person could also not be a member of any unit […]
2021-02-02
1,726 reads
Dipping into the Cookie Jar
This post is a response to this month's T-SQL Tuesday #112 prompt by Shane O'Neill. T-SQL Tuesday is a way for the SQL Server community to share ideas about different database and...
2019-03-12
merge/flatten overlapping Time ranges. In order.
Hi, I have few intervals with status. They change in Time (order indicated by OrderId). In the End I would Like to have flattened (in order of appearance, next OrderId has priority) result like this : as you can see: 1) OrderId=1 was split into 2 rows, as it was partially overlapped by next ranges […]
2015-02-10
2,884 reads
Is this a "gaps and islands" problem? Finding gaps in overlapping times.
The following can be pasted into SSMS so that it is both more readable, and easier get your teeth into the data. So the obvious question is "How do I identify the gaps where the locations are unoccupied?
2013-08-14
134 reads
Blogs
How Redgate Flyway Can Boost Your DevOps Journey
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
Building a Docker image with Docker Build Cloud
In a previous blog post we went through how to build a Docker container...
Top 8 Courses to Learn SQL for Data Science in 2024 & Beyond
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
Forums
How to compare data in customer table with other customers to find related cust
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
process records in loop
I'm only processing 50,000 records not everything from the Table where there are 250,00...
The Marked Transaction
Comments posted to this topic are about the item The Marked Transaction
Question of the Day
The Marked Transaction
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers