SQL Server存储过程，以增加日期的天数

I need to write a stored procedure that given a date and a number of working days, adds those given days to that date, and returns the new date, without counting the non-working days and the weekends. the non-working day are stored in another table.I need to write a stored procedure that given a