Sql return hierarchical treepekerjaan

I'm experiencing some frustrating problems with my Outlook email. Specifically, I am unable to send emails, which is disrupting my personal and professional communications. Shockingly, this issue is not resulting in any error messages, which leaves me baffled as to the root of the problem. The ideal freelancer for this job has: - Expertise in troubleshoo...which leaves me baffled as to the root of the problem. The ideal freelancer for this job has: - Expertise in troubleshooting Outlook issues - Understanding of common reasons for Outlook sending failures - Skills to implement effective solutions without error messages as guides - Keen to provide insights on preventing similar issues in the future I'm seeking an effective, swift resolution so I can return to efficient e...

I'm looking for an experienced and knowledgeable SQL Server professional who can help me resolve a connection issue I'm experiencing. - **Connection Method**: I'm currently using Windows Authentication to connect to the SQL Server. - **SQL Server Version**: I'm using SQL Server Management Studio 20. - **Error Message**: When trying to connect, I receive an error message indicating that the connection has failed. Ideal candidates for this project should have: - Extensive experience with SQL Server, particularly with the version I'm using. - Proficiency in troubleshooting connection issues. - Strong communication skills to guide me through the resolution process.

As the client, I am seeking assistance in the dissolution of my trust fund. The primary target set is: - Dissolving a Revocable Trust Fund entirely The process will require a professional with a st...Handle potential creditors and diversify my portfolio in line with my financial objectives Expertise in trust law is not just preferred but essential for this task. Understanding the potential repercussions of dissolving the trust, defending against potential creditors, and organizing the redistribution of assets will be required skills. The desired outcome aims for an increased investment return following the dissolution and protection against potential creditors. Diversifying my asset portfolio will also be a critical part of the project. Looking forward to your bids. ...

I'm in need of a professional to optimize my PL/SQL code for better performance. The primary focus of this project is to enhance the overall efficiency of the code. Key Responsibilities: - Perform PL/SQL performance tuning to improve the execution speed of queries. - Implement bulk collect operations to enhance data retrieval efficiency. - Optimize the compilation of procedures for better code execution. I'm seeking someone with extensive experience in PL/SQL, particularly with performance tuning and bulk collect operations. Proficiency in procedure compilation optimization will be a bonus. Your expertise will play a crucial role in achieving the project's goals.

I have an e-shop with more than one shipping zones. Google Merchant Center always disaproove my settings and i think it is because multiple shipping zones. I need an expert technitian to fix this problem.

I'm working on a personal project that requires an alteration of a photo to exhibit moderate damage, similar to the aftermath of a storm. The image must show some broken branches and a sparse tree line for a realistic touch. Ideal candidates should have a solid portfolio of photo manipulation and retouching skills, preferably with demonstrable experience in creating weather-related scenarios in photographs. Understanding of natural elements and how they react to weather conditions will be beneficial for this task.

...amigable e intuitivo que permita a los usuarios buscar partidos / ligas / eventos. Gestión de Usuarios: Implementar un sistema de gestión de usuarios que permita el registro, inicio de sesión y administración de perfiles de usuario con metodologia FREEMIUM Seguridad: Garantizar la seguridad de la aplicación mediante prácticas de desarrollo seguro, como la protección contra ataques de inyección SQL, XSS, CSRF, etc. Equipo Necesario: Desarrollador Full Stack con experiencia en PHP (preferiblemente con Symfony), PostgreSQL y conocimientos sólidos en integración de APIs & Diseñador UI/UX para la creación de una interfaz de usuario atractiva y funcional. Objetivos del Proyecto: Desarrollar un...

...my project. Key Responsibilities: - Enhancing the existing backend system: Your primary responsibility is to enhance the functionality of the current system and optimize its performance. - Integrating SQL/NoSQL Databases: Your expertise in SQL/NoSQL databases is crucial to ensure smooth integration and efficient data handling. - Experience with Python and Minio: If you're familiar with Minio that's a big plus, but Python is the key language you'll be working with on this project. Ideal Candidate: - Proven experience in enhancing existing backend systems. - Proficient in working with SQL/NoSQL Databases and designing queries. - Strong Python skills are a must. - Experience with Minio is an advantage, but not a necessity. This is a great opportunity...

