Stored procedure sql hierarchical data jobs

I'm seeking a proficient Python expert who can assist with script editing and fixing. Your primary task would revolve around addressing logic errors within my script starting from some instruction I will provide. This role perfectly fits an individual with in-depth Python understanding and extensive experience in dealing with logical errors and fixing scripts-resultantly enhancing ...Python understanding and extensive experience in dealing with logical errors and fixing scripts-resultantly enhancing overall script performance. A first problem is that the script seems bound by particular dependencies and being poorly documented it is difficult to understand what causes the startup problem. Fixed that, we will move to the final editing of the script used to save output data...

Interactive Looker dashboard 1 Layout Data come sql server 4 tables pivot in excel

I'm currently working on enhancing my Sendpulse chatbot's capabilities to improve user interaction and data management. My goal is to set up a dynamic, user-friendly drag and drop flow and integrate API elements to interact with my MySQL database efficiently. I am looking for a freelancer with a solid background in chatbot development, particularly someone experienced with Sendpulse, to bring these enhancements to life. **Ideal Skills and Experience:** - Proficient in Sendpulse chatbot development - Strong background in API integration - Experience with MySQL databases - Knowledge in creating user-friendly chatbot flows - Ability to implement drag and drop functionalities - Expertise in programming languages necessary for API and database integration **Requirements:** ...

...Ability to send an email notification to me whenever a form is submitted. - Save submission data to a database for future reference and access. - Integrate seamlessly with our CRM system to streamline lead management. **Form Fields Required:** - Must include fields for Name, Email Address, Phone Number, and Location. - The flexibility to add other fields as necessary depending on future requirements. **Display Preferences:** - The form should be integrated as a sleek sidebar widget that doesn't intrude on the user's browsing experience but is easily accessible. **Ideal Skills and Experience:** - Proficient in WordPress plugin development with a solid understanding of PHP, JavaScript, and SQL. - Experience with WordPress API and email handling within Word...

OPEN POSITION: Data Base Developer ROLE RESPONSIBILITIES : -Develop and maintain our database system using PHP and SQL. -Optimize database performance for efficiency and scalability. -Collaborate with the development team to implement new features and functionality. -Troubleshoot and resolve database issues in a timely manner. -Stay updated on industry best practices and technologies. REQUIREMENTS : -Proficiency in PHP and SQL is essential. -Experience with HTML -JavaScriptand/or React is a plus. -Strong problem-solving skills and attention to detail. -Excellent communication and collaboration abilities. -Passion for gaming and travel is a bonus! Part time job 300 USD/Month

This is a typing work in which you need to type in words from image file to text file. We have attached a demo files which explains the procedure of the work to be done. Accuracy of the work should be 95%. Number of pages to be done: 40 Rate : Rs 15/- per page. Number of words per page on an average: 850 Payment will not be released in case the files doesn't get delivered on time. Only genuine freelancers can bid.

Overview: Seeking experienced Core PHP developer to update existing APIs and...measures and authentication. * Test thoroughly for bugs and optimize performance. * Coordinate with team for front-end integration. * Provide documentation and support. Requirements: * Proven Core PHP API development experience. * Familiarity with maintaining and updating APIs. * Proficiency in RESTful API development. * Experience with JWT/OAuth and OTP platform integration. * Strong MySQL and SQL query skills. * Effective communication and collaboration. * Git version control experience. Duration: 4-5 weeks from Feb 20, 2024. Note: Interested candidates are requested to provide their resumes along with relevant work samples showcasing their experience in updating and developing APIs, specifically i...

I am looking for a freelancer to prepare complete document on MSSQL server GAP analysis report looking forward to connect me : (removed by Freelancer.com admin) Thank you...

...ability to effectively train others. If you're skilled in data analysis, visualization, SQL, programming (Python, R), and other BI essentials, join us for global projects. What We're Looking For: Business Intelligence Experts with Training Skills: Data analysis, visualization, and SQL Programming (Python, R) Business acumen and problem-solving Effective communication and domain expertise Data warehousing and modeling ETL processes and OLAP Statistical analysis and machine learning Big data technologies (Hadoop, Spark) Agile methodologies and data-driven decision-making Cloud technologies (AWS, Azure) and data security NoSQL databases and web scraping Natural Language Processing (NLP) and sentiment analysis API integrati...

