|
|
-
Hariharan Basic Testing Passed 1 Years ago through Puzzles
The challenge idea is taken from a problem discussed in the MSDN TSQL forum.
The challenge is to find the Islands(gaps) in sequential dates. You need to write a query to
identify continuous intervals from the start date and end date.
For example,
01/
|
-
Hilt Basic Testing Passed 1 Years ago through Puzzles
Uses a recursive CTE to collapse the continuous intervals and then identifies the final interval for uninterrupted stay.
|
-
Hilt Basic Testing Passed 1 Years ago through Puzzles
Uses a recursive CTE to collapse the continuous intervals and then identifies the final interval for uninterrupted stay.
|
|
|
|
|
|
|
-
DMoutray Basic Testing Passed 1 Years ago through Puzzles
Using a recursive CTE, get each hospital stay for each patient. Each recursion of the CTE will concatenate any consecutive hospital stay for a single patient as part of a continuous hospitalization interval. The initial result set will contain many overl
|
-
abhIShek BandI Basic Testing Passed 1 Years ago through Puzzles
The challenge idea is taken from a problem discussed in the MSDN TSQL forum.
The challenge is to find the Islands(gaps) in sequential dates. You need to write a query to
identify continuous intervals from the start date and end date.
For example,
01/
|
-
bertin Basic Testing Passed 1 Years ago through Puzzles
The challenge idea is taken from a problem discussed in the MSDN TSQL forum.
The challenge is to find the Islands(gaps) in sequential dates. You need to write a query to
identify continuous intervals from the start date and end date.
For example,
01/
|
-
abdkok Basic Testing Passed 1 Years ago through Puzzles
now with one query ;)
|