How to calculate overlapping time in sql jobs

...developer to establish an e-commerce platform using Magento 2. The primary objective is to sell physical products across various categories. This will not be like Alibaba. To clarify, our proposed website business model does not involve creating an online platform where business buyers and suppliers globally connect and transact with each other. Instead, it focuses on facilitating transactions solely between our business (the retailer/buyer) and suppliers. The purpose of vendor registration on our platform is for suppliers to sell exclusively to us, allowing us to collect their documentation and register them as clients from whom we will purchase goods. Key Requirements: - Installation and setup of Magento 2 - Configuration for selling physi...

Looking to have created to small apps in visual studio to access and write to SQL Server database. Please see the full description in the PDFs I have uploaded.

I need a landing page built by 3/28. The back end is built, I just need a front page that connects to a QR code that highlights everything housed in the back end.

I'm seeking a proficient Visual C# developer with expertise in SQL Server integration for a critical project. Your task will be to enhance my application by incorporating Intermediate level database operations, specifically working with Stored Procedures and Triggers. Key Skills: - Extensive experience in Visual C# development - Proven expertise in SQL Server integration - Proficiency in implementing Stored Procedures and Triggers. Your ability to work efficiently while maintaining quality will be of utmost importance to the successful completion of this project.

I'm seeking a part-time specialist in Business & Finance. This position is particularly suited to a candidate possessing: - Strong technical expertise: You should be well-versed in finance-related software and technology, and capable of demonstrating a sound understanding of all related technical aspects. Your previous experience will be a valuable asset in this role, allowing you to not only resolve issues swiftly but also foresee potential challenges and proactively propose solutions. This is not a standard job; it’s an opportunity to apply your skills in a dynamic part-time role. Are you ready for the challenge?

I am in urgent need of a software developer with a deep understanding of cosmetic formulation. The application will mainly focus on skincare products. Key Features: - Ingredient Database: The database should contain commonly used skincare ingredients, with a special bias to botanical extracts, essential oils, and peptides and proteins. Freelancer with an understanding of these ingredients will be preferred. - Formula Calculation: The software should be able to calculate skincare formula. Experience in algorithm development will be a plus. Please ensure you have a portfolio of related work in either cosmetics, skincare products or related software development. All qualified candidates are encouraged to bid.

1. Load the a whole list of patients from CSV file into the standing orders screen. It will search a SQL database to find the Internal ID 2. After we insert the orders, we then insert one record for each patient into the Appointment Book table for the Date of Procedures. Process identical to inserting into the currentrx - only one record so easier.

I am seeking a proficient data analyst to conduct a thorough descriptive analysis on mixed data (numbers and text). Your role will be to: - Analyze the mixed data using Microsoft Excel - Efficiently interpret the data, understanding patterns and trends - Produce comprehensive reports detailing your findings Ideal candidates will have: - Needs to have experience in SQL, PowerBI, DAX (must)and Python (optional) - Demonstrable experience in data analysis, particularly descriptive analysis - Adept at working with mixed data of both numerical and textual nature - Proficiency in Microsoft Excel, including advanced functions Your ability to interpret and translate data into understandable, actionable insights will be crucial for this proj...

- Read the JSON files from a table in the database. - Extract specific keys or property values. The challenge here is that the JSON schema will vary from file to file. To be successful in this job, you should have: - Proven experience in writing SQL for complex operations such as this. - Strong understanding about JSON file structure and how to efficiently read and manipulate them. - Ability to create MS SQL statement to read keys and values from JSON file Attached is a sample of the two lines that need to be read in the result as columns (code and display)

I'm seeking an experienced developer to integrate a real-time data feed for the forex market into my application. The exact data provider has not been chosen yet so your guidance and expertise in this crucial decision-making process will also be required. Ideal Skills: - Profound knowledge of API integration - Previous experience with Forex Market Data feeds - Strong understanding of data providers such as OANDA, Xignite, Alpha Vantage etc. Your responsibilities will include: - Assisting in data provider selection - Integrating the chosen real-time forex market data API into my existing system - Testing and verifying the successful integration Given that time is of essence, I need this task completed ASAP. Professionals who can work unde...