...skilled web developer to create two web-based forms that will collect critical data in the form of dates, and efficiently store this data in a SQL database. The primary purpose of these forms is to streamline the process of gathering and analyzing specific timeline data crucial for my project's success. **Key Requirements:** - **Form Design:** Design two user-friendly web forms capable of collecting dates. Prioritize simplicity and ease of use to encourage accurate data submission. - **Database Integration:** Utilize SQL for backend storage. Experience with SQL is a must, as the forms need to seamlessly update the database in real-time. - **Report Generation:** Ability to generate summary reports from the collected data. The...

I'm seeking a skilled freelancer to assist with a web scraping project two specific websites and leading up to a number of websites. The specific data fields that need to be extracted will be provided. Ideally, you'll have: - Advanced skills in web scraping and python - Knowledge of MS SQL Server databases. - A demonstrable understanding of data extraction - A fast turnaround rate as this project is high-priority and needs completing as soon as possible. The end goal is for me to eventually take over the code with your ongoing support and will most likely be a long term relationship. I can provide a full specification when needed.

More details: What platform(s) do you want the image upload feature to be available on? iOS, Android, Both How would you like the images to be uploaded? Direct from the device's camera, From the device's photo gallery, Both options How do you want the uploaded images to be stored? uploading to an API

I am in need of an experienced ReactJS developer for the ...creation of a sophisticated front-end application. The key features of the application must include: - User Authentication: Integrating a secure sign-in system to protect user data. - Responsive Design: The application must look and function consistently on various screens sizes and devices. - Integration with APIs: The application needs seamless integration with multiple APIs. The application must be capable of interacting with an SQL database for data storage and retrieval. Having expertise in SQL database management would be greatly beneficial for this project. Ideal Skills: - Proficiency in ReactJS and SQL - Understanding of responsive design principles. - Experience in API integration....

PLEASE IGNORE THE SMALL BUDGET MENTIONED IN THIS JOB POST. You can tell me the price of this work when applying for the project. Write a stored procedure / database query. In the attached file: all database structure and its data is present. I have also given examples with expected output. The table data is sample data I have entered manually. Some data can be wrong, so ask me any time if you think any data is wrong. All conditions are also written in it.

...handling extensive property listings. - Capable of implementing advanced search functionalities (Note: Specific search features like location-based, price range, and property type search are to be confirmed). Ideal Skills: - Expertise in JavaScript, HTML, CSS for front-end development. - Proficiency with back-end development (e.g., PHP, Ruby on Rails, Django). - Experience with SQL or NoSQL databases for storing property data. - Familiarity with SEO best practices to enhance the platform's visibility. - A creative mindset to design an engaging user interface. The project timeline was not specified, so I am open to discussing feasible deadlines. I'm looking for someone who not only has the technical skills but also a passion for creating meaningful online experi...

...interface. - **File Management**: Implement a straightforward method for attaching documents to records. The system should support multiple file types, specifically PDFs, Word documents, and image files. Attached files must be stored securely in Salesforce Files and linked appropriately to their respective records for easy access and management. **Ideal Skills and Experience**: - Proficiency in Salesforce development, specifically with lightning component frameworks. - Strong understanding of CRM user interface design principles. - Experience with Salesforce Files and data management. - Ability to work with multiple file formats and ensure their compatibility. - Proven track record of developing customizable and visually appealing Salesforce solutions. This project nece...

I'm looking to develop a solution to collect real-time Tesla telemetry data through the vehicle interface. This project aims to harness crucial information to better understand vehicle performance, optimize battery usage and health, and analyze driving behavior and patterns. Given the complexity and real-time nature of data collection, the ideal freelancer for this job would possess the following: - Strong background in automotive software development, especially with electric vehicles. - Proficient in working with vehicle interfaces for data collection. - In-depth knowledge of data processing and analytics for real-time data streams. - Experience in developing mobile or web applications to display collected data insights. - Understanding of ...

...checkout process to be more user-friendly. The end goal is to significantly enhance user experience on both sites. Key Tasks and Requirements: - **Resolve Theme Compatibility Issues**: Address and rectify any problems caused by theme incompatibility with WooCommerce HPOS, ensuring seamless product management and payment processing. - **Checkout Process Simplification**: Modify the checkout procedure to minimize the number of steps required, making it faster and easier for customers to complete their purchases. Project Overview: This project aims to enhance two similar WordPress WooCommerce websites by: 1. Fixing customer account update synchronization issue: Things are working fine currently with WooCommerce HPOS compatible mode enabled. Issues are visible when compatibility m...

...integrate with the freestyle libre3 api and also the polar api. I need an interface for the end user to enter their details for both api. Their api details will be stored in postgres but the actual data from the api will be in influxdb which is a time-based db. Right now data is based on sessions. So with our app that measures co2 levels it creates a session which a start and end time. The data from freestyle libre3 has data 24/7 with glucose levels every minute or two. So the data from the api that we save has to match the time of currently stored sessions. In other words the data we save to that session will be only the data that were during the time of the session. The website is in digitalocean in a droplet so you sho...

Create a new .net 7.0 application that will fully implement the protocol LNURL-auth. The following functions of LNURL-auth need to be implemented: -register -login -link -auth Documentation for LNURL-auth can be fou... Please read the documentation and make sure you fully understand the project before applying. To apply, please type what the sha256 of "helloworld" is to show you know knowledge of hashing, and please type the last sentence of the documentation to show you have read it fully. A linux machine will be given that ready for you to deploy to. The database will be sql server. **Ideal Skills and Experience:** - Proficient in .NET 7.0 framework. - Strong background in developing authentication systems. - Python experience is a plus

...are not only sent to my email but are also stored in a database for redundancy and record-keeping purposes. ### Requirements: - **Diagnosis and Repair**: First and foremost, the contact form needs to be thoroughly examined to understand why it's generating an error upon submission. This will require an understanding of both front-end and back-end web development, especially concerning form submission processes. - **Email Notification**: Once the form is operational, setting up a reliable system to notify me via email for each submission is crucial. The chosen freelancer should have experience in integrating form submissions with email delivery systems. - **Database Storage**: In addition to email notifications, I want all submissions to be stored in a database. Kn...

I am seeking a Power BI expert who can help me with data visualization, report creation, and the development of dashboards for interactive KPI monitoring. Familiarity with operational KPIs and experience in utilizing SQL databases for data sources are essential. Key responsibilities will include: - Visualizing and interpreting data - Creating in-depth, detailed reports - Designing interactive dashboards to facilitate efficient KPI monitoring The ideal freelancer will: - Be proficient in Power BI tools. - Have experience in the use of SQL databases. - Have a proven track record of operational KPI analysis. I will provide all necessary data from a SQL database. I look forward to working closely with a qualified consultant to improve our ...

I am looking for an experienced web developer skilled in user-friendly design and database management to create an employment website. It needs to have an intuitive interface where both employers and employees can easily register, submit and approve timeshee...generated payment slip with payment details for employers to forward payments and for the employees to view their payslips after adjusting 7. Document upload and download specified to jobs assigned The ideal candidate for this project will demonstrate a clear understanding of database management systems, user experience design, and web development best practices. Proficiency in HTML, CSS, JavaScript, SQL, and experience with user registration systems will be beneficial. Previous experience working on similar platforms will ...

I want Job Portal like ,Backend should be C#/MVC , DB-SQL Server 2019 PFA

Microsoft BI - Project Management and Accounting Solution Introduction This document provides a comprehensive guide on setting up a Microsoft Business Intelligence (BI) solution tailored to track and monitor project management and related accounting. The system will facilitate the control and management of work orders by incorporating features such as client and supplier master data, a detailed general ledger (first note), and advanced functionalities for work order creation, cost allocation, and revenue tracking. Goals: 1. Visualizing revenue and expenses. 2. Creating visualizations for profit and loss statements. 3. Creating visualizations for balance sheets To avoid wasting time, please: 1) refrain from excel only experience, we are looking for MS BI expert only. 2) we have i...

...embarking on a research project that requires detailed data from several Stoic-centric subreddits. Specifically, I'm interested in collecting: - Post titles - Dates of posts - Original post text - Comment text The target subreddits for this project are: - r/Stoic - r/Stoicism I'm only looking to scrape data from posts within a specific date range, which will be shared with the selected freelancer. **Ideal Skills and Experience:** - Proficiency in Python, specifically with libraries like BeautifulSoup, Scrapy, or PRAW for Reddit data scraping. - Experience with data manipulation and storage, potentially using pandas and SQL. - Ability to work with APIs, if necessary. - Familiarity with Reddit's structure and rules relating to dat...

...reviewing, and organizing necessary documents for the application. - **Local Residency Procedures:** Provide assistance in navigating the local residency application process, including paperwork and any required appointments. **Ideal Skills and Experience:** - Fluent in Italian (spoken and written) - Excellent organizational and communication skills - Experience in documentation preparation and procedure facilitation - Knowledge of the Italian legal system, particularly in the context of residency and citizenship - Based in or able to travel to the Lake Como area I am looking for someone who is reliable, meticulous, and with a proven track record of assisting in similar processes. Your understanding of the local bureaucracy and legal framework will be critical in facilitating a...

