SELECT DepotCode, RouteCode, RouteName , TotalSale, DayNames, DayNumber ,ROW_NUMBER() OVER(PARTITION BY DepotCode, DayNumber ORDER BY DepotCode, DayNumber) AS 'record'
FROM DayWiseCount
If it solved you problem please accept it as an answer or vote it up. ;)