I am seeking a proficient Charter...proficient Chartered Accountant who can efficiently handle both TDS working and TDS filing for my business. Key Responsibilities: • TDS Working: Calculate and validate the Tax Deducted at Source (TDS) for our financial activities. • TDS Filing: File the TDS returns in a timely and accurate manner, adhering to the applicable laws and industry standards. Ideal Candidate: • Chartered Accountant certification is mandatory. • Must possess prior experience in TDS working and filing, particularly within our industry. • Excellent mathematical and analytical skills. • Strong understanding of finance laws, rules, and regulations. • Exceptional attention to detail. Only apply if you meet t...

...looking for a talented and passionate Video Editor to join our team, focusing on creating engaging educational content around eBay dropshipping. This is a full-time position where you will play a crucial role in enhancing our video content to educate and inspire aspiring entrepreneurs. Responsibilities: Watch and thoroughly understand the provided long or short format video content, primarily focused on eBay dropshipping topics such as listing strategies, getting started, SEO, and common pitfalls. Edit videos to a high standard, adding animations, graphics, and other elements to clarify and enhance the message. Create compelling thumbnails for each video to increase visibility and click-through rates. Work collaboratively with the conte...

I need someone skilled in Microsoft Excel, particularly with creating automated systems using formulas and macros, to design an editable daily production log for my team. This individual should have experience working with an array of Microsoft Excel functions and formulas and compiling that data to create extensive, detailed reports. Key requirements include: - Designing an Excel sheet that is editable by all team members - Using formulas and macros, creating a system that generates a daily master team summary report - The master report should calculate and include total team output, individual team member's output, counts of specific tasks, hours worked, and necessary statistics such as charts completed and pages completed - An automated system that upda...

...System Overview: In today's fast-paced business environment, effective utilization of meeting spaces is crucial for productivity and collaboration. To streamline the process of booking meeting rooms and avoid conflicts, there is a need for a robust meeting room booking system. Problem Description: Your task is to design and implement a meeting room booking system that allows users to efficiently reserve meeting rooms without conflicts. The system should support the following functionalities: • Room Management: The system should allow administrators to define the number of meeting rooms available and their respective capacities. Each room should have a unique identifier. • Booking Management: Users should be able to view the avai...

I'm looking for a dedicated Social Media Manager with experience in handling Facebook, Instagram and Twitter. Your daily tasks will include: - Content creation ensuring engagement. - Organizing social media scheduling to optimize reach. - Proactively initiate community engagement to keep followers involved. The ideal candidate should have experience in targeting a professional audience demographic. Demonstrated experience in effectively managing and growing professional social media accounts is critical.

As the client, I am looking to develop a Baloot game app for both iOS and Android platforms. I am seeking an experienced Unity developer who can create a high-quality 3D gaming experience. Key features of the project: -Multiplayer functionality - enabling users to play in real time with other players around the globe. Ideal skills and experience - Proven experience in Unity game development - Expertise in iOS and Android game development - Experience in developing multiplayer games - Ability to create high-quality 3D graphics - work together in Databases designed and code. -explain each line and give full turn over about the project. - is good to use Microsoft SQL for Database I need like this game. It is o...

...job portal with mobile application development, aiming to seamlessly connect job seekers and employers through an easy-to-navigate, corporate-styled interface. This platform should serve as a one-stop hub for posting vacancies, applying for jobs, and managing applications. Here's what I'm looking for: **Core Objectives:** - Create robust connections between employers and job seekers. - Integrate mobile application support for iOS and Android devices while maintaining desktop access. - Enable fast application, approval, attendance tracking, and payment system. **Key Features:** - User profiles for both job seekers and employers. - Secure job listing and application submission processes. Modules: 1. Recruitment: Allow job seeker/employee to input personal ...

