Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

TSQL Challenge 75 - Find the Episode and Sequence based on interval

By Jacob Sebastian,

TSQL Challenge 75 - Find the Episode and Sequence based on interval

The challenge is to find the Episode and Sequence based on interval. Episode is separated by IntervalDate. One episode can contain multiple Sequence number.

http://beyondrelational.com/puzzles/challenges/109/find-the-episode-and-sequence-based-on-interval.aspx

 
Total article views: 1242 | Views in the last 30 days: 3
 
Related Articles
FORUM

Sequencing

Add sequence number to rows

BLOG

Filmed: DBAs@Midnight Episode 2.30

Friday night (as per usual) we filmed a new episode of our 2 1/2 year old webshow, DBAs@Midnight in ...

BLOG

Sneak Preview – Episode 014 - WaterOx Consulting

Let’s Play A Game! So, just to tickle your fancy, here is... The post Sneak Preview – Episode 014 a...

BLOG

Sneak Preview – Episode 012 - WaterOx Consulting

Reading Time: 1 minutesLet’s Play A Game! So, just to tickle your fancy, here is... The post Sneak ...

FORUM

TSQL Challenge 75 - Find the Episode and Sequence based on interval

Comments posted to this topic are about the item [B]TSQL Challenge 75 - Find the Episode and Sequenc...

Tags
 
Contribute