Make two continued date records in the same row via joining two tables.

Make two continued date records in the same row via joining two tables.

Using LAG and LEAD functions to get start admission date and upper bound admission date respectively, then joining on original table to get amounts.

I tried to use LAG functions to score each row 1 for a new start row and 0 for others. So column has values of 1 and 0 eg 1,0,0,1,1,0,1 then uses SUM aggregate function to add all values together so becomes 1,1,1,2,3,3,4. Then use these values to group row

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/

I tried to use LAG functions to score each row 1 for a new start row and 0 for others. So column has values of 1 and 0 eg 1,0,0,1,1,0,1 then uses SUM aggregate function to add all values together so becomes 1,1,1,2,3,3,4. Then use these values to group row

Using LAG and LEAD functions to get start admission date and upper bound admission date respectively, then joining on original table to get amounts.

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/