As a project owner, I'm in need of a proficient full-stack developer endowed with good knowledge of Dotnet. The following skills set and experience are essential for my project: • Skillful in C#, JavaScript, and SQL programming languages. • Have extensive experience in mobile and web application development. • Specific experience with cross-platform mobile app development. The task at hand is to develop a cross-platform mobile app that will cater to our specific needs. Thus, familiarity with Android and iOS platforms is a plus. Applicants with prior work portfolio in the same line of project will be considered first. This project has a strict timeline, so ability to adhere to deadlines is a must. Hoping ...

We are a multinational startup software development company,...primarily software developers, are Non-US talents. Currently, we are seeking account managers based in the US responsible for creating and managing necessary accounts for the company. Once an account secures a job, the teams, including the development team and technical interviewers, along with the account manager, will collectively handle the project. This approach enables the team to secure and manage jobs even if the account manager lacks technical knowledge. - Requirements: US-based - Flexibility: 30 mins/day. Account managers will receive compensation of $200/month for the first 3 months, increasing to $400/month thereafter. This is a part-time position, and their daily workload is expec...

Looking for a seasoned AWS expert to assist in optimizing EC2 instances, S3 storage, and Lambda functions for improved performance. The ideal candidate will have: Mainly working on Aws glue jobs , S3,lambda, Crawler, step functions, dynamo DB ,Clouldwatchs, Appflow, parameter store , API Gateways, ETL Jobs,splunk logs CloudFormation - important big bucket,Spunk, Jenkins pipelines* CI/CD * , YAML for creating templates and manifest files * Sql mandatory for date base * ⁠using Postman for API calls * ⁠Python and spark Musk know

...have a better chance. Monthly salary will be considered to calculate the hourly rate and the time needed to complete different task documents, on an agreed fixed price. The best offers with the right experience will have the opportunity to work with us on a long-term basis. Also, Good prospects for the right developers, based on the performances evaluated over a period of time, once you established your skills. Need to provide the changed code details and sql queries if any at the end of each sub-task, with the changed code line numbers. Unlimited Revisions are needed. Any bugs created due to your own developments are to be fixed on free of Charge. Recruitment is for a long-term big project as such, all the deve...

...system for tracking employee hours. I'm seeking an expert to develop a seamless digital timesheet management system with a primary focus on real-time employee check-in/check-out tracking feature. This transition will contribute to the efficiency and productivity in time management and resource allocation within our business. Ideal Candidate: - Proven experience in designing digital timesheet systems - Exceptional knowledge of real-time tracking systems - Strong understanding of user-interface and user-experience design - Ability to work within deadlines - Excellent communication and collaboration skills This project will challenge your capability to create a user-friendly, real-time tracking system. Ye...

I'm in immediate need of a skilled Python and JavaScript developer. Key Skills Required: * Proficiency with Python and Django/Flask frameworks * Knowledge of SQL database integration * JavaScript expertise Responsibilities will involve backend development tasks, exact specifications to be determined during the project initiation phase. Rest assured, your strength in Python and Django/Flask will be the focal point of your responsibilities. Effective database management and server configuration knowledge are a plus, but not mandatory. The developer should ideally have prior experience working with back-end development and JavaScript, and be able to start immediately. With an urgent schedule to adhere to, I need a timely-mannered, ded...

A basic WP theme Children upload MP3 audio They get points for each upload Display child name with points will need a basic PHP or SQL database with children names and points tally

I'm seeking a highly skilled developer to integrate a Google Map feature into my web platform. This map integration should anticipate direction and interpret deliveries along a given route. Key features should include: - Real-Time tracking: Aiding in monitoring movement and progress in the delivery process. - Route optimization: To find the shortest and most efficient routes. Data to be used will include GPS data, delivery addresses and traffic information. Relevant experience with using such data for predictive tasks will be appreciated. Proficiency in handling Google Map APIs, Geo-location services and web development skills are essential. Looking forward to a user-friendly, seamless integration that boosts operational effici...