I am seeking a proficient business research expert who will assist me in preparing the following: 1. You are required to prepare a research proposal on any research topic in any area. 2. Contents of the research proposal would be as follows: a. Select Research Topic...area. 2. Contents of the research proposal would be as follows: a. Select Research Topic b. Introduction 1 page c. Literature Review 4 Relevant Research Summaries i. Research Gap ½ page d. Proposed Conceptual Framework 1-page e. Proposed research hypotheses 1 page f. Proposed Research Methodology 1-2 page i. Research Context ii. Population and Sample iii. Data Collection Procedure iv. Measurement Scales v. Data Analysis Methods g. Time Plan 1 page h. Expected Outcomes 1 page i...

...processes, request submissions, and response management. The development stack should include ASP.NET Core MVC and APIs for data retrieval and manipulation, leverage SQL Server for data storage, be deployable in a Docker environment on local PCs for development purposes, and ultimately, be scalable and compatible with Azure for cloud deployment. High-Level Requirements: 1. User Authentication and Authorization: • Implement secure user authentication with role-based access control. • Support multiple user roles, ensuring proper authorization. 2. Staffing Requests: • Develop APIs for entities to submit staffing requests with customizable parameters. • Ensure a scalable solution for data retrieval and manipulation. 3. Response Management: &bu...

...for broadcasting a wide array of data to a large audience, leveraging information stored in phpMyAdmin. The database contains between 50,000 to 1 million entries, indicating the bot must be optimized for high-volume data handling without interruptions. Ideally, if this could be achieved using PHP, it would align perfectly with my preferences. Key Requirements: - **Data Handling:** The bot should proficiently manage and broadcast text messages, images, and media files (audio/video), sourcing data directly from a phpMyAdmin database. - **Features:** Essential features include the ability to schedule messages, manage a subscriber list effectively, and track message delivery statuses to ensure high engagement rates. - **Performance:** Given the substantia...

...for broadcasting a wide array of data to a large audience, leveraging information stored in phpMyAdmin. The database contains between 50,000 to 1 million entries, indicating the bot must be optimized for high-volume data handling without interruptions. Ideally, if this could be achieved using PHP, it would align perfectly with my preferences. Key Requirements: - **Data Handling:** The bot should proficiently manage and broadcast text messages, images, and media files (audio/video), sourcing data directly from a phpMyAdmin database. - **Features:** Essential features include the ability to schedule messages, manage a subscriber list effectively, and track message delivery statuses to ensure high engagement rates. - **Performance:** Given the substantia...

I need an experienced MS SQL developer to make specific modifications to our in-place custom ERP system. Key Tasks: - Report Generation: The expert should be able to develop new reporting formats, presenting our data in better, more insightful ways. - Data Integration: Seamless integration of data from various sources within our organization is critical. I'm not looking for any user interface modifications at this time, so you can focus on the technical aspects of data handling and report generation. The project should be completed within a month. This role requires a skilled individual with experience in MS SQL and ERP customization. A history of similar data integration and report generation tasks would be advantageous. Your r...

...This tool will play a pivotal role in my ongoing efforts to bolster web application security, and its development will be documented in a comprehensive thesis paper. Ideal Skills and Experience: - Proficient in Python, with the ability to leverage its capabilities in developing a vulnerability scanner. - Deep understanding of web application architectures and common security vulnerabilities (e.g., SQL injection, XSS). - Experience with cybersecurity practices, specifically in vulnerability identification and assessment. - Familiarity with existing vulnerability scanning tools and methodologies. - Strong analytical skills to effectively assess system weaknesses and suggest mitigations. - Ability to document the development process and findings for inclusion in a thesis paper. Ke...

I'm seeking ...understanding of MudBlazor framework. Have a good command over Layouts and Navigation, Forms and Validation, and Data table implementation, crucial for successful project fulfillment. A deep understanding and proficiency with .NET Core Entity Framework and SQL Server is required. If you're a tech-savvy problem solver ready to dive in immediately, this project is for you. Key Requirements: - Expertise in .NET 8 - Proven skills in Blazor, strong understanding of MudBlazor Framework - Solid experience with .NET Core Entity Framework and SQL Server - Ability to start immediately on the project Desired Skills: - Full-stack development - Proficiency in Layouts and Navigation, Forms and validation, and Data table implementation - Good Proble...

