How to get 24 hours using WITH clause in sqlserver

See more:

SQL-Server

Hi,

i have created a table variable that creates 24 hours but instead of table variable i want to create CTE that returns 24 hours so please help how to get 24 hours from with clause. Here my requirement is comparing hourswise orders shipped between table variable and source table if on a particular hour like 10am on no orders shipped then result should be 0 this is return from table variable for this i am using left join. Here my requirement is instead of table variable how to create CTE. Here i am giving some sample query that returns 24 hours.

Declare @Hours Table (Hour int);
Declare @i as int;
Set @i = 5
While @i < 24
Begin
   Insert into @Hours
   Values(@i);

   Set @i = @i + 1;
End;