Already Googled

Thanks for the reply, I need it to add working days, skipping weekends

It only populates the last 2 dates for 855 and the last date for 856 for a new record and updates nothing for existing records.

* 855 has the...

Lowell,

Thank you but this only does what my original code does. It populates the last date field only on an initial insert and doesn't update anything.

SQL Server 2008...

Also, the application does not recognize views, this data must be in a table which is then viewed by the end user within the application.

There is only 1 row in the days table, got that covered. It contains 16 fields based on the 2 different proposal types.

set @proposal_number = (select proposal_number from inserted);...

Only one record will be updated at a time based on a single insert or update via a front end user app. Each record has 8 dates. The...

This is my set statement on the rfi days, it is as basic as it gets and works adding all days perfectly.

set @sh_act_rfi_days = (select sh_act_rfi_days from sh_procurement_days);

Maybe...

Thank you for the reply, I greatly appreciate it. Your solution parses and executes but returns no date at all. any additional ideas?