Write sql query for getting direct and indirect reportees of a given employee jobs

...looking for a CISCO VPN setup that will allow 1-10 remote employees to securely access our network. Key Requirements: - Compatibility with Windows: Since our employees primarily use Windows machines, the VPN should work seamlessly on this operating system. - Remote employee access: The main purpose of this setup is to allow remote employees to securely access our network from their location. Ideal Skills: - Experience with CISCO VPN: I'm looking for a professional who has successfully set up CISCO VPNs in the past. - Strong understanding of network security: It's crucial that the VPN is secure and properly configured to protect our network from potential threats. - Windows networking expertise: Since the setup needs to ...

I'm in need of a Power Automate expert who can create a workflow system for me. This project involves getting tasks from rows in Excel and mapping them to individual tasks on a Planner board. Ideally, each row in Excel would correspond to a separate task on the Planner board. Skills & Experience: - Mastery in Power Automate - Solid experience with workflow creation - Strong knowledge in data management - Familiarity with Excel and Planner integration - Ability to deliver tasks promptly and accurately Your job is to ensure a seamless process of data management, with all tasks neatly organized and displayed on the Planner board. With your help, task automation will come to life, enhancing m...

I'm in need of a virtual assistant to help manage my daily inventory data updates and email handling tasks. Responsibilities: - Daily Inventory Data Updating: You'll be responsible for keeping our inventory records up-to-date. This will include tracking stock levels, monitoring product movements, and ensuring all changes are accurately reflected in our system. - Email Handling: I need someone to manage my email correspondence. This will involve: - Responding to Customer Inquiries: You'll be required to engage with customers who reach out via email, answering their questions, and addressing any concerns they may have. - Managing & Organizing Emails: Your role will also involve organizing my inbox, ensuring nothing gets missed...

I'm a BCA student with proficient skills in Microsoft Office, Access, Oracle & my SQL. I'm currently seeking a freelancer with advanced data entry proficiency to assist with data entry tasks. Specifically, I need help with: - Entering data into a document - Ensuring that the document has advanced formatting requirements, including tables, charts, and images Ideal skills and experience for this job include: - Proficiency in MS Office Suite (Word, Excel, PowerPoint, Access) - Experience with advanced document formatting - Attention to detail - Ability to work with data accurately and efficiently Please note that while my project is mainly focused on data entry, a background in database management and ...

I urgently require a proficient SQL Server expert, particularly conversant with SQL Server 2012. My primary challenge is recovering deleted records. Ideal Skills: - Comprehensive understanding of SQL Server 2012 - Expertise in data recovery processes Experience Required: - Proven track record in database recovery - Past work with SQL Server 2012 Your immediate availability for this project is essential. Please, only serious and experienced candidates should bid.

I'm in need of a website developer with a flexible skillset, considering the purpose and type of the website and design preferences were not specified: - Since the type of the website wasn't chosen, it's likely that we may have to go through a few iterations before landing on the final product. You should have experience with developing a variety of website types including but not limited to E-commerce, blogs, and portfolio websites. - The purpose of the website is also open-ended, so freelancers with a background in creating websites that serve multiple purposes such as sharing information or content, selling products or services, and showcasing portfolios or projects would b...

I'm looking for a skilled Python developer with experience in web scraping and Selenium. Your task is to extract a domain list from a given URL (). The data extracted should be cross-referenced for each domain with the following fields: name, full address, email, and phone. Key Requirements: - Extract domain list from a specific website () - Implement cross-referencing for each domain with name, full address, email, and phone - Proficiency in Python and Selenium for web scraping - Ideally, experience with data cleaning and manipulation Please note that the number of records on the dealer locator is unknown. Your ability to handle large data sets will be crucial for the suc...

I am aiming to have a pi zero programmed to read voltage levels from a 12-volt battery bank. The trigger to start the generator should be a low voltage condition. The purpose of this project is to remotely start the generator, with a focus on maintaining efficiency and practicality through a direct physical connection. Key objectives include: - Programming the pi zero to accurately gauge low voltage conditions - Enabling the generator to automatically power up in case of a drop in voltage. - Continuing the generator input even after the voltage returns to normal, with this feature designed to maintain a steady and reliable power supply. Ideal Freelancer Skills: - In-depth understanding of Raspbe...

