//Handwritten
DECLARE @from DATETIME   //Current Selected datetime [the newest of the current user doing the query]
DECLARE @id INT               //userID
DECLARE @tbl TABLE (from datetime, userid int)


SET @from = dbo.GetNewestFrom(@id)


INSERT INTO @tbl(from, userid) VALUES ( @from, @id) //Inserting it to then later select it... Could have just selected it, details for now, move on...:)
SELECT * FROM @tbl                                              //Returns the result of the current user...

//Handwritten
CREATE FUNCTION GetNewestFrom @id int
RETURN DATETIME
BEGIN
DECLARE @from DATETIME

SET @from = SELECT MAX(from) FROM table WHERE userID = @id AND type = 1   //The query for persons without type = 1, is just selecting the MAX(from) FROM table...
//It is if Type = 1, then I shall check for other registered dates for the user, so from here on out, pretending Type = 1, without further checks...

DECLARE @end INT

SET @end = 0
DECLARE @from2 DATETIME

WHILE (@end = 0)
BEGIN
     SET @from2 = 
     (SELECT from FROM table WHERE userID = @id AND @from IN (SELECT table.to + 1 FROM table WHERE userID = @id)

     IF @from IS NULL 
     BEGIN
          @end = 1 //we have selected the newest from, that did not have a "to-date" less than a day... Which mean the rows had a gap of at least 2 days between the registering...
     END
   
     IF @from IS NOT NULL //Else :P
     BEGIN
         @from = @from2
     END
///Continue on reading....

END


SELECT @from //Or is it return @datetime, anyways... 
END

 From - To 
 5      8
10    15
16    20

SELECT MIN (t1.from) FROM table as t1
WHERE
t1.from IN
(
	SELECT t2.to+ 1 FROM table as t2
	WHERE t2.userID = @id
)

DECLARE @t TABLE (
   [id]     INT
,  [userid] INT
,  [from]   DATE
,  [to]     DATE
,  [type]   INT
,  [value]  NVARCHAR(9)
   );
   
INSERT INTO @t
   VALUES
      (1, 201, '11/11/2012', '11/28/2012', 1, 'a string')
,     (2, 199, '11/23/2012',         null, 2, 'a string')
,     (3, 201, '11/29/2012', '12/01/2012', 1, 'a string')
,     (4, 201, '10/03/2012', '10/15/2012', 3, 'a string')
,     (5, 201, '12/02/2012',         null, 1, 'a string');

WITH a AS (
   SELECT b.[from], b.[to], b.[userid]
      FROM @t AS b
      WHERE b.[to] IS NOT NULL
   UNION ALL SELECT c.[from], c.[to], c.[userid]
      FROM @t AS c
      JOIN a AS d
         ON DATEADD(day, 1, c.[to]) = d.[from]
      WHERE  c.[userid] = d.[userid]
         AND c.[type] = 1)
SELECT MIN(a.[from]) AS 'from'
,  a.[to]
   FROM a
   GROUP BY a.[to];