How do I write this update ?

I have a tblEmployees and a tblAbsenceWeeks. I want to input a date in a text box on my page and on a button click add a record for each employee in tblEmployees to tblAbsenceWeeks for the week in the text box eg

TextBox1.text = 01/06/03

tblEmployees 1 Fred
2 Joe
3 Ken

tblAbsenceWeeks

1 Fred 01/06/03
2 Joe 01/06/03
3 Ken 01/06/03

Can anyone give me the code and SQL to do this in my asp.net project ?

TIA