• Hi,

    I have just tested with SQL Agent.

    I don't know how to retrieve date from Holiday table.

    use testDB

    Insert into Pickup (StaffID, RouteID, PickupDate)

    select StaffID, RouteID, (getdate()) from Routes