I'm looking for a skilled Java developer to build a program focused on data synchronization. Here's what you need to know: - Functionality: The program will need to synchronize real-time streaming data. - Database Management: It should work in tandem with my current MySQL database system. Ideal Skills and Experience: - Experience with Java and database management. - Expert in data synchronization methodologies. - Proficiency in working with MySQL. You should be able to demonstrate relevant past work examples. If this sounds like a fit, I'd love to hear from you.

...digital dynamo seeking more than just a paycheck? If so, we want YOU to join our badass team of innovators. We're a lean, mean, tech startup making waves, and we desperately need a coding savant who can seamlessly blend development and design. Someone who dreams in HTML/CSS and breathes JavaScript like air. A front-end phenom one day, back-end boss the next. But we're not just looking for skills – we want raw passion and insane ambition. We're a tribe of hustlers disrupting the game. Unique thinkers and code poets crafting digital masterpieces. Visionaries who flavor their functions with style and elegance. Still with us? Here's the deets: • Full stack required (WordPress, Angular, React, Node etc.) • Graphic/motion design skills to...

In search of a professional C# desktop developer with at least 12 years experience in SQL Adhoc Query, Stored Procedures, Functions, and LinQ. The developer would need to leverage their strong database management skills to provide robust solutions for our application. Key requirements: - The application needs capabilities to read and retrieve data, update and modify data, and perform complex queries to generate reports from the database. - Design and implement complex algorithms for improved data interaction. - Strong attention to detail as some specific functionalities of the application were not specified. - Ability to design a clean and minimalist interface with modern aesthetics aligned with our brand. Ideal Skills and E...

I'm looking for a specialist to help with updating the Azure Logic Apps SQL Server Connector, Logic apps are using Azure sql managed api's. I nee some one screen share on zoom and explain me few things for 1 hour. If it goes well, I have more work on regular bases. - Experience with Azure Logic Apps - Azure services -CI / CD Pipelines

I need a proficient C# developer experienced in back-end operations who can seamlessly integrate existing systems. - Key Responsibilities: - Conduct back-end development tasks and system integrations - Skills and Experience: - Proficient in C# programming - Must have experience with Microsoft SQL Server and Microsoft Azure Ideal candidates should have prior experience in managing backend systems and have a deep understand of system integration using Microsoft SQL Server and Azure. Your role will be of paramount importance as the efficiency, performance, and scalability of our systems heavily relies on the successful integration of these backend tools. So, if you are tech-savvy and a problem solver at heart, I’d like to meet you.

I'm looking for an experienced professional to develop an integration with the WhatsApp Business Cloud API for my project. The details are as follows: - The system must allow sending and receiving of WhatsApp messages directly from a computer, not through mobile. - The integration requires Message Template and Media Sharing capabilities. - The system must support selecting mobile phone numbers directly from an SQL Server Database. - A customer table page view will be provided as the base of this project. - The tool should be developed using C#, as stipulated in the provided API documentation. Key competencies for success include: - Experience with C# - Experience with SQL Server Database - Understanding of API integrations - Pr...

I'm experiencing recurrent 404 errors on specific pages of my WordPress website. The issue is beyond simple content nonexistence or misdirections. This leads me to believe it's database-related. This project seeks an adept WordPress developer with significant experience in: - WordPress Database Management - Troubleshooting and resolving 404 errors Tasks will include: - Comprehensive analysis of the database to locate faults causing these 404 errors on the specified pages. - Implementing effective, long-term solutions to resolve the error messages. A solid understanding of SQL and efficient problem-solving skills are also highly desired for this task.

I am in need of a proficient Laravel developer to assist with the istall our source code on the server Digotalocean The successful freelancer should have: - Proven experience in Laravel. - Strong knowledge in database management systems. - Understand Laravel-based SQL databases. We would primarily focus on the following features: - Database management. This role demands precision and a detail-oriented mindset. I encourage developers with a good understanding of the above languages and functionality to apply.

