![phoenix](https://d1a29h5kxv3oc2.cloudfront.net/dist/img/phoenix.81914efc7207f6a059bd10f5d3fd5f89.png)
TSQL script writing from a Sql server tables
- or -
Post a project like this412
€30(approx. $33)
- Posted:
- Proposals: 11
- Remote
- #3941368
- Awarded
Python, OpenAI, ChatGPT |Microsoft Fabric| Synapse| SQL Server, Snowflake ❄️, Postgres, MySQL| Power BI, Tableau, Domo | Azure, AWS, GCP| SSIS, Alteryx |AirFlow|AirByte|DBT| DevOps
WordPress Expert/Woocommerce Expert/Data Scientist/Python Expert/Auto-CAD/3D/2D Animation/ White Board Animation
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
⭐ TOP RATED ⭐ Graphic Designer| WordPress / WIX | 3D Architecture | Video Editing |Photoshop Expert
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
Quick Graphic Designer + Animator + Video Editor + Photo Editor + Logo Designer + Autocad Designer
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
Graphic Designer|Video editing|2D/3D Logo I Animation | Content Writer | Web Content | Data Entry | Translator | Specialized in Power Point, Excel, Word, Translation
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
UK-based Design Specialist | Skilled Multimedia Expert |Photo & Video Editor, Graphic designer, 2D Animator
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
32504273151005330617464769069152355660817391432329062478164997181463569127320
![Manish K.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/902bcfeab168ec8a638c8209e6660fae_70x70.png)
![Armaghan A.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/29108d4bf232f820a0e10142eb76097f_70x70.jpeg)
![Riffat B.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/19e52118581bd8cd249c7dd31aa7a9d0_70x70.jpeg)
![Hina A.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/a0c4d63684609e50f54f7372d2ca9543_70x70.jpeg)
![Haris B.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/e96d552d79095ace2fc1d762eabb970e_70x70.jpeg)
Description
Experience Level: Entry
I want a script that will calculate
- how many nights guests stayed in total in our hotel from the arrival date and departure date.
- how much revenue was made from each guests (maybe using the total revenue column or a sum of roomrevenue, Foodrevenue and otherRevenue)
- guest lead time (which is the time they booked, until the time they checked in - that is arrival date minus reservation date)
this should be done for all definite stays only and IsActive and match stayID = profileStayID = CustomerMasterId from linkprofile table.
kindly contact me for the tables
- how many nights guests stayed in total in our hotel from the arrival date and departure date.
- how much revenue was made from each guests (maybe using the total revenue column or a sum of roomrevenue, Foodrevenue and otherRevenue)
- guest lead time (which is the time they booked, until the time they checked in - that is arrival date minus reservation date)
this should be done for all definite stays only and IsActive and match stayID = profileStayID = CustomerMasterId from linkprofile table.
kindly contact me for the tables
![Tabi E.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/b0290baab5e5678940e6dd6db48dd121_150x150.jpg)
Tabi E.
100% (4)Projects Completed
5
Freelancers worked with
4
Projects awarded
71%
Last project
3 Apr 2024
Germany
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies