How to calculate overlapping time in sqlроботи

Доброго дня! Шукаю фрілансера, хто міг би допомогти час від часу писати коди SQL запитів для SAP B1.

...Супроводження процесу впровадження. Вимоги: • Досвід роботи – від 2-х років. • C++11, STL, GCC/CLang, GDB/LLDB, GNU Make, CMake, Bash. • Знання STL — контейнерів та алгоритмів. • Знання файлового вводу/виводу у стандарті POSIX. • Знання POSIX Threads —нитки, м’ютекси, умовні змінні. • Вміння користуватися системою контроля версій Git. • Вміння користуватися командним рядком Linux. • Реляциійні БД, SQL. • Основи функціонування комп’ютерних мереж, протоколи TCP и HTTP. Знання HTTP/1.1. Знанння архитектури REST. • Багатопоточність. Буде плюсом: • C++14, 17, 20. • Qt. • Boost. • Засоби статичного і и динамічного анализа коду (cppcheck, clang-tidy, clazy, valgrind, gprof, &helli...

... Шукає Unity розробника для створення багатокористувацької браузерної 3D гри, Unity за допомогою WebGL. Обов'язкові навички: Вміння працювати в Unity і знання мови C#. Плюсом буде додаткові знання: JS, HTML 5. І back end розробника для написання серверної частини на ASP.NET Core. Обов'язкові навички: ASP.NET Core Entity framework core SQL С кидайте свої резьуме на: business@ або проджект менеджеру проекту: viktorstor@ KICKOOS GAMES - це молода outsourc GameDev компанія, що з недавна почала розробляти і внутрішні проекти. Друзі компанія зараз розширюється і влітку планує відкрити офіс в Україні, тому долучайтеся до нашої спільноти у телеграмі, де публікуются відкриті вакансії на різні позиції.

Потрібно зробити легкі лабораторні роботи, терміново! Файли прикріпив, за потребою скину методичку.

Я маю довгострокову роботу, яка пов'язана з нашим попереднім проектом 'Change Framework CMS from Shopify to Prestashop - PHP, HTML, CMS, SQL'

...experience in Power Apps and Power Automate • Experience in developing Canvas and Model-driven Power App applications • Experience in developing the applications connecting to SharePoint, SQL, Oracle and external APIs • Experience in building automation workflows using Power Automate Development 1. Hands-on Expertise in Power Platform • Expertise in design and develop custom business apps (Canvas Apps, SharePoint Form Apps, Model Driven Apps, Portals) • Expertise in implementing Power Automate Flows (Automated, Instant, Business Process Flow and UI Flows) • Expertise in DataVerse and Azure Databricks and MuleSoft 2. Experience implementing Collaboration Portals,...

I need a customized formula in an Excel spreadsheet to calculate different rates based on the day of the week. Here are my specific requirements: - The formula should apply different rates for weekdays, Saturdays, Sundays, and Public Holidays. These rates are as follows: - Weekdays: $30.10 - Saturdays: $36.12 - Sundays: $42.14 - Public Holidays: $60.20 - This calculation must be flexible and able to automatically adjust to the specific day in the date field. We will also add another box that adds11% to the total figures. Ideal Skills and Experience: - Proficiency in Microsoft Excel and its formula creation. - Experience in creating custom Excel formulas to calculate based on specific conditions. - A...

...work part-time and have great communication skills. Key Tasks: - Help with administrative tasks: This includes managing my calendar, setting up meetings, and handling basic bookkeeping. - Conducting Research: I need someone who can gather information for me on topics that I provide. - Assisting with Customer Support: You will need to handle customer inquiries and provide basic support. Communication is key for this role, so I need someone who is comfortable with various communication channels. I expect you to be responsive to emails, phone calls, and instant messages. Ideal Skills and Experience: - Proven experience as a virtual assistant or in a relevant role - Excellent organizational and time management skills - Strong communication skills...

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 SQL will be con...

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.

...looking for a creative artist to paint a medium-sized nursery wall mural with a beautiful floral design. It should consist largely of giant flowers, stems and leaves, not necessarily overlapping each other. The color scheme should encompass various hues of sage greens and dusty rose colors, bringing a natural, soft, yet vibrant feel to the space. The ideal candidate should: - Have prior experience in painting wall murals, and have a portfolio to demonstrate their previous artistic projects. - Have a keen understanding of mixing colors to achieve the desired feel. - Operate with professionalism and timeliness, ensuring the project is completed in a timely manner without compromising on quality. Your attention to detail and pas...

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 updates prope...

I'm seeking a professional who can help me increase the watch time on my YouTube channel. While I primarily post entertainment videos, I'm looking for strategies to boost this metric to meet the 3800 watch hour threshold. Key Requirements: - Proven experience in growing watch time on YouTube channels - Strong understanding of YouTube's algorithm - Familiarity with content creation and optimization for entertainment content I'm open to discussing different strategies for achieving this goal. If you're creative and resourceful with a track record of success in this area, I'd love to hear from you. Feel free to share your ideas and past accomplishments in your bid.

I'm in search of a highly educated female home caretaker (who can speak English or Hindi) to manage house activities and take care of family members. It is essential that the candidate holds a high school diploma. The ideal candidate for this role will be expected to: Organize the household schedules effectively Prepare meals for the family Assist with family activities This is a full-time position, requiring services for more than 8 hours per day. Please note that this position does not involve cleaning tasks, as we have maids for that. The primary responsibilities will be taking care of the family, managing the house, and running errands such as going to the market and buying groceries. We offer transportation (flight or train to travel ...

1. Issue Rural commodity growers face challenges in accessing markets due to high air and sea freight costs. To support these farmers and producer groups, our organization provides upfront funding for freight expenses. However, the existing process lacks a robust database system with simple bookkeeping features. We need a comprehensive solution that streamlines the entire process, ensures transparency, and automates accounting and reporting tasks. 2. Solution: Commodity Transportation and Funding App Key Features: User Registration and Application: Commodity growers, shipping companies, and airline carriers register through a user-friendly web interface. User details, including CRM data, are captured during registration. Freight Tracking and Reimbursement: Record tran...

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 accuracy. Prior experience in handling Arabic language requirements i...

• 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 be working online remotely. • Experience Please show us ...

...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 similar issues is a plus. - Deadline-oriented and able ...

• 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 be working online remotely. • Experience Please show us ...

...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 user needs, enhancing both the scalability and functionality of our se...

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 in need of a talented Hindi scriptwriter to work on a long-term basis, generating scripts for educational online videos. The ideal candidate should be passionate about creating engaging and informative content. Key Requirements: - Writing online video scripts: I require at least 60 minutes worth of script each day. - Genre: The content will be educational, so a strong grasp of the Hindi language is essential, as is the ability to make complex topics accessible to a wide audience. Ideal Skills and Experience: - Proven experience in scriptwriting, particularly for online videos. - Strong understanding of the nuances of the Hindi language. - Background in creating educational content is a plus, but not mandatory. - Ability to meet daily ...

I'm in need of a skilled individual who is proficient in blockchain and wallet analysis, specifically on the Arbitrum blockchain. The project involves analyzing transaction patterns and wallet balances and activities. Key Requirements: - Proficiency in blockchain analysis, particularly on the Arbitrum blockchain - Ability to identify patterns and trends in transactions - Proficient in analyzing wallet balances and activities Deliverables: - A comprehensive report that includes methodology, analysis, and conclusion - The report should be presented in a combination of written format and visual presentation (charts and graphs) Please note that I will provide you with access to the necessary pages and data on Arbiscan. Your task ...

I am seeking a YouTube analytics expert to help improve the watch time analytics of my channel. Key Responsibilities: - Analyze current watch time patterns and identify areas for improvement - Provide recommendations to boost viewer engagement and retention - Suggest strategies to enhance the overall analytics of my channel Ideal Candidate: - Proven experience in improving watch time analytics on YouTube - Strong understanding of viewer behavior and engagement on the platform - Excellent data analysis skills - Up-to-date knowledge of YouTube algorithms and best practices - Experience in the entertainment content industry would be a plus Please note, I am looking for someone who can not only analyze the data but also provide...

I am seeking an 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.5...

DA upto 40 DR upto 60+ TF upto 40+ CF upto 35 UR upto 70+ PA upto 35+

We're looking for a freelancer to take and upload live photos of 8 Rittenhouse / Center City bars in Philly. This is for a Philly bar iOS app, aimed at providing real-time updates to users regarding the bars' lines and interiors. Key Responsibilities: - Taking live photos of bars from 9pm-1am on Friday and Saturday night. - Uploading the photos to the app promptly. Photo Guidelines: - Photos must be taken on an iPhone and uploaded to our iOS app

I have a SQL Server that needs to be accessible over the internet. However, I'm facing connectivity issues, possibly due to closed or blocked ports on my ComCast router model CBR2-T. I need a freelancer to open the necessary ports on the router. The task involves: - Checking the current port status on the router - Identifying the SQL Server port - Opening the port on the router Please bid if you're experienced with network configuration and have dealt with ComCast routers before. Necessary Skills: - Network Configuration - Router Administration - ComCast Router Experience - SQL Server Configuration

I require someone experienced in Linux server management to help optimize the performance of my server. Linux Server Performance Optimization Plesk Obsidian, SQL, PHP Key Responsibilities: - Review the current server setup and performance - Identify areas for improvement - Implement solutions to optimize server performance - Fix the 2 errors. This is not a one-time setup; I may require ongoing management based on the initial optimization results. Your expertise in Linux server management is crucial to this project.

I'm in need of a professional web developer to create a platform that serves as an agent management website. The website should have an elegant interface, account logins, and a simple credit system that can be administered by an admin account. Key Features: - Agent Registration and Login: The website should allow agents to create accounts and log in securely. - Profile Management: Agents should be able to edit and manage their profiles. - Commission Tracking: The system should track and calculate commissions for each agent. The specific functionality of the agent registration and login feature is not fully defined yet. The ideal candidate for this project should have experience in building similar systems, understand user account man...

I need some extra help around the club. Key tasks involve bartending, cleaning, and event planning, for less than 10 hours a week. While physical labor and cash handling aren't a necessity, basic laptop skills and the ability to run an app are a must. This job is best suited to someone with a background in customer service. Part-timers with flexibility are encouraged to apply as hours can vary.

...looking for a skilled software developer to create a Windows-compatible software application. This software should be specifically tailored to help my sales team improve their performance and to calculate their incentives. Key Requirements: - Compatibility: The software should be compatible with Windows. - Integration: There's no need for the software to be integrated with any existing systems, so you can focus solely on creating the best software for our sales team. - Data Input: The software should have the capability to import data from Excel/CSV files. This method will facilitate the input of sales data and make the software more user-friendly for our team. Ideal Skills and Experience: - Proficient in Windows software developme...

I'm in need of a skilled Web Application Developer to create a sales incentives system that will handle complex calculations and generate comprehensive reports. Essential Features: - Commission Percentage Calculation: The system should be able to calculate the commission based on the sales made. - Bonus Calculation: The application needs to compute bonuses based on the sales targets achieved. - Tiered Incentives: The system should offer tiered incentives based on the sales performance. Additional Requirements: - User-Friendly Interface: The application should have a simple, intuitive interface for easy usage. - Reporting: The system should generate detailed reports on the sales incentives calculations. - Security: It's crucial that the applic...

In my project, I'm looking to set up ActiveMQ JMS messaging for our system, focusing on synchronous and asynchronous messaging. We anticipate a low scale of message traffic, not exceeding 1,000 messages per day. Key responsibilities will include: - Setting up ActiveMQ for JMS messaging - Configuring it to handle synchronous and asynchronous messaging effectively Furthermore, I plan to utilize SOAPUI Open Source for automated testing of these messages. Your role will be essential in ensuring that the system works seamlessly with this tool. I will be expecting below: Create a framework to publish and subscribe messages to ActiveMQ queues Create queries to make sure data is published into the respective tables and assertions ...

Looking for help in modifying an existing python script and related sql database table The current script - (1) scrapes company financial data from website and populates database (2) scrapes news related to keywords from google news (3)sentiment classification of news items (4)pushes data to sql database The company names and keywords are currently hardcoded in the script Requirement- (1) Company names/urls/keywords (will be provided) to be put in master table in the database (2) The script to loop through and scrape the relevant data and put in database

...freelancer who's great at web scraping to help with a project involving a specific website initially, with potential for more. I'll give you the specific data fields to extract. It'd be great if you: Are really good at web scraping and or Python. Know your way around MS SQL Server databases, not essential but definately an advantage. Understand how to extract data effectively. Understand the need for security and captcha integration if needed. Can work quickly since this project is a priority and needs to be done ASAP. Ultimately, I want to be able to manage the code with your ongoing help, so this could lead to a long-term partnership. I'll share the full details when needed. You will provide source cod...

I am looking for a writer/journalist who can produce news articles based on trending topics we provide. The ideal candidate will have experience in producing multiple stories per day on incoming news. Skills and Experience: - Strong writing skills - Knowledge of current events and ability to research and gather information - Ability to write in a neutral and unbiased manner - Experience in writing news articles - Ability to meet deadlines and produce high-quality work consistently

...a part-time professional with a proven track record in sales, strong negotiation skills, and experience in lead generation to enhance my team's capabilities on profit sharing basis. Key Requirements: - Proven Track Record: Your past performance in the sales field should speak for itself. A strong history of meeting or surpassing targets is essential. - Strong Negotiation Skills: The ability to close deals effectively and maintain healthy relationships with clients is a must. - Experience in Lead Generation: Generating potential leads and converting them into customers is a fundamental part of this role. Your ability to identify new opportunities will be key in the growth of our customer base. My objectives for hiring...

Required a dot net developer. Speacialized in Microservices acrhitecture based solution. Dotnet Core, C#, SQL, Data transformation, API gateway, Auth based security.

...developer to assist me with my project. I'm looking for a PHP expert who can aid in the development of a web application, website, or mobile app. You should be proficient in both front-end and back-end development, capable of crafting user-friendly interfaces and integrating complex functionalities. Your role will involve: - Understanding project requirements and delivering high-quality work - Developing secure, efficient, and scalable code - Implementing user authentication, integrating databases, and possibly setting up payment processing systems - Ensuring timely and reliable completion of the project If you are a skilled PHP developer with experience in full stack development and are passionate about producing high-quality applications, this pro...

I need a web-based application to calculate the dues per apartment based on the expenses categorized by type. The main points are: - Expense Categorization: The app should categorize the expenses by type. For instance, maintenance, utilities, repairs, etc. - Dues Calculation: - Square Footage Basis: The apartment dues should be calculated based on the square footage of each apartment. - Platform: The application should be web-based, accessible from any browser. Ideal Freelancer: - Experience with web application development, especially in accounting or financial tracking software. - Understanding of expense categorization and calculation based on different parameters. - Familiarity with building user-friendly interfaces.

...minimum of 10+ years of experience, I am looking to enhance an existing Real Time Dashboard within PHPMaker 2023. Key Responsibilities: - Modify existing features and incorporate new functionality - Implement user authentication system to ensure data privacy - Create real-time notification system for immediate updates - Develop advanced interactivity for data manipulation and customization Desired Skills: - Proven expertise in PHP development, ideally with PHPMaker 2023 - Comprehensive experience in building Data visualization (Charts, Heat maps, Custom Dashboards) - Strong understanding of user authentication mechanisms - Ability to develop real-time features for immediate data updates - Experience in creating advanced in...

I need assistance in copying text content from my smartphone and pasting it into the appropriate place. Key Requirements: - Copying text from my smartphone- The texts are not in a document but on my phone. A good understanding of how to copy and paste from a phone is essential. - Paste into the appropriate location- The text will need to be pasted into the correct place, whether it be a website, document, or elsewhere. Time Expectation: - I am looking for someone who can assist me part-time. This means the job doesn't need to be completed all at once. A longer-term arrangement is possible if the collaboration is successful. Ideal Skills: - Understanding of basic phone functions - Strong attention to detail - Ability ...

I'm currently looking for a Vue.js developer with a solid understanding of Laravel. While I'm not certain the version of Vue.js I'm using, I know that I need to implement a real-time chat feature in my project. Ideal Skills and Experience: - Proficiency in Vue.js is a must. Experience with both Vue 2 and Vue 3 would be beneficial given my uncertainty about the version currently in use. - Strong understanding of Laravel is also required since the project involves integrating the chat feature into an existing Laravel application.

...employee time tracking system on Google Sheets. The system should automatically calculate total hours worked, allow for marking employees as present or absent, and have fields for project number and name. Key Features: - Automatic Calculation: The system should calculate the total hours worked by every employee within the specified date range. - Attendance Tracking: There should be an option to mark employees as present or absent. - Project Details: Each row should contain fields for the project number and name. - Multi-employee Handling: The system should accommodate multiple employees' data in a combined sheet. Skills and Experience: - Proficient in Google Sheets - Experienced in creating automated time tracking systems - ...

...installing python, setting SQL for our applications and Google Sheet. For each country may need API for such as : 1. Historical Data 2. Financial Scrapped Source 3. Financial Summary Scrapped Source 4. Interest rate 5. Some More Required Skill & Experience : 1. Php & SQL 2. Familiar with python installing & setting up environments 3. Experienced in Linux Debian & LNMP server by SSH 4. You need to know on how to run python scripts on debian by ssh, and setup cron task on debian, and debugging etc Personality's Criteria : 1. No toxic working environment 2. Agile, Responsive, and Fast Delivery 3. Collaborative as a team 4. Responsible, Credible, Reliable and Integrity person 5. No agency, only direct hiring ------ I'm...

Looking for a web developer to assist with various technical woocommerce things with woocommerce, i rather a company than an individual this way there is more skills to different tasks and i dont want issues like disappearing freelancers. Please make sure you are serious, keep having people start the job, do a few things and then all of a sudden just stop working for no reason. Must have good communication and have experience with complex fixes, when a task is assigned it needs to be resolved and whatever else is found quickly. Bugs mean the site is down or not working and dont have time for excuses or inexperience. This is a long term position as once you get use to the sites (about 12) the issues tend to be the same. DO NOT apply just to...

...work part-time and have great communication skills. Key Tasks: - Help with administrative tasks: This includes managing my calendar, setting up meetings, and handling basic bookkeeping. - Conducting Research: I need someone who can gather information for me on topics that I provide. - Assisting with Customer Support: You will need to handle customer inquiries and provide basic support. Communication is key for this role, so I need someone who is comfortable with various communication channels. I expect you to be responsive to emails, phone calls, and instant messages. Ideal Skills and Experience: - Proven experience as a virtual assistant or in a relevant role - Excellent organizational and time management skills - Strong communication skills...

I'm in need of a skilled web developer to create a one-page website for my upcoming political campaign. The main goal of this landing page is to raise awareness about the candidate and recruit volunteers. TEMPLATE - purchased COPY - completed PICTURES - available THUMBNAILS - being completed GOAL - for the one-page site to look & function exactly like the template TIMELINE - it time line is missed, contract is cancelled HOURS - we meet multiple times a day for 5-minute sprint meetings during US hours; if you're not available during US business hours, please do not apply Key features to be included on the page: - Detailed information about my background as a candidate - Clear campaign goals and objectives for potential suppor...

I'm looking for an experienced developer to help with real-time text data scraping via API and management using BeautifulSoup. This project is primarily focused on retrieving text data and storing it in a database. Key Responsibilities: - Implement an API scraper to continuously retrieve text data in real-time - Utilize BeautifulSoup for data extraction and management - Develop a robust database to store all the scraped text data The ideal candidate should have: - Proficiency in Python programming language - Strong experience with API scraping and BeautifulSoup - Previous work involving real-time data scraping - A good understanding of database management It is important that the data scraping runs seamlessly and accu...