Sign in

Join
Home
Blogs
Ask
Just Learned
Interview Questions
Puzzles
Tutorials
Quiz
Modules
Getting Started with Adobe After Effects  Part 6:
Motion Blur
First Time? You can support us by signing up. It takes only 5 seconds. Click
here
to sign up. If you already have an account, click here to
login
.
Friends
My Badges
Quiz Master
TC Winner
Puzzle Master
Request Friendship
Leszek Gniadkowski
Upload Image
43 years old
Poland
Male
My Home
Comments (0)
My Friends (29)
My Points
My Sections
0082 (Blogs)
My Activities
Ask
30
Blogs
11
Books
3
Puzzles
961
User Groups
1
Just Learned
8
Pages
1
What is New
1
Interview Questions
2
Syndicated Blogs
2
Quiz
1
Leszek Gniadkowski
8 ·
18% ·
5729
Leszek Gniadkowski's Home
My name is
Leszek Gniadkowski
.
TSQL Challenge 80  Find the minimal set of intervals without creating gaps
Leszek Gniadkowski
Commented 5 Years ago through
Puzzles
@Maxim [row number section][1] [1]: http://explainextended.com/2009/11/18/sqlserveraretherecursivectesreallysetbased/
dishdy
16 ·
10% ·
3269
TSQL Challenge 80  Find the minimal set of intervals without creating gaps
Leszek Gniadkowski
Commented 5 Years ago through
Puzzles
Dishdy, not exactly, check and analyze result of my cte3 with and without distinct on Maxim's load data from page 3.
dishdy
16 ·
10% ·
3269
TSQL Challenge 80  Find the minimal set of intervals without creating gaps
Leszek Gniadkowski
Commented 5 Years ago through
Puzzles
Yes. It looks good. I'm curious about the algorithm.
dishdy
16 ·
10% ·
3269
TSQL Challenge 80  Find the minimal set of intervals without creating gaps
Leszek Gniadkowski
Commented 5 Years ago through
Puzzles
Hi, thanks for debug, look at v7c
dishdy
16 ·
10% ·
3269
Solution to TSQL Challenge 80  Find the minimal set of intervals without creating gaps
Leszek Gniadkowski
Solved 5 Years ago through
Puzzles
v7c  fixed
Solution to TSQL Challenge 80  Find the minimal set of intervals without creating gaps
Leszek Gniadkowski
Commented 5 Years ago through
Puzzles
v7c  fixed
Solution to TSQL Challenge 80  Find the minimal set of intervals without creating gaps
Leszek Gniadkowski
Commented 5 Years ago through
Puzzles
064.inner join cte1 c1 on c1.GroupId = c4.GroupId is useless, but no effect on result
Solution to TSQL Challenge 80  Find the minimal set of intervals without creating gaps
Leszek Gniadkowski
Solved 5 Years ago through
Puzzles
v7b  hope last ver ;)
Solution to TSQL Challenge 80  Find the minimal set of intervals without creating gaps
Leszek Gniadkowski
Commented 5 Years ago through
Puzzles
v7b  hope last ver ;)
Solution to TSQL Challenge 80  Find the minimal set of intervals without creating gaps
Leszek Gniadkowski
Solved 5 Years ago through
Puzzles
v6b  add Stefan's trick
Previous
1

2

3

4

5

6

7

8

9

10

...
Next
Managed Windows Shared Hosting
by OrcsWeb
Copyright © Rivera Informatic Private Ltd.