I need a seasoned designer to create a modern and sleek pitch deck for my upcoming event. The purpose of this pitch deck is to attract potential investors. - The ideal candidate should: - Have prior experience in designing pitch decks - Be proficient in creating professional and modern designs - Have experience in incorporating financial projections and market analysis into a visual format - Be able to translate complex data into visually appealing infographics - Be able to adhere to strict timelines and deliver quality work within the given timeframe The pitch deck should include: - Financial Projections: This should clearly and effectively present the financial outlook of the event, maki...

...deploy a private email server on our internal infrastructure. The goal is to enhance security, ensure data privacy, reduce dependency on third-party email services, and customize the email system to meet our specific needs. The project will involve setting up the server, configuring DNS records, installing and configuring necessary software, securing the server, and ensuring seamless email access for all users. Key Deliverables: Infrastructure Setup: Set up a dedicated server or VPS with a static IP address. Configure necessary storage and network resources. DNS Configuration: Configure MX, SPF, DKIM, and DMARC records to direct email traffic to the server. Software Installation and Configuration: Install ...

If you are familiar with AWS programming, this should be a simple task for you. I have included an example C# solution using AWS Transcribe that I need to be working. Example Program: AWS Transcribe documentation: Requirements: • I will create a new AWS free account and will supply credentials. • In my AWS account, configure any IAM role/policy/user/credentials needed to run the example program. • Change the example program to accept credentials (accessKey/secretKey) as arguments passed to the executable. • Ensure that the corrected code successfully converts the speech in the audio file to text using the AWS Transcribe service. Deliverables: • All source code • Instructions

I'm in need of an expert who can secure both indoor and outdoor venues for a variety of events including weddings, corporate events, and concerts. The venues should accommodate up to 50 guests. Essential requirements for the job include: - Extensive knowledge of available venues suitable for a range of events - Excellent negotiation skills for getting the best booking rates - An understanding of the logistical requirements for each event type Candidates with experience in event planning, venue sourcing or a related field will be highly regarded. It's crucial that you are detail-oriented – I need someone who will consider all variables to select the perfect v...

Hi Zainab528, I noticed your profile and would like to ask about getting you to redesign / reproduce a couple of Leaflets for me. I have some existing ones for 2 of my products, and will shortly need a third one. The two I already have I need producing into a format that I can upload to my website. I can send you PDF copies of them for you to look at and give me a price? Thanks, Dan

I am in need of a skilled developer to assist with an existing API integration between SilverStripe website and REX Software, with a focus on correcting a data issue that is causing the server to fail with backing up the website due to disk usage. The server technician said: "The disk usage is at 80% so a dump would fail as it would need more space to create a sql file to be transferred. It looks to be an issue with REX and the website framework SilverStripe. It may be that REX is not configured to remove (dump) old data." Your role will involve correct the error so the server does not continue to reach its disk usage and implementing a seamless API integration that successfully synchronizes and...

I'm seeking an experienced web designer to create an informational website for me with a focus on usability and aesthetics. Key features must include an interactive contact form, providing direct communication between visitors and myself. Additionally, the site must be optimized for mobile viewing, ensuring a seamless experience across different devices. Ideal skills for this project: - Web design expertise, with a special focus on informational sites - Experience in creating interactive contact forms - Strong understanding of mobile optimization to ensure cross-device compatibility

I need a Python program that can tap into Yahoo's fantasy football datasets using their API and extract various essential pieces of historical league-specific information. The main requirements of my project include: - Extracting information like player statistics, team standings, draft results, transactions (trades and adds/drops), weekly schedules (head-to-head matchups by week), weekly lineups, scoring settings, and league settings The Yahoo API Endpoints you'll need to use as inputs to derive the above data extracts for a particular league are: - the associated League ID (each league created by Yahoo is given it's own unique ID that a league member can provide) - the associated Game Key (there is ...

I am urgently in need of an expert in Docparser. I have several PDF documents from which I need to extract specific information in the form of both text and tables. Therefore, the successful candidate must have: - Extensive experience with Docparser - Strong ability to identify and extract specific text and tables from PDF files - Proven track record of delivering tasks promptly Given the urgent nature of this project, applicants who can start and deliver this project ASAP will be highly appreciated. If you are proficient in Docparser and can handle this task accurately and quickly, please bid. ~~~ I have 4 different vendors that we buy from, each having different invoice styles and details. I have all ...

I need an intellectual mind t...worksheets. The project involves extensive research, creativity, and a deep understanding of the high school biology curriculum. Specifically, you will be: - Developing a variety of worksheets on various topics in high school biology. - Creating content that is engaging, challenging, and interactive. Ideal Skills: - Experience with educational content creation, particularly in biology. - Sufficient knowledge in high school-level biology. - Ability to meet deadlines and follow instructions. This project will require consistent communication to ensure the content produced meets my standards and follows the given guidelines. It is not only a chance to showcase your prowess in biology bu...

I am looking for a professional sales specialist to promote and sell employee benefits, including health insurance, retirement plans, disability insurance, and ancillary-life and health supplement. • The candidate must have a background in sales, preferably with experience in similar products and services. • Key expertise: Sales strategy, customer relationship management, and excellent communication skills. • The focus is on small businesses with fewer than 100 employees. Therefore, understanding of this market segment will be beneficial. • This position is not aimed at a specific industry; instead, it applies to all small businesses across industries. So, versatility and the ability ...

I'm in need of a software that can handle all my accounting needs, as well as the management of employee-related tasks. Here are the specifics: - **Expense Tracking:** - Automatically import expenses from bank statements - Generate detailed expense reports - **Payroll Management:** - Calculate salary, deductions, and taxes for each employee - **HR Functionality:** - Manage employee profiles and contact information - Store and retrieve employee-related documents The ideal candidate should have extensive experience in developing accounting software, payroll systems, and HR management tools. The software should be comprehensive, yet user-friendly, with a focus on efficiency and...

• Description I'm looking for a part-time administrator to assist with data entry and VAT calculations for half an hour per month initially. Initially, we need monthly half-hour administration support to: 1) Copy and paste the Revolut bank statement into a spreadsheet. Then, select the appropriate category for the item. You also have to copy and paste or calculate the VAT for the item. 2) Copy and paste the bank statements (an estimated 6 bank accounts) and select the appropriate category for each item. • Delivery You will be given a Google Sheet template and bank statements to work on. You will work autonomously with minimal supervision. • Workplace You will ...

I'm running a Node.js website where the last user's data is mistakenly being displayed to the first user. This isn't the intended functionality, and I need an experienced developer to solve this issue promptly. Key Responsibilities: - Investigate the current data display functionality and how it's handling user data. - Correct the code responsible for showing the last user's data to the first user. - Ensure that the correct user data is displayed to each respective user post-login. Ideal Freelancer: - Proficient in Node.js with a deep understanding of data management and display. - Experienced in SQL databases, specifically in managing user data. - Previous experience in debugging and resolving simila...

• Description I'm looking for a part-time administrator to assist with data entry and VAT calculations for half an hour per month initially. Initially, we need monthly half-hour administration support to: 1) Copy and paste the Revolut bank statement into a spreadsheet. Then, select the appropriate category for the item. You also have to copy and paste or calculate the VAT for the item. 2) Copy and paste the bank statements (an estimated 6 bank accounts) and select the appropriate category for each item. • Delivery You will be given a Google Sheet template and bank statements to work on. You will work autonomously with minimal supervision. • Workplace You will ...

Please Sign Up or Login to see details.

...existing website, , enhancing its user interface and integrating it with social media platforms similar to Here are the specifics: - User Interface Enhancement: I anticipate a website that is user-friendly, visually captivating and easy to navigate. Your experience with UI/UX design will be vital here. - Social Media Integration: The website should have functionality to share our products/services directly on social media platforms. - Mobile-friendly Design: Although not explicitly mentioned, I consider it a given in today's digital age. The revamped website must be fully optimized for mobile users. - Showcasing Products/Services: The main objective of the website would be to showcase our products and services effectively. Y...

...Full-Stack Developer for WordPress, .NET Middleware, Azure Integration, and SDK Development Job Overview: We are seeking an experienced Full-Stack Developer to spearhead the development and integration of key system components within our e-commerce platform. The successful candidate will lead initiatives to enhance user interactions by developing a WordPress plugin, building a robust .NET middleware API, and integrating advanced Azure-based messaging services. Additionally, the role involves creating an SDK to facilitate easy integration for third-party AI bot services. This position is crucial for ensuring that our platform not only meets current technological standards but also adapts to future advancements and use...

I'm seeking a skilled landscaper to help design a plan incorporating rain gardens into my currently empty land. Looking for someone to review the draft plan I created for general thoughts and suggestions. However, it's important to note that native plants will be the heart of these gardens. Note one of the main key requirements is the offset of impervious area for mitigation purposes relating to placement within the RPA. Key Requirements: - Must have excellent knowledge in landscaping and rain gardens. - Experience in working with native plants is preferred. - Ability to advice on the best landscape design for an unspecified area. - Capability to handle my project from the planning stage to execution...

I'm seeking a skilled developer to revamp or given me a new design for my existing WordPress website, , by migrating it to NextJS. This project encompasses several key aspects: - Redesign: I envision a clean, minimalist interface for the website. This would involve simplifying the layout, enhancing user experience, and ensuring a modern look and feel. - Performance Optimization: The upgraded website should significantly improve in terms of speed and performance. The transition to NextJS should play a key role in enhancing the overall performance of the site. - Additional Functionalities: I aim to introduce new features to the website, specifically: - User Registration and Profiles: T...

...male and female voices. The aim is to have a diverse pool of vocal talents for a 1 minute ad. Pry 30 seconds of total voiceover work is needed and needs to be layered on top of a video. Key Requirements: - Diverse gender representation: Both male and female voices are needed. - Accents and Languages: All selections should be in American English. - Age Range: I require a mix of voices representing both Youth (under 18) and Adult (18-64) age groups. Ideal Skills and Experience: - Professional Voice Actors: Experience in voice acting, with a range of vocal styles and inflections, is a must. - Variety in Portfolio: A diverse portfolio showcasing prev...

...need of training facilitators who specialize in delivering seminars and workshops centered around leadership development. More specifically, a focus on transformational leadership. Ideal Skills and Experience: - Proven experience as a trainer, preferably in leadership development - Proficient in developing and conducting transformational leadership programs - Exceptional public speaking and communication skills - Up-to-date knowledge of latest leadership development and training techniques and methodologies Job Task: - Designing transformational leadership development programs - Conducting and facilitating leadership training seminars and workshops - Providing constructive feedback to participants As ...

I'm looking for someone to help me create a list of 2000 business contacts from specific websites, particularly names, company names, position, location information, event information, number of events, current events, past events in 2024, and email addresses. I would like this list to be compiled through online research only. Key responsibilities: - Researching and compiling a list of business contacts - Ensuring all email addresses are verified and duplicates removed. Note: The focus should be on getting accurate, up-to-date information.

I am seeking a professional grant writer to help me secure available minority grants for my carpet cleaning business. This will mark my first foray into grant applications, hence I am looking for a specialist who can guide me through this process effectively. Specifically, I need assistance with: - Writing a persuasive grant proposal. While I am open to providing any needed information about my business, I rely on your expertise to translate it into compelling content that would maximize my chances of getting the grant. Ideal skills and experience: - Experience with grant applications, particularly minority grants for small businesses. - Outstanding written communication to eloquently express my business needs and po...

Hi, I hope everybuddy is doing well. I am looking for someone capable of writing high-quality niche articles without plagiarism and without using AI for my blogs. The topics can vary, ranging from news to technology. The work needs to be done directly in WordPress, on the domain I provide. It is necessary to upload relevant images and make the logo to match the niche, and ensure that the website complies with all AdSense program policies. I am seeking someone who can assist me long-term in this project, which I am undertaking with several partners. I need qualified manpower. Thank you! Best Regards,

I need a small application prototype with the following features: Multi-Employer Job Portal/Admin app (Role Based access) User/applicant App (for Multiple applications to different employers) User Profile Document Upload (Save documents to Db and attachments to Blob Storage ) Send Emails to Employers and applicants back and forth 2 Apps in total ie. admin app and applicant app. job application requirements will be provided. Nodejs, angular, My SQL, ORM, Data Seeding, Migrations should be used.

I am looking for an expert web developer well-versed in designing highly effective, SEO-optimized websites with a knack for understanding the tax relief industry needs. Key Features: - Integration of an online contact form, live chat support, and a space for showcasing client testimonials. - Design the website drawing inspiration from high-traffic sites within the industry like Omini Tax Relief and Optima Tax Relief. Ideally, you should have: - Significant experience in creating successful, high-traffic websites. - A sound understanding of SEO principles and direct experience in implementing them. - The ability to make effective design decisions in line with the industry's expectations and cu...

I am in need of a designer who can create a flyer and postcard full of color and energy for my rental consulting company. This project demands a good understanding of vibrant and captivating designs that seize the attention of the viewer and don't let go. Key Responsibilities: - Develop a bold and colorful design that incorporates company branding - Convey the concept and purpose of the company effectively in the given design Ideal Skills: - Expert in Graphic Design - Strong understanding of branding and promotional designs - Experience in creating flyer and postcard designs I am seeking a quick learner who can grasp the essence of...

I'm in need of a freelancer to assist with labeling text tweets by topic (to aid in machine learning research). Key Requirements: - Labeling 1,000 tweets as to whether they are about the topic sustainability - Must be labeled by hand (no machine learning or AI) by a native English speaker Task: -Open the attached spreadsheet -Read the FULL TEXT of each tweet. Also read the brand handle and sector for reference. Make sure to pay attention to any hashtags included. -You do not need to open any URLs. Make your judgment based only on the text. -If the tweet is about sustainability, enter "1" in column E. If it is not about sustainability, enter "0" in column E. -Note that "sustainability" is a broad topic -...

I'm in need of a professional who can address the issues with my current website, which is about 5 years old and has been experiencing error messages. If it's a quick fix, we can proceed with that, but the main aim is to transition to a new solution. Key Tasks: - Review and fix the current error messages. - Backup the current website to prevent data loss. - Develop a new website from scratch, ensuring a clean installation. - Migrate our existing data to the new platform. The key focus for the new website should be on enhancing security, given our experiences with the current site. Content Transition: We aim to maintain the current content with only minor updates. It's important that the freelancer resp...

...looking for an experienced social media marketer who can create an Instagram ad that will direct users to my Telegram channel. Key Points: - The primary goal of the ad is to promote my latest product, Medical Gummies, so it's essential that the ad is engaging and attracts potential customers. - The link in the ad should seamlessly lead users to my Telegram channel, where they can learn more about the product and potentially make a purchase. - It's important that the ad is set up in a way that maximizes conversions and ensures that users are actually redirected to my Telegram channel. Please only apply if you have experience in creating effective Instagram ads and have a strong understanding of how ...

As someone who runs a professional services business, I am actively seeking an expert who can effectively use Instagram's Direct Messaging feature for marketing our services. The ideal freelancer will text leads in Italian language. Just need to copy and paste our messages

I am looking for a skilled developer to create an engaging Employee Pre-Verification system. This system will focus on Background check and Referral check. Key Functionalities: - **Background Check**: This system should have the ability to conduct background checks on potential employees. This can involve checking criminal records, credit history, and other relevant information. - **Referral Check**: The system should also incorporate a referral check system. This can help verify the authenticity of the references provided by the employee. User Interface: - The UI of this system should be interactive and engaging. This will ensure that the system is not only functional but also user-friendly. Reporting System: - The ...

...Challenge! We are looking for a creative and original logo design that embodies the essence of our wellness center, focusing on energy-based work and spiritual practices. Our center offers a variety of services and activities aimed at promoting holistic well-being, personal growth, and spiritual development. The design should reflect our integrative heart-centered approach, helping individuals transcend to their higher selves and empower them on their journey towards optimal health, inner peace, and spiritual enlightenment. Design Guidelines: what we consider when we assign star ratings: 1. Name of the logo must be found in the logo and it should be easily readable: From The Inside Out Wellness ...

I'm urgently requiring a skilled professional to assist with three key HR functions in my growing small business. These include: - Hiring and Recruitment: Expertise in this area is especially critical as choosing the right candidates is the backbone for a successful venture. - Training and Development: Your role would be to design and implement development strategies to nurture employee skills and maximize their job performance. - Performance Management: To ensure alignment with business goals, you would be in-charge of setting up a performance management system and spearheading the process. It is paramount for the ideal hire to have experience with implementing such functions within a smaller...

I'm looking for an experienced WHMCS developer to help improve an already developed financial history graph. I had a developer from before that told me he could improve the module by take order dates and other dates already in the database to fill in missing data of the graph. Right now the graph just records order and financial information in the database and displays it on the graph. Where there is no data the graph just shows a straight line as shown in the demo screenshot. So I want the graph to show the data that its table is missing by getting this information from the WHMCS database. The end result would fill in the missing data of the straight line and also show the history on the graph from the start of...

I'm seeking an experienced graphic designer to create an abstract Twitch logo for my channel. Here's what you need to know about my project: - Color Scheme: I'd like it to be black and red. - Style/Theme: This design should be abstract and id like it to include like a graphic kind of heart Given the nature of my request, you should ideally have a strong background in designing abstract art and a good eye for color combinations. Familiarity with Twitch and understanding of its design aesthetics would be a great plus. Make your bid if you're up for the challenge!

...experienced Excel expert to help resolve an issue with a percentage calculation in my Excel spreadsheet. Despite following standard procedures, the result is incorrect, and I need assistance to identify and correct the problem. Details: I am working with the following data in my spreadsheet: Total Costs for the Job (Cell V14): $241,779.50 Total Collected (Cell V17): $289,844.00 Profit (Cell V15): Calculated as =V17 - V14, resulting in $48,064.50 I need to calculate the profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is: = ( ? 15 / ? 14 ) ∗ 100 =(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ) ∗ 100 = 19.88 % =(48,064.50/241,779.50)...

I need a skilled Adobe Illustrator professional to convert a logo from PNG to SVG. The aim is to optimize the SVG for web use, ensuring it remains scalable, editable, and suitable for online platforms. Key requirements: - Conversion from PNG to SVG: The logo is currently in PNG format and I need it to be converted to SVG. - Scalability: The resulting SVG should be scalable to any size without losing quality. - Optimization for Web Use: It's vital that the SVG is optimized for web use. This includes ensuring the file size is minimized for fast loading times, and that it retains its quality across various screen sizes and resolutions. Ideal skills and experience for this job include: - Profic...

...looking for an experienced UI/UX designer to create an interactive design for our property management application using Figma. The application is intended to streamline property management operations, offering functionalities like task management, team coordination, guest management, and more. Scope of Work: The designer will be responsible for: Creating an interactive and user-friendly design in Figma Developing wireframes and prototypes based on provided sketches and descriptions Suggesting and implementing improvements to enhance usability and aesthetics Ensuring responsive design for both web and mobile views Pages to Design: Home Page: Displays an overview of tasks, notifications, and...

I'm in need of a digital marketing specialist with a specific focus on Snapchat. This is a project for a brand aimed at adults, particularly married individuals and those in need of loans. The primary objective of this campaign is to increase brand awareness and encourage people to send whatsapp messages. please note: the ads are for loans with 2% interest You'll be required to: - Create and implement a Snapchat marketing campaign targeted at adults and married people - Focus on increasing brand awareness for our products - Direct the Snapchatters to engage with us via whatsapp Your experience with Snapchat marketing is essential. Understanding the dynamics of...

We are seeking a skilled graphic and logo designer to recreate 5 logo designs based on provided samples and instructions. This project offers an excellent opportunity for designers to showcase their creativity and attention to detail. Responsibilities: Recreate 5 logo designs using the provided JPG files and instructions in a Word document. Follow the given logo concepts, sample designs, and color combinations closely. Make minor adjustments or enhancements as per the specified instructions. Ensure high-quality output and pixel-perfection in the final designs. Requirements: Proficiency in Logo designing Ability to interpret and execute design instructions accurately. Willingness to collaborate and incor...