As someone who values efficient and cost-effective operations, I'm intent on leveraging the full potential of my Microsoft SQL Server database. The core of this project involves enhancing performance and decreasing cost. To enrich the function of my database, I'll need an expert who can: - Improve overall performance, guaranteeing smoother, faster operations - Implement strategies for cost reduction without compromising quality and performance The ideal freelancer will be someone with extensive experience in Microsoft SQL Server, superb knowledge in database performance enhancement, and proven strategies for cost-reduction. If you can deliver this, you'd be the perfect fit.

Perfect english is needed. You need to be able to teach and tutor me in relational data bases and sql. You must be able to share screen and communicate quickly and fast. You must be available from today till 24th of May. I'm looking for an experienced database professional to assist with a relational SQL database project. You will need to assist me to answer questions about the following: The required tasks include: - Relational data bases ( administration, normalisation, sql workbench, my sql, data modelling) - Writing SQL queries - Designing the database schema - Optimizing query performance This project specifically involves MySQL, sql workbench, so proficiency in this database system is a must. The complexity level of the project...

I'm looking for a professional who can support me in my Azure Data Factory project. My primary goal is to transform structured data and then load it into Azure SQL Database and visualize it in Power BI. Deal with incremental load, create table relation and contextual data. Skills and Experience: - Proficient in Azure Data Factory - Experience in working with structured data - Expertise in data transformation - Knowledge in loading data into Azure SQL Database - Ability to visualize data in Power BI

We are the largest and fastest growing UK charity community delivering support through multiple services via our website. Our website and AI machine learning and GPT are handled by others. We need dev support for the core SQL system and 2 small SQL directories, plus running reports and system admin. We need full stack Microsoft .NET development experience, strong SQL knowledge and exposure to Azure Microsoft services. We require a range of services. We’ll begin with the ad hoc work to begin to build a working relationship and then build that up to the following on an ongoing basis. • Ad hoc tasks for minor tweaks and changes on an ongoing basis. • Larger pieces of work, such as creating a moving from a free to a free and premium versions, with up...

I'm looking for a talented designer to create a decorative family tree for me. - This design will primarily be used for aesthetic purposes, so it should be visually appealing and suitable for framing. - The final deliverable should be a digital file, so I can easily get it printed and ready for display. Ideal skills and experience: - A strong portfolio of graphic design work, particularly in the realm of family trees or similar decorative pieces. - Proficiency in relevant design software to create a high-quality digital file. - An understanding of what makes a piece visually striking yet suitable for personal display. - File must be submitted in illustrator

- PRESENTATION - We need a small AR projecte for the web, that sho...Before load screen elements - An image is downloaded from a URL that will be used as a marker - A 3D model is downloaded from URL, which is what will be displayed about of the marker - Screen Elements - 1 button to return to main screen - PLANE SCREEN See image "plane " - Before load screen elements - A 3D model is downloaded from a URL, which is what will be displayed on the plane. - Screen Elements - 1 button to return to main screen - PROJECTE WORK-FLOW See this video... - NOTES - Models extensions that should be able to be displayed. fbx, glTF, GLB, USDZ

I am looking for an experienced professional in lawn care and landscape management to take care of my large property (over 1/2 acre). Your tasks would involve: - Mowing the lawn - Trimming the hedges - Weed control measures - Mulching - Pressure washing The candidate should have a...management to take care of my large property (over 1/2 acre). Your tasks would involve: - Mowing the lawn - Trimming the hedges - Weed control measures - Mulching - Pressure washing The candidate should have a proven track record in lawn care and landscaping of similar-sized properties. A meticulous eye for detail is highly important for this job, especially for hard-to-reach areas and tree lines. Efficiency and effective time management skills are also essential as the property has a l...

I'm looking for a skilled PHP developer who can make alterations on my current website. The job involves updating and deleting specific buttons. Ideal skills for this position include: - PHP expertise - Frontend development experience - Proven track r...Frontend development experience - Proven track record of similar projects The work requirements consist of: Button Modification: - Update and Delete functionalities need to be adjusted to drive a smoother UX - Exact buttons cannot be disclosed publicly, those details will be shared privately with the selected candidate. Note: There's no addition of new functionalities or features required. In return for your work, I promise clear communication, prompt payment, and positive feedback for a job well done. I look forward ...

