Comparing Data in Two Consecutive Rows in SQL Server

try this.

;WITH CTE_TEST AS
(
    SELECT Date1, Name,[Status] ,
           ROW_NUMBER() OVER (PARTITION BY Date1, Name ORDER BY Date1) AS row_num
    FROM templogin
)

SELECT distinct
     previous.Date1,previous.Name ,previous.[Status] ,previous.row_num
FROM
    CTE_TEST AS [current]
LEFT OUTER JOIN
    CTE_TEST AS previous
    ON [current].Date1 = previous.Date1
    AND [current].Name = previous.Name
  
    AND ([current].row_num = previous.row_num + 1 or previous.row_num=(select MAX(row_num) from CTE_TEST))
where [current].[Status] <> previous.[Status]

   ORDER BY
    previous.row_num

SELECT distinct
     [current].Date1,[current].Name ,[current].[Status] ,[current].row_num
FROM
    CTE_TEST AS [current]
LEFT OUTER JOIN
    CTE_TEST AS previous
    ON [current].Date1 = previous.Date1
    AND [current].Name = previous.Name
  
    AND ([current].row_num = previous.row_num + 1 or [current].row_num=1)
where [current].[Status] <> previous.[Status]

   ORDER BY
    [current].row_num

Here is my sample table and records.

use santhosh
create table templogin
(Date1 Datetime,
Name varchar(50),
Status varchar(50))

insert into templogin values(
'2012-07-16',    'A'  ,      'Login')
insert into templogin values(
'2012-07-16',    'A'  ,      'Logout')
insert into templogin values(
'2012-07-16',    'A'  ,      'Login')
insert into templogin values(
'2012-07-16',    'A'  ,      'Login')
insert into templogin values(
'2012-07-16',    'A'  ,      'Logout')

I have written that query for this table structure.