;WITH cte (BrNum,Emp_Num,Trn_Dt,_Time,Trn_Dt_Time,RowNum)

AS (

SELECTBrNum,Emp_Num,Trn_Dt,_Time,

CAST(CONVERT(char(10),Trn_Dt,120)+' '+STUFF(_Time,3,0,':') as datetime),

ROW_NUMBER() OVER (PARTITION BY BrNum,Emp_Num,Trn_Dt ORDER BY _Time ASC)

FROM Store_

)

SELECT a.BrNum,a.Emp_Num,a.Trn_Dt,a._Time,

ISNULL(CAST(STUFF(CONVERT(char(5),DATEADD(minute,DATEDIFF(minute,b.Trn_Dt_Time,a.Trn_Dt_Time),0),114),3,1,'') as int),0)

FROM cte a

LEFT JOIN cte b ON b.BrNum = a.BrNum AND b.Emp_Num = a.Emp_Num AND b.Trn_Dt = a.Trn_Dt AND b.RowNum = a.RowNum - 1

ORDER BY a.Trn_Dt ASC,a.Emp_Num ASC