sql repeated date rows to columns on a new table

I'm looking for something similar to the pivot function I have a table that shows date ranges for users, something that tells me that the user was absent between some period of time.

I know for a fact that I can only have 2 permissions per day, I need to group the ones that have the same date into a new table.

Data should look something like this

Since you know you are going to group at most 2 records per user per day, you can simply use a CTE and a left join:

;WITH p AS (
  SELECT Id, UserId, BeginingTime, EndTime, DateApplied, 
         ROW_NUMBER() OVER (PARTITION BY UserId, DateApplied ORDER BY BeginingTime) AS RowNo
  FROM SourceTable
)
SELECT p1.UserId, p1.Id as ID1, 
       p1.BeginingTime AS BeginingTime1, p1.EndTime AS EndTime1,
       p2.Id as ID2, 
       p2.BeginingTime AS BeginingTime2, p2.EndTime AS EndTime2,
       p1.DateApplied
FROM p p1 LEFT JOIN p p2 
          ON p1.UserId = p2.UserId AND p1.DateApplied = p2.DateApplied AND p2.RowNo = 2
WHERE p1.RowNo = 1