Job Title: Senior Full Stack .NET Developer Monday to Friday [Removed by Admin] 4-5 hours/day IST Night (7am to 12pm IST) Salary: 50,0...Salary: 50,000 INR per month Job Description: We are seeking a highly skilled and experienced Senior .NET Developer to join our team. The ideal candidate should have strong proficiency in C#, ASP.NET MVC, and the .NET Framework, along with expertise in various web-related technologies such as HTML, CSS3, JavaScript, and jQuery. Additionally, familiarity with database technologies including SQL Server and T-SQL is essential for this role. One needs to be available in the mentioned timings and willing to work by screen share and remote control via Zoom. Skills Required: C# ASP.NET MVC .NET Framework Entity Framework HTML CSS3 JavaScript T...

I'm looking for a skilled frontend developer to create a dynamic drag and drop tree component for a project. The component should allow users to easily drag and drop items within the same tree and also between two different trees. This needs to enhance the user experience by providing a seamless way to organize information or categories in a hierarchical fashion. Given the details, here’s what I need: - **Development with JavaScript & React.js**: The component must be built using JavaScript and specifically with the React.js framework, leveraging its capabilities for state management and component lifecycle. - **Flexible Drag and Drop Functionality**: The main feature is the drag and drop functionality, which should be intuitive and user-friendly. It should allow it...

I'm on the hunt for a knowledgeable and experienced IT professional who can create custom server performance alerts through SQL Sentry SolarWinds. Outlined below are the specifics of the task: The Alerts: - I require alerts that are focused primarily on the cessation of SQL Services and Browser Services. You'll need a comprehensive understanding of server performance aspects and how to interpret them in a beneficial way. Alert Notifications: - Once these services stop, I'd like to receive both email and push notifications. You'll need to proficiently set up these modes of alerts within the software. Skills Needed: - Proficiency in SQL Sentry SolarWinds - Comprehensive understanding of server performance indicators - Ability to customise alerts a...

...integrating database with website and ensuring data privacy/encryption is implemented on the PII information. Key features needed: - Engaging design that captivates the general public - Functional payment gateway for secure transactions - Quality presentation of astrology focused content - Integration with a database. Please note that I will provide a database design that is to be implemented. Any prior experience with a similar project will set you apart. Looking forward to collaborating with you to make this vision a reality. Attaching an xls that gives high level requirements. Please note that the horoscope creation functionality will be provided by me in the form of a server-side procedure. You just need to be able to call the server-side procedure from fron...

Order Inputs Page 1. Remove “Add Inputs with JSON” button & functionality 2. Store the last entered user input until and unless manually modified. And, in case order type is “Market”, then always display the live price as done by the system currently. 3. “Calculated Quantity” value is not to be stored and should display the value as calculated for given inputs & selected account. Duration: 1 day

I am looking for an experienced frontend developer with some backend, deployment and SQL knowledge to create a personal application for managing my father's business. I need someone who can handle: - Good frontend knowledge - understand backend systems and sql queries - Integration with existing systems - Generate technical helpful utilities for automating small tasks - Have good interaction and team support The personal application should feature: - Inventory management - Accounting of day to day finances - Customer and employee You should have a strong understanding of data security, frontend, deployment and file types. Experience in creating similar apps would be beneficial. PS- Not for an enterprise level application, this will be a tool for my father a...

...scripts and tools to extract data from various online sources efficiently and accurately. This role involves analyzing and collecting data that is crucial for our business intelligence, market research, and strategic planning efforts. The Web Scraping Specialist will work closely with our data analysis and IT teams to ensure the quality and reliability of data collected. Responsibilities: Design, develop, and maintain web scraping scripts and tools to extract data from targeted websites. Ensure the integrity and accuracy of scraped data through rigorous testing and validation processes. Manage and optimize the performance of web scraping activities to handle large volumes of data without compromising on speed or efficiency. Work with ...

