TSQL script writing from a Sql server tables
- or -
Post a project like this324
€30(approx. $32)
- 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
Bay Minette
WordPress Expert/Woocommerce Expert/Data Scientist/Python Expert/Auto-CAD/3D/2D Animation/ White Board Animation
Rawalpindi
⭐ TOP RATED ⭐ Graphic Designer| WordPress / WIX |2D Animator| Video Editing |Photoshop Expert
Karachi
Quick Graphic Designer + Animator + Video Editor + Photo Editor + Logo Designer + Autocad Designer
Sydney
Logo & Graphic Designer / illustration / PowerPoint / CAD / AI Expert / Web Designer
Rawalpindi
UK-based Design Specialist | Skilled Multimedia Expert |Photo & Video Editor, Graphic designer, 2D Animator
London
Graphic Designer|Video editing|2D/3D Logo I Animation | Content Writer | Web Content | Data Entry | Translator | Specialized in Power Point, Excel, Word, Translation
Amsterdam
32504271649971315100533061746476906660817381463569062478912732091432329152355
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.
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