My apologies. The formula was incorrect, which wasn't the point of the question. We rarely ask questions on business logic, but on SQL Server. However, this wasn't clear.

Question...

I'd be prepared to script out everything and ready to re-set Log Shipping.

Make sure you have  backups of all logins and linked servers, as well as user dbs.

Ichiro still climbing the charts.

Answer changed and points awarded back.

I don't know why I use dw. Old habit. I'll try to stick to the longer syntax in the future as a better example.

Here's the issue, ahmed_elbarbary.2010. You have a query there, but you need to explain why it doesn't work. I don't want to dig through a long result set and try...

Closing: post replies here: https://www.sqlservercentral.com/Forums/1884715/How-to-make-relation-between-tables-to-calculate-cost-of-flight-and-transfer-and-hotel-and-excursion?Update=1#bm1884820

Closing: post replies here: https://www.sqlservercentral.com/Forums/1884715/How-to-make-relation-between-tables-to-calculate-cost-of-flight-and-transfer-and-hotel-and-excursion?Update=1#bm1884820