Velocity alert analysis and provide actionable insights. Key requirements include: - Proficient in analyzing velocity alerts using SQL or SPL or Python - Capable of translating data from a word file into actionable insights - Experienced in the field of identity analytics, risk engine, authentication channel for the digital banking platforms - Understanding of Account Takeover (ATO) or digital identity compromise - Leverage known data as it relates to the digital customer identity and risk decisioning. - Analyze data logs from customer authentication channels and digital banking applications for malicious use and bad actors. - Create long-term solutions and automation to processes that can be improved when digital member identity is being utilized. Refer to attached document for b...

We are in need of a installation video and some photos for my product RV roof vent fan The video should be casual in nature and not overly promotional. We will send you the product and no need to return it after it's installed.

We are in need of a installation video and some photos for my product RV roof vent fan The video should be casual in nature and not overly promotional. We will send you the product and no need to return it after it's installed.

I'm going to build auth login page using the react , tailwind css, express Mysql DB. Also we have to join with google acc , facebook acc, apple acc.

Sila Dafter atau Log masuk untuk melihat butiran.

...providing a range of services that include GST registration, monthly GST filing, and GST compliance advisory. Additionally, assistance with income tax return filing will be needed for these clients. Key Responsibilities: - Acquiring new clients who require GST services - Providing GST registration services - Handling monthly GST filings - Offering GST compliance advisory - Assisting with income tax return filing Ideal Skills and Experience: - Proven experience in client acquisition and management - In-depth knowledge of GST laws and regulations - Experience in providing a range of GST services - Expertise in income tax return filing - Excellent communication and negotiation skills Please include any relevant past experience in client acquisition a...

As a sole proprietor, I'm seeking an experienced teacher to provide personalized tutoring on filing B2B GST returns. Although I'm not a complete beginner, my skill level isn't advanced. Therefore, I need an expert who can explain the process clearly and simplify complex procedures. The tutoring I seek should principally cover: - How to handle proper documentation and invoicing for GST returns. Ideal candidates will be: - Practiced educators with a solid grasp of teaching complex processes in an easily understandable manner. - Experienced in GST returns, particularly involving B2B transactions. - Punctual, patient, and detail-oriented. Remember, my goal is to gain a working understanding of how to file B2B GST returns, especially on matters concerning documentation and invo...

I am seeking a skilled designer to Photoshop an asian family into a beautiful natural landscape setting (under a huge elm tree/ with the tree in the background). The goal is to create an engaging image that portrays us enjoying a serene sunset in a field. The image is to be used as a website background, so 16:9 image ratio, svg file format. The main elements (family and tree) should be on the left side of the image, and the right side should be relatively empty for my other website elements. Key Requirements: - Expertise in Photoshop: Ability to seamlessly blend the family photo with the new background while maintaining realistic proportions and lighting. - Understanding of Composition: A good eye for balance and framing to create a visually appealing scene. The fin...

...looks really outdated and does not fit with the rest of the page as it is just the browser’s default style. I would like to change the style of the dropdown to be larger and more aesthetically pleasing while fitting in with the other boxes. Thirdly is the box size for inputs and buttons. I would like the date, time, and return boxes and buttons to be on separate rows and to stretch out / take up the full width available. Same with the dropdowns too please. Fourthly is the return time. I would like to replace this with a duration box. This should be a certain whole number of hours which should be 1 hour, 2 hours, 3 hours, 4 hours, 5 hours, or 6 hours, instead of an end time. Fifthly is the rent a rifle area. Currently, it is a dropdown where you choose to bring you...

The program needs to present a suitable interface (menu/form/web app depending on your ...hours a week • The number of employees who worked more than 40 hours a week • The number of employees who worked between 37-39 hours. f) Once all records are processed, your Program must return to the Main Screen somehow. g) For Option [2] Produce Hours Worked Report, your program is required to read the employee records from file and display them to the screen with the latest entries at the top of the list (sorted). You must give the user the choice for the number of records to be displayed. For example, if the user enters “5”, then the 5 most recent records will be displayed. The program must be able to return back to the Main Screen. h) For Option [3] your progra...

