Set ROW_NUMBER() by column name in Multiple Joins using SQL Server

As per In reference Article CustomerId is unique which used to Row Number.

SELECT ROW_NUMBER() OVER
(
  ORDER BY [CustomerID] ASC
)AS RowNumber

Same way you need to assign any unique column name from for ROW_NUMBER in your select statement attendance table.

SELECT ROW_NUMBER() OVER
(
ORDER BY [YourUniqueIdColumn] ASC
)AS RowNumber

I have solved this, see my sql statement

USE [EWACS]
GO
/****** Object:  StoredProcedure [dbo].[GetTransactionPageWise]    Script Date: 13/03/2018 22:33:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[GetTransactionPageWise]
      @PageIndex INT = 1
      ,@PageSize INT = 50
      ,@RecordCount INT OUTPUT
	  ,@StartDate DATETIME
	  ,@EndDate DATETIME
AS
BEGIN
	SET NOCOUNT ON;

	WITH attendance AS ( SELECT a.StaffNo,a.DateLog, { fn DAYOFWEEK(DateLog) } AS dayID,MIN(a.timelog) as TimeIn, MAX(a.timelog) as TimeOut,a.TransType 
	FROM dbo.[Transaction.Attendance] a 
	WHERE a.DateLog Between @StartDate and @EndDate and a.TransType = '1' 
	GROUP BY a.StaffNo,a.DateLog,a.TransType),

	test AS ( SELECT a.StaffNo,a.DateLog, { fn DAYOFWEEK(DateLog) } AS dayID,MIN(a.timelog) as TimeIn1, MAX(a.timelog) as TimeOut2,a.TransType 
	FROM dbo.[Transaction.Attendance] a 
	WHERE a.DateLog Between @StartDate and @EndDate and a.TransType = '1' 
	GROUP BY a.StaffNo,a.DateLog,a.TransType) 

	SELECT ROW_NUMBER() OVER
	(
		ORDER By e.StaffNo ASC
	) AS RowNumber,	
	e.StaffNo, e.Name AS StaffName, j.UnitName as Dept,a.dayID,Convert(nvarchar(12),b.Date,106) as DateLog,b.DayName, { fn DAYOFWEEK(b.Date) } AS dayID2,
	TimeIn,k.TimeOut2 AS TimeOut,c.Reason As lateIn,d.Reason As EarlyOut,h.Name As Leave, f.StartHour,f.EndHour,f.flagIncludeBrakeTime, f.BreakStartHour,
	f.BreakEndHour,f.flagWorkingDay, f.HalfdayStartHour,f.HalfdayEndHour,f.flagIncludeHalfday, f.OTStartHour,f.OTEndHour,f.flagIncludeOvertime,c.Status as Stat1,
	c.Remarks as RemarksLate,d.Status as Stat2,d.Remarks as RemarksEarly,g.Status as Stat3, Convert(nvarchar(12),c.ApprovedDate,106) AS ApprovedDate1, 
	Convert(nvarchar(12),d.ApprovedDate,106) AS ApprovedDate2 
	
	INTO #Results
	FROM attendance a 
	RIGHT JOIN dbo.[DimDate] b ON a.DateLog = b.Date 
	LEFT JOIN test k On a.DateLog = k.DateLog and a.StaffNo = k.StaffNo 
	INNER JOIN dbo.[User.Profile] e On a.StaffNo = e.StaffNo 
	LEFT JOIN dbo.[Attendance.LateIn] c On b.Date = c.DateLog and e.StaffNo = c.StaffNo 
	LEFT JOIN dbo.[Attendance.EarlyOut] d On b.Date = d.DateLog and e.StaffNo = d.StaffNo 
	LEFT JOIN dbo.[Attendance.Leave] g on e.StaffNo = g.StaffNo and b.Date = g.DateLog 
	LEFT JOIN dbo.[Leave.Type] h ON g.Type = h.Id 
	LEFT JOIN dbo.[Working.Hour] f On e.WorkingHourId = f.Id AND f.DayId = a.dayID 
	INNER JOIN dbo.[Hierarchy] j ON e.DeptId = j.UnitCode 
	WHERE b.Date Between @StartDate and @EndDate 
	ORDER BY Dept, Staffno ASC, Datelog 

	SELECT @RecordCount = COUNT(*)
    FROM #Results
            
    SELECT * FROM #Results
    WHERE RowNumber BETWEEN(@PageIndex -1) * @PageSize + 1 AND(((@PageIndex -1) * @PageSize + 1) + @PageSize) - 1
      
    DROP TABLE #Results    

END