i have a problem to finishing my work for graduate.. plz give a solution

i have 1 table : 'period', i'm using MS SQL SERVER 2000. and i want to automatically inserting system date (without sunday) of this month (next month by following the system month) into table 'period' when i click a button on my form.
example : i input a 25 period in text1.text and i click a 'process' button. i confuse how to automatically take the whole date of this month (without sunday) and inserting them on my 'period' table.

i need a result like below :

period total
11/01/2006 0
11/02/2006 0
11/03/2006 0
11/04/2006 0
11/06/2006 0 (the date jump to sixth november 2006, cause fifth november is sunday).

i really appreciate your help.. thank you very much for you advance,

Serzilq