In need of a dedicated full-time community manager to boost engagement and discussions within Forex trading communities. Responsibilities: - Regularly post in online trading forums similar to Discord to stimulate conversation and encourage active participation. - Drive member engagement metrics including the number of messages sent and return visits to the communities. Desired Skills: - Proficient knowledge of Forex Trading at an intermediate level - Excellent communication skills to engage and inspire other members - Experience in community engagement strategies within investment and trading spaces Objectives: The primary goal of this role is to grow the community through active engagement. The qualified professi...

We are looking for a full-time WooCommerce and WordPress developer to maintain and scale our online store and website. Responsibilities: - Implementing WooCommerce setup and customization in line with my specifications. - Customizing WordPress themes to meet the unique needs of my website. Design Contributions: With a clear design already in mind, I'll need you to breathe life into it, transforming my vision into a responsive, user-friendly website. Resources: I'll supply all the required resources - images, text content, logos etc., freeing you up to focus purely on development and customization tasks. Ideal Skillset: Someone with a proven track record in WooCommerce setup, WordPress theme customization, a keen eye for...

Need an expert with prior knowledge of integration and expert in C++. Integrate data into my price data feed. for further details please inbox. Thank you

Introduction and Background Start with an engaging introduction that outlines the purpose of the vlog: to provide comprehensive insights into college admissions. Briefly introduce yourself, highlighting your background in education and college admissions, which adds credibility to your insights. Understanding the Admission Process Explain the general steps involved in the college admissions process, such as researching colleges, preparing application materials, taking standardized tests (SAT/ACT), requesting letters of recommendation, and writing essays. Discuss the importance of deadlines and the significance of each component in the application process. Key Points for a Compelling Application Dive into what makes a compelling college application, emp...

I'm looking for an expert to configure real-time integration between Moodle and Odoo 13 Community. Specifically, I am interested in the following areas of synchronization: - User Synchronization: Maintain real-time consistency across both platforms regarding user information. - Course Enrollment Synchronization: Ensure that as soon as a student enrolls/unenrolls in a course on Moodle, their status is immediately reflected on Odoo. - Grades Synchronization: Guarantee real-time syncing of grades between the two platforms. In any case of data discrepancy, the record held by Odoo 13 Community should be considered the master and override the conflicting data on Moodle. Ideal candidates should have experience with Moodle, Odoo 13 Communit...

More details: What is the main subject or topic that will be covered in your online learning platform? Comprehensive sexuality education What information should successful freelancers include in their application? This question was skipped How soon do you need your project completed? ASAP

An automated trading application for Interactive broker which should be able to take specific inputs and predetermined percentage values from a single user, save the information and pre-calculate thresholds. Stream Realtime stock tickers data for 15 stocks, monitor at user specified time interval and execute necessary orders (like initiate a trade, apply Stop/limit, change Stop/Limit and close trade etc.) based on user specified predefined thresholds and values The application could be python based or any other programming language supported or even it can be built on top of IBKR provided Excel DDE. after delivery, Desktop Setup and a successful execution demo is expected

...comprehensive skills in product analysis primarily focussing on different categories. This role involves identifying profitable items from China to sell on unique CIS marketplaces. CIS marketplaces provide a great opportunity to enter the market right now because there is low competition and a small assortment of goods. We don't work with such categories as Clothes, Food and some others. You will have to work with websites with russian text to analyse them. Key Responsibilities: - Identify high-quality, competitively priced, and trending items from 1688, Taobao and etc. - Regular usage of WeChat for communication. - Calculating the unit of economics and maintaining a table for each product Mandatory Skills: - Previous experience using 1688, Ta...

