merge interval Archives - SQLServerGeeks

Merge Interval Operator – Part2

October 27, 2014July 3, 2020 - by Kanchan Bhattacharyya - Leave a Comment

Hi Geeks, Welcome to Part2 of Merge Interval Operator. If you missed Part1, you can click here and read it before today’s post. Let me modify our query from yesterday as following. USE …

One Operator a Day / SQL Server

Merge Interval Operator – Part1

October 26, 2014July 3, 2020 - by Kanchan Bhattacharyya - Leave a Comment

Hi Geeks, Merge interval operator used to remove duplicated predicates in a query. It also helps to find possible overlapping intervals which in turn helps to optimize filters to avoid scanning …