I have 2 tables as below\

**Table-1**

Order\_ID(Numeric)---Order\_Date(Datetime)

100067 --- 2013-08-30 09:54:47.000

100068 --- 2013-08-30 10:30:37.000

**Table-2**

Order\_ID(Numeric)---Order\_Date(Datetime) ---Delivery\_Time(Datetime)

100067 --- 2013-08-30 09:54:47.000 

100068 --- 2013-08-30 10:30:37.000

Now i want to calculate the delivery time by one hour from order time. For example my order time in Table-1 is 2013-08-30 09:54:47.000 i want to insert a record in table-2 with Delivery\_Time as 2013-08-30 10:54:47.000. Ultimately i want to add 1 hour to the order time in table-1 and insert the record in table-2.

Can you please help me out with this situation.