Like this:
DECLARE @SearchValue varchar(20), @OutputParam int;
SET @SearchValue = 'Your Value';
EXEC dbo.YourSP @Param1 = @SearchValue , @Param2 = @OutputParam OUTPUT;

What have you attempt to answer your question? What have you tried to do to "calculate cost of flight and transfer and hotel and excursion".

My first question is, why do you want to store this in a Global Temporary Table? As the name suggest, these are temporary, they're not designed to be static. If...

So, our 3rd party data engine failed today at 10:15. Took someone about an hour to notice, as it's extremely rare any of the DB team are looking at data...

You'll need to set up a Source for each tab in your Excel document. In each of those, "Select", the data from the relevant tab.

Depending on what...

SQL Server can't send SMS's. I assume that you are using a 3rd party application that then transforms the received email into an SMS, and sends it to the related...

What sort of tools do you have available? Considering that you say you don't know SQL Server, or at least, where to start, it'll help us to understand what you...

You've been asking these questions in 3 separate topics so far already:
https://www.sqlservercentral.com/Forums/1883089/How-to-calculate-cost-of-flight-and-hotel-and-transfer-per-every-program
https://www.sqlservercentral.com/Forums/1883528/How-to-add-cost-per-hotel-and-flight-in-duration-cost-table
https://www.sqlservercentral.com/Forums/1882891/How-to-calculate-cost-per-every-daycost-hotel-cost-flight-depending-on-flight-date
All of these ask very similar questions. Is this...