I'm seeking a skilled Google Ads expert to help me optimize my existing campaign with a keen focus on ad targeting, ad copy, and bid strategies. Key Aspects of the Project: - **Optimization Goal**: The primary aim of this project is to enhance the overall performance of my Google Ads campaign through expert optimization techniques. I'm looking to maximize the return on investment and increase the efficiency of my advertising budget. - **Specific Areas for Optimization**: - Ad targeting: I need help refining my ad targeting strategies to reach a more relevant audience that can potentially convert into customers. - Ad copy: Assistance in enhancing the effectiveness of my ad copies to attract and engage the audience, ultimately driving them to take the desired action. ...

I am working on a compiler construction project using ANTLR4+Java (using visitors to walk the abstract syntax tree and visit key nodes), and I need help with semantic analysis.

sistema de ventas en python con sql

I'm seeking a skilled screenwriter to craft a 2hr 35min sci-fi adventure screenplay for my dying friend Gale. The story follows the character of Brynna, a former soldier who must return from retirement to save her new love, Ashten, from the clutches of the villainous Liz-Elf Syndicate. The screenplay should primarily focus on the sci-fi adventure aspect, while incorporating elements of war and romance. The tone of the story should be serious and gritty, to match the intense and high-stakes nature of the plot. The romantic relationship between Brynna and Ashten is central to the story. This should be portrayed as a love at first sight scenario, with the emotional depth and complexities that come with such a connection. Key requirements for this project include: - Strong ba...

...substantial knowledge to revise a financial model specifically for a venture capital investment. The ideal candidate should have proven experience in executing similar financial tasks with the following key competences: - Cash Flow Analysis expertise - Deducing MOIC and IRR Return on Investment - Cap table analysis Here's exactly what I need: - A critical analysis and revision of our existing cash flow. - Recalculating and modifying the MOIC (Multiple on Invested Capital). - Reevaluating and amending the IRR (Internal Rate of Return). Please note that the existing financial model is available for your perusal and to assist in making your accurate bid on this project. Your ability to methodically and accurately complete this task in a short period of time will b...

...avoid generic industry trends, target market demographics, and competitor analysis, and instead, provide a detailed analysis of the market environment where the proposal is targeted. - **Financial Projections**: This section should consist of detailed financial data and projections related to the proposal. - **Org Charts**: I require a clear and concise organizational chart to display the hierarchical structure of the entities involved in the proposal. - **Project Description**: A comprehensive description of the project, its objectives, and expected outcomes should be included. I'd like the design to be visually engaging and easy to follow. Experience in creating business or financial presentations is highly preferred. Looking forward to working with a professional ...

...speech recognition and natural language processing - Experience in developing software compatible with Windows and Mac - Strong understanding of calendar integration and email automation On-Prem Client: Quivr Agent * Installation * Install Quivr Agent on Windows or macOS * Configure Quivr Agent to connect to local database and file system * Local Database * Use Azure Storage or Microsoft SQL Server as local database * Store indexed data and search results in local database * File System * Use Windows File System or macOS File System * Index local files and folders * Search * Search local database and file system for relevant results * Display search results in user interface * User Interface * Develop user interface for Quivr Agent * Inclu...

I'm in need of a professional landscape designer to create landscape plan for attached drawings. auto cad file is available. This project requires a creative mind and an eye for detail. Key requirements include: - Designing a landscape plan for around buildings and drive isles. - Example of work needed provided - Incorporating synthetic lawn small-medium tree in front of each unit - Including garden beds with Xeriscaping landscaping method developed especially for arid and semi-arid climates that utilizes water conserving techniques Ideal candidates will have: - Previous experience in large residential landscape design - Proficiency in using design software and tools - Strong understanding of different types of flora and fauna - Excellent communication skills to understand m...

...'Sample_Step2', stepNum: '2', data: 'Click Button' }, // ... add more data rows here ]; // const handleDragEnd = (result) => { // // ... logic to move items between columns (explained below) // }; const handleDragEnd = (result) => { ('handleDragEnd', result); const { source, destination } = result; // Check if destination is valid if (!destination) return; // Reorder within the same column if ( === ) { ('', ); // ...implementation for reordering within a column const column = columns[]; const copiedItems = [...]; // Create a copy of the items array const [removed] = (source