I need a proficient data scraper for a one-off project. The task involves extracting the inventory ( text content, images, and metad...( text content, images, and metadata )from a specific website. Key requirements: - Expertise in web scraping - Ability to accurately extract and organize data - Experience in handling different types of data including text, images and metadata Ideal professionals for this job would have significant experience with web scraping and a keen eye for detail to ensure nothing is missed. Familiarity with handling a range of different data types is highly desirable. Please note, this is a one-time task. However, depending on the success of this job, there could be potential for further similar projects in the future...

I require a highly skilled SQL expert to develop a SQL query for data analysis purposes. This query will focus on customer behavior data. Although no specific focus area has been outlined for this project, freelancers should have a deep understanding of customer behavior data to effectively design this query. Ideal Skills and Experience: - Proficiency in SQL - Experience with data analysis in customer behavior - Ability to interpret complex databases. Please note: You will not be necessary to implement the query, your job is limited to writing the SQL command. Efficiency and execution speed of the query will be key considerations during selection.

I need an expert in SSRS 2019 and TSQL creation and optimization to assist in my project. Key Tasks: - Designing and developing robust SSRS reports - Writing complex, efficient TSQL queries - Ensuring optimal performance of both SSRS and TSQL You should have extensive hands-on experience with SQL Server Management Studio, Visual Studio Your background in handling complex data scenarios using these tools will be pivotal. Your role is critical in ensuring the project's success, so your proven expertise is a must.

...incldude a link to your CV .Net developers with strong C#, MVC, SQL Server experience is essential. We are looking for the right people. This is a long term, full time role. Good salary. YOU NEED TO HAVE: - Good understanding of current development models .Net MVC and entity frameworks. - SQL Server is preferred database platform, - Scrum and Agile experience, - Microsoft .NET Technologies: ASP.NET, MVC, - Very positive optimistic attitude, - Good troubleshooting skills and logical thinking NOTE: - We are looking for long term full time people. We want to hire people who will work with us for the next few years. If this is not what you are interested in please do not apply. - This role will require you to work full ...

I'm in need of some technical assistance with a MySql error that has occurred within my React/NodeJS application. The error is: Error: Can't add new command when connection is in closed state at (/var/www/html/backend/node_modules/mysql2/:22) at /var/www/html/backend/:39 at [as handle_request] (/var/www/html/backend/node_modules/express/lib/router/:5) at next (/var/www/html/backend/node_modules/express/lib/router/:13) at complete (/var/www/html/backend/node_modules/passport/lib/middleware/:13) at /var/www/html/backend/node_modules/passport/lib/middleware/:15 at pass (/var/www/html/backend/node_modules/passport/lib/:14)

...with an exceptional eye for design, particularly in creating bold and vibrant styles. The project's primary goal is to significantly improve the user experience of our current Shopify store, which currently suffers due to poor UX. Please refer to as an example. Key Responsibilities: - Completely redesign the store to give it a more bold and vibrant appearance - Make significant improvements to the overall user experience, with the main focus on the following: - Navigation: The site should be easily navigable, with a simplified and intuitive structure - Product search: Enhance product search function for efficiency and accuracy - Checkout process: Ensure a smooth, seamless checkout process to reduce cart aband...

We are seeking an expert image editor to help us and our agency with Artificial Intelligence images (AI). AI images come with many defects and distortions such as extra hand, extra fingers, fingers overlapping, blemishes on the face or environment. So we are paying $15 per image that is fixed and if the freelancer does a great job, we will pay a bonus also.

...skilled WPF developer to craft a desktop application aiming to enhance time logging for our team. The application serves to enable: - User time tracking: Both manual entry and timer tracking methods should be incorporated - Project, phases, and category management: The time logged by a user should be traceable by projects as well as their phases and categories - Request management: Users should have the provision to request their manager to update their previous time log The design of the application must be modern and sleek, aligning with current design trends for user-friendliness. An ideal candidate for this project would be fluent in WPF development, have a keen eye for application design aesthetics, and a firm ...

...direct sql queries to the databases to help on various projects Im working on. 4 years of experience with PHP and databases are minimum for this position. Due to lack of time, I cannot work on all of them, but each one have potential, customers so I need someone who can multitask and work on several projects jiggling between them, sometimes on daily basis. Most of the projects uses Yii1 with MySql database, but I have also various scripts in NodeJS, Python, connections to firebase, mssql, mongo... During the work we would use Trello for tracking the projects tasks and daily and weekly calls to align on the work. This is a long term position where I seek for someone whom I can trust to get the work done. - Please do not ...