Set availability for a full year, except sundays

year_availability_no_sundays.sql

DECLARE @start_date DATETIME, @end_date DATETIME
SET @start_date = '2014-01-01'
SET @end_date = '2014-12-31'
WHILE @start_date <= @end_date
BEGIN
  --PRINT @start_date
	IF datepart(weekday, @start_date) = 1
		INSERT INTO tblAvailability(avDate, avNumber) VALUES(@start_date, 0)
	ELSE
		INSERT INTO tblAvailability(avDate, avNumber) VALUES(@start_date, 120)
	SET @start_date = DATEADD(DAY, 1, @start_date)
END