** Note: Don`t bother asking me for my budget after bidding on this project as I will not award it to you I need someone to setup Faster-Whisper as a serverless endpoint on RunPod, this using my customized model. Work involves: - Doing a docker pull ( as a serverless endpoint on RunPod, this using my customized model. Work involves: - Doing a docker pull () - Copying my model in the container - Pushing it in a new repository - Creating a serveless endpoint on RunPod which reference the repository - Configuring the RunPod API so that we can use it - Documenting the setup and test procedure so that I can replicate it I will provide you with both a VM (if you need it) and access to RunPod. Thank you

I'm seeking a proficient developer to seamlessly integrate a monthly calendar into our existing Filemaker Pro database system, bolstering our event management capabilities. This enhancement is aimed at not only displaying events stored in our database on the calendar but also empowering users to contribute by adding or editing these events as necessary. I am only interested in enhancing the fledgling existing Filemaker Pro database. I want to start slowly (calendar only) and add capabilities over the next few months. I have attached the database and you can see how I have (not done well) linked a calendar already. I am interested in ony the name of the project to be displayed on the calendar, not time due or anything else. A person can click on the item in the calendar an...

?I cover the full spectrum of AWS Cloud consulting services, from assessments, strategy, and roadmap, to design, build, and migration – and from adoption, optimization, and management to data and analytics and security. ✨My Skills are following : · Deep understanding of cloud and cloud native principles and practices · Hands-on experience with cloud environments - AWS, GCP, Azure · AWS Services:EC2, EC2 container service, Lambda, Elastic beanstalk, S3, EFS, Storage gateway, Glacier, VPC, Direct connect, Transit Gateway, ELB, Auto Scaling, ACM, Cloud Front, Cloud Formation, Cloud Watch, Cloud Trail, SNS, SES, SQS, SWF, IAM, RDS, DynamoDB, Elasticache, Redshift, AWS Backup · Operating Systems: UNIX, Redhat LINUX, Windows · Networking & P...

...for broadcasting a wide array of data to a large audience, leveraging information stored in phpMyAdmin. The database contains between 50,000 to 1 million entries, indicating the bot must be optimized for high-volume data handling without interruptions. Ideally, if this could be achieved using PHP, it would align perfectly with my preferences. Key Requirements: - **Data Handling:** The bot should proficiently manage and broadcast text messages, images, and media files (audio/video), sourcing data directly from a phpMyAdmin database. - **Features:** Essential features include the ability to schedule messages, manage a subscriber list effectively, and track message delivery statuses to ensure high engagement rates. - **Performance:** Given the substantia...

...or entering item details manually. All cataloged items would be stored securely on the cloud, allowing for easy access and management. **Ideal Skills and Experience:** - Proficient in developing cross-platform mobile applications (Especially for Android and iOS) - Experience with cloud storage integration (e.g., AWS, Google Cloud, or Azure) - Strong background in implementing user-friendly UI/UX designs - Knowledge of database management and security - Familiarity with implementing photo capture and upload functionalities within apps - Ability to implement manual data entry features seamlessly into the app interface **Project Requirements:** - Cross-platform development for both Android and iOS - Cloud storage setup for data/image saving - Integration of photo c...

We are in need of a skillful and ...and responsive website. Utilize React.js and Angular.js to build interactive user interfaces and single-page applications. Develop backend functionalities using Node JS and integrate them seamlessly with the frontend. Implement database solutions using Postgres SQL to ensure efficient data storage and retrieval. Optimize website performance and ensure cross-browser compatibility. Stay updated with the latest web development trends and technologies. Ideal candidate: Experienced website developer with expertise in Node JS, Postgres SQL, React.js and Angular.js. Must have a broad knowledge on website development especially for informational websites with e-commerce aspects. This position requires creativity, attention to detail and stro...

Requirements: Experienced in TypeScript and JavaScript. RESTful API SQL schemas JWT/OAuth

I'm seeking an expert in Oracle SQL or PL/SQL to craft a sophisticated query that will be pivotal for our reporting needs. The essence of this project revolves around retrieving data effectively, necessitating an adept handling of multiple table joins. **Key Requirements:** - Deep understanding of Oracle database systems. - Proven track record in writing complex SQL or PL/SQL queries. - Proficiency in creating queries for data retrieval aimed at reporting, with an emphasis on efficiency and accuracy. - Experience with complex joins involving multiple tables, ensuring seamless data integration and optimization. **Ideal Skills and Experience:** - Excellent knowledge of Oracle's advanced features and best practices. - Strong proble...

I am looking for an experienced professional to help me optimize existing SQL queries on a SQL Server database platform. The complexity of the queries is at an intermediate level, and the aim is to optimize performance and potentially add new features where necessary. The ideal candidate should have great familiarity with SQL Server and be able to provide solutions to suit my requirements. I am open to suggestions on how best to approach the project and welcome discussions to come to a conclusion. If you have the skillset and the experience necessary to help me with this project, please reach out to me.