SQL Server adds weekdays to the table, excluding holidays, only Saturday Sunday

--createtableintprimarykeyidentity (1,1nvarchar(int--  determine if enabled )

----Add a working day for one yearDECLARE @num int DECLARE @count int Set @num = 1Set @count = 1  while @num <=365  --the span of a leap year is 366 daysbegin INSERT  intoWeekdaysVALUES(Convert(nvarchar(Ten),DateAdd(DD,@num,'2017-07-05'), at),1)--2017-07-05 Wednesdayif @count=2begin Set @num = @num+3Set @count = @count+3End Else begin Set @num = @num+1Set @count = @count+1 EndIF @count = 8Set @count = 1End

SQL Server adds weekdays to the table, excluding holidays, only Saturday Sunday