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

Closing. Please 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

And post your attempt. Again, we are not here to do your work.

Everyone, please  DO NOT post a solution if there is no attempt by the OP.

I used Arrays, since this somewhat corresponds to what others would see in their language.

This doesn't show what you've tried. Put data in the tables, post the inserts, and post some queries that retrieve data.

We are here to help, but not do...

Some people signed on July 4, but all did not complete the signing until later.

That makes sense. I'd hope that your previous employer would have someone checking mail for a time and could forward on a reset, but I understand.

It makes sense. ...

I was just worried you might have SP2 and CU11 for SP1. Or something similar. Can be confusing with the CUs since there is a CU1 for RTM, SP1, and...

Can't tell based on your post. The workload will determine if this is an issue. There will be IO to read the log and write the backup file, however, this...

We could, though I'm not sure how much of a priority this could be. We ought to have some recovery, but have never had an issue.

What purpose would...