Question

Your client has a contract that started on 1/1/2016 and ends on 5/31/2030. The client signs a continuation of the contract with altered terms that starts on 4/1/2028 with an end date of 12/31/2040. Write the queries you would need to update the old contract and insert the new contract. Your client has negotiated a contract with updated terms that falls in between the previous two contracts. The new contract has a start date of 1/1/2025 and an end date of 12/31/2035. Write the queries that you would need to update the start and end dates of the old contracts and insert the new contract. I dont need the actual answer but if you can provide an actual answer that would be great, however, if you cant can you at least tell me what the steps would look like?

          Your client has a contract that started on 1/1/2016 and ends on
5/31/2030. The client signs a continuation of the contract with
altered terms that starts on 4/1/2028 with an end date of
12/31/2040. Write the queries you would need to update the old
contract and insert the new contract. 
Your client has negotiated a contract with updated terms that
falls in between the previous two contracts. The new contract has a
start date of 1/1/2025 and an end date of 12/31/2035. Write the
queries that you would need to update the start and end dates of
the old contracts and insert the new contract.
I dont need the actual answer but if you can provide an actual
answer that would be great, however, if you cant can you at least
tell me what the steps would look like?

your client has a contract that started on 112016 and ends on 5312030 the client signs a continuation of the contract with altered terms that starts on 412028 with an end date of 12312040 wr 07158

Added by Michael D.

Question

Please give Ace some feedback