I'm in need of a web-based job card system that will allow the creation and editing of digital job cards. Both employees and managers will need access to the system, with an admin login section for authorization of completed job cards. We would like the system to link with Quickbooks Online seamlessly, either through Zapier or an SQL database connection. This will allow completed job cards to be sent to Quickbooks for automatic invoice creation. Managers can then authorize on Quickbooks before sending. Key Functionalities: - Creation and Editing of Job Cards: The system should enable the easy creation and editing of job cards through a user-friendly web form by both employees and managers. Employees can then select their name from a drop-down combo box if they have worked on...

As a client seeking a skilled Revit expert to finalize my ongoing project, I require the addition of various elements: - HVAC Pipes: Specifically, I need someone with experience in supply ducts, return ducts, and exhaust ducts. - Technical Room: The inclusion of a complete technical room is essential. - Other Details: Additional small features, particularly plumbing fixtures, are also needed. Ability to maintain high accuracy and give attention to minute details is crucial. Proficiency in HVAC systems and building technology is a must. The person should also have problem-solving skills to deal with challenges that may arise during the project. Previous experience related to this kind of task will be valued.

...stage. - Strong Network: Leveraging your connections to high net worth individuals is crucial. I need to tap into your relationships to pitch my business concept. - Industry Experience: Having a background in raising funds for roll ups, specifically within accountancy practices, is a nice to have. - Geographic Focus: The roll-up is focused in the UK but investors can be from anywhere. The return on investment for the investors will realistically be around 650% cash on cash in 5 years time with dividents from year 2. This is a lucrative opportunity in a very stable market....

I'm in need of a photo editor who can skillfully remove a tree from a picture of a house. This is a simple task but requires precision and attention to detail. Key Requirements: - The selected freelancer must have substantial experience in photo editing and retouching, particularly in object removal. - Proficiency in image editing software like Adobe Photoshop or GIMP is needed. - The primary objective is to show the house without the tree in front. Please include relevant examples of your past work in your application. Your work samples should demonstrate your capabilities in object removal and photo retouching.

...Significant experience working with SAP Cloud ALM data sources - Proven ability to provide step-by-step instruction catered to a beginner - Patience and passion for teaching complex topics in a simple to understand manner I'm eager to learn, and I look forward to your bid. Let's delve into data together and create a powerful Grafana dashboard. We have an example blog here. I will use my laptop as a test mashine, for this POC. So that is where we will be working. So we have to work on a shared screen, where you guide me what to do, to make it work. If you are not ok with thi, then

I'm seeking a talented professional to create a 35-45 second 3D animation commercial for my label. If you have the ability to turn the silhouette of the girl in my original label into the gold palm tree, please contact me. Basically looking for someone to take an existing label for an alcohol brand and show the evolution to the new label. I would like the girl to morph into the palm tree logo. Requirements: - Proven experience in creating high-quality 3D animations - Adept in crafting abstract designs - Portfolio showcasing ads and 3D animations Ideal Skills: - Proficiency in popular 3D animation software - Strong understanding of animation principles - Commercial and product advertising experience This project demands creativity, technical ability, and an unders...

...was a little sun in his heart, which could dispel the darkness and bring warmth. Jennifer was deeply touched by Michael's words, as if she could see the fear in her heart being gradually dispelled by the warmth of the lamps. They began to communicate frequently and soon fell in love. Whenever night fell, Michael always turned on his handmade lamp and stood in the doorway waiting for Jennifer's return. Whenever Jennifer saw the lamp, all the anxiety and fear in her heart would dissipate. She fell deeply in love with this attentive and affectionate man, and they spent a lot of good time together: Michael would teach Jennifer how to make the lamp, letting her feel the joy of creation; and Jennifer would tell Michael her stories and dreams, letting him know more about her ...

...converters, and Chat GPT. • Design encrypted communication systems for secure email interactions between customers and third parties. • Automate database updates and manage structured databases for different user types. • Collaborate with frontend developers to ensure system consistency and reflect design changes. Requirements: • Profound knowledge of PHP and Laravel framework. • Strong experience with SQL database management, design, and optimization. • Ability to implement APIs and manage external data integrations. • Understanding of encryption and secure communication protocols. • Ability to work in a team and adapt to evolving project requirements. Desired Skills: • Prior experience in the travel industry or similar sectors. &bu...

...the company’s capital structure. - Calculate the cost of debt from financial reports. - Equity Required Rate of Return: - Apply the Dividend Growth Model (DGM) and the Capital Asset Pricing Model (CAPM) to calculate the required rate of return on equity. - Describe each model and show detailed calculations. - Market Return Calculation: - Use historical prices from TADAWUL to calculate the market return. - Explain how this figure is used in the CAPM. - Beta Utilization in CAPM: - Describe what beta represents and how it influences the CAPM. - Use the company's beta from Yahoo Finance in the CAPM formula to calculate the expected return of the stock. - Risk-Free Rate Utilization in CAPM: - Ex...

I'm seeking to develop a robust safety system for a large, multi-leveled mine. The device should be capable to scan gas concentrations even without specifics on the gas type. Consequently, experience in developing wide-spectrum gas detection tools would be advantageous. Key Responsibilities: - Understanding the features and architecture of the LoRa module for effective data return to base station. - Developing a scalable solution suitable for a large, multi-level mine configuration. - Leveraging the provided materials for development. Please note these materials will be sent to your location. Ideal Skills and Experience: - Proficiency in working with LoRa modules. - Experience in designing safety systems for mining environments. - Knowledge in gas detection technology and e...

...will share data to an SQL server. This needs to function within a SAAS environment with subscription per device. Main features include: - Admin and User Modules - Managed subscriptions per device - Real-time data alerts In the Admin Module, the following functionalities should be available: - User Management: Admin can manage and monitor users - Device Permissions: Admin can determine how much data a user can view - Monitor Device Data: Admin can view data from all devices - Payment Module: Ability to process transactions For the User Module, users should be able to: - View specific device data as permitted by the administrator - Receive alerts via data changes - Make payments for their subscriptions The ideal freelancer would have experience with IoT systems, SQL data...

am seeking a highly skilled and experienced media buyer who specializes in Facebook ads with a focus on lead generation. The ideal candidate will have a proven track record of delivering exceptional ROI (Return on Investment) and ROAS (Return on Ad Spend) through strategic Facebook advertising campaigns. Responsibilities: Develop and execute effective Facebook ad campaigns to generate high-quality leads. Conduct thorough research and analysis to identify target audiences and optimize campaign performance. Monitor and optimize ad performance based on key metrics such as conversion rates, cost per lead, and overall ROI. Collaborate with the marketing team to develop creative ad content and landing pages that drive engagement and conversions. Stay updated on industry trends an...

I'm looking for an API developer who can help me with a project. The ideal candidate should be Responsibilities: Design and implement highly flexible, asynchronous, secured and scalable API Build and modify high-performance APIs and programs using C#, .NET Core based on architecture frameworks and guidelines Prepare API Collection and Documentation Co...GraphQL and gRPC is an added advantage Knowledge of Web Services and understanding of service-oriented architecture (SOA) Proficiency with common API development frameworks/tools, including .NET Core 6+, MS Visual Studio, XML, JSON, TFS, GitHub, Postman and IIS Experience in integration of external systems, third-party APIs, payment gateways and cloud services are added advantage Knowledge in MS SQL Server and DB First appro...

...You will be primarily responsible for backend development and Database management, but also need to handle some Frontend Development tasks. Key Responsibilities: - Backend Development: You should have a strong understanding of Node.js, and be able to build efficient, scalable, and secure backend systems. - Database Management: Proficiency in database management is crucial. Experience with both SQL and NoSQL databases will be a plus. - Frontend Development: While the primary focus is on backend, you should also have some experience with frontend technologies to assist with the development when needed. Ideal Skills: - Proficient in Node.js - Strong background in Backend Development - Experience with Database Management - Basic understanding of Frontend Development Please note t...

I'm seeking an adept vb.net coder to design a desktop-based GST billing software that primarily integrates with SQL Server. While there aren't any specific features I've outlined, I'm hoping to work with someone who's knowledgeable about the typical functionalities of GST billing software. This expertise will be critical in shaping the software's development. Critical skills and experience required: - Strong proficiency in vb.net - Familiarity with SQL Server - Previous experience designing billing software - Understanding of GST's impact on invoice generation, tax calculation, and inventory management