Sql query to calculate working hoursJobb

Hej Amr S., jag la märke till din profil och skulle vilja erbjuda dig mitt projekt. Vi kan diskutera detaljerna över chatten.

Till en nygrundade företag inom social entrepreneurship behövs det skaffas en SQL databas samt back-end mask till data query och entry, och en mindre front-end sökmask. Detailerad lista på databas-råder och egenskaper såväl som mockups på aller masker finns. Webspace med möjlighet till SQL databas finns. Detta är prototyp-stadien till en större projekt och rätt programmerare kan blir anlitad även till vidare arbeten med databasen, back- och front-end maskarna, samt senare utveckling av sökmask i app-form och enkelt web-shop kopplad till databasen.

Jag behöver en databas (SQL script) som håller reda på Medlemmar och dess Vänner, samt Kontakt/Meddelanden som skickas mellan dem: - Medlemmar (Namn, Mail, Lösen, Mobilnr., inloggningssätt (Facebook, Google, ösen)) - Medlemmars olika relationer till Vänner (mobilnr., mail, namn, adress) - Tabell över kontakter/meddelanden som tagits med Vänner (GUID skapas för varje gång). - Möjligheter för Vänner att logga in med hjälp av GUID för att se meddelanden - Meddelande skall kopplas mellan Medlem och Vänner. - Medlemmarna skall kunna ha en elektronisk plånbok

Project 1av 2(sql fler fields) skickar den andra projektet under dagen Har ändrat pattern1&pattern2 columnerna i databasen till kundnr&country, id till uid, verkar fungera. Sedan har jag ändrat field1&2 till flera columner i results.html. Så här ser columerna ut i databasen. id, kundnr, country, searchstring, tiff, checked, vat_number, company_name, company_adress, invoice_date, invoice_nr, valuta, summa_netto, summa_moms, varukod, varu_underkod, sprak_kod, beskrivning, fakturatyp, skattenummer

Mac PHP Har byggt en första version av en sajt som låter användare logga in och ange/ladda upp data. PHP/Mysql är använt idag. Skulle i dagsläget behöva primärt ett bollplank kring databasstruktur och koden principiellt men även hjälp med faktisk programmering för vidareutveckling av tjänsten. säkerhetsaspekter är också viktiga i nuläget

Söker back end utvecklare med erfarenhet från skräddaranpassade CMS hemsidor. Du bör vara kunnig inom PHP, Web 2.0, XHTML, SQL, Cross-browser optimering. Utvecklingen av hemsidan bör göras med stor anpassning. Då majoriteten av publiceringen görs av redaktörer måste backend vara anpassad för exempelvis skapande av artiklar. Du kan utgå från ett open-source alternativ och vidareutveckla den enligt våra specifikationer. Integrering mellan hemsidan och databas måste göras av dig. Analytics program erfordras. Interaktion görs möjligt med commenting, threads och forum. Erfarenhet från schemaläggning av aktiviteter bör du kunna göra. Caching även. Säke...

Programmering av ett Iphone och Android telefonapplikation kopplat mot telefonväxel MS SQL och winows server. Funktion och design ingår. Erfarenhet av applikation som contact center, callcenter. Samtalsstryning och design. Lång erfarenhet och stor förståelse krävs.

Programmering av ett Iphone och Android telefonapplikation kopplat mot telefonväxel MS SQL och winows server. Funktion och design ingår. Erfarenhet av applikation som contact center, callcenter. Samtalsstryning och design. Lång erfarenhet och stor förståelse krävs.

I'm seeking a highly skilled Power BI professional to assist with creating interactive dashboards and generating data visualizations. The selected expert will be expected to work with data from both Excel spreadsheets and SQL databases, so experience with these sources is crucial. I will be looking for an advanced level of expertise, as the job will involve complex data modeling and designing sophisticated, interactive visual reports. A strong understanding of data analysis and visualization techniques is essential. Key responsibilities and qualifications include: - Creating interactive dashboards - Generating data visualizations - Working with data from Excel spreadsheets and SQL databases - Demonstrable advanced level of Power BI experience - Ad...

I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design principles. - Medium...

...this is all to be done on a new Linux STAGING ONLY server. 1) Linux staging server setup -> deploy our existing project to a new VPS using gitlab 2) Woocommerce -> continue long term development work on our existing custom plugin. Transfer the existing production woocommerce to this staging server. 3) ongoing long term development of our CRM app Other components of our stack which are a HUGE ADDED BENEFIT if you can work on them -> .NET ASP, WEB API + MS SQL DETAILS HERE -> PRIORITY IS TO HAVE A DEVELOPER ON OUR TEAM (LONG TERM) THAT CAN FOR NOW ALSO WORK WEEKENDS AS WE HAVE SEVERAL EMERGENCIES TO FINISH URGENTLY. Someone who can efficiently manage Linux VPS and efficiently use GITLAB is critical. Initially we need par...

...PRIORITY IS TO HAVE A DEVELOPER ON OUR TEAM (LONG TERM) THAT CAN FOR NOW ALSO WORK WEEKENDS AS WE HAVE SEVERAL EMERGENCIES TO FINISH URGENTLY. We will start with 5-10 small task in and then go to some smaller .NET tasks all with 1 day sprints for you to become familiar with the software and then our main goal will be to integrate another B2B API for our MVNO. Initially we need part of the hours to be worked in the first weeks from 8:00PM- 2:00am UTC -3 (Brazil Time) later you can work on your time zone. If you are awarded the task we expect you to accept IMMEDIATELY and if the project is not accepted immediatly we will award it to another developer. To qualify you must be full stack and work PROFICIENTLY with gi...

I'm in need of a skilled developer to create a score card module using MAUI. This module should allow for the following: - **Score Entry**: Users should be able to input scores into the system. - **Calculation of Scores**: The module should be able to process the inputs and calculate the final scores. - **Display of Scores**: The final scores should be presented in form of summary reports. This module is designed for administrators, so it should only be accessible by those with administrator privileges. Ideal candidates for this project should be proficient with MAUI and have experience with creating data-driven modules. You should be able to integrate various data input methods, develop calculations and create concise, visually appealing repor...

Hello, We are F12Design, a platform where customers and designers come together and collaborate on graphic design projects. We would like to build an interactive dashboard to make the workflow simple and effective. Here are a few things on our mind: Languages - (Please free to suggest your own) Backend - PHP, jQuery, and SQL Frontend - HTML, CSS, and JavaScript For Real-time Demo/Example - Please sign up for and check their dashboard ########################################################## Social Login/Create account (Separate customer and Designer Login) ########################################################### Customer Dashboard Order Handling -------------- Past Orders Order Requirements (Quiz* and additional comments) Order Updates Order Deliver...

Se requiere un profesional que pueda diseñar un reporte en "SQL Server Report Builder". Este reporte, será modelo factura o pedido. Ya se cuenta con la consulta, y los parámetros de consulta (Fecha, desde - hasta), y también por número de documento (Desde - hasta).

Necesito generar deshboard y gráficos en Power bi desde 4 bases de datos • 1 base de dato en postgresql corporativa en aws • 1 base de datos en sqlserver en un servidor local • Google Analytics • Zendesk Son aproximadamente 50 gráficos personalizados con los que necesitamos hacer algunos dashboard de gestión. Es importante dejar documentado el trabajo y respaldadas las consultas en sql. Indispensable: • Dominio de Power BI • Experiencia previa en la creación de paneles para ejecutivos • Capacidad para integrar datos de bases de datos Indicar los accesos requeridos y los requerimientos tecnológicos para desarrollar el proyecto

...searching for a professional who is proficient in SQL coding specifically for MySQL database design. PowerShell scripting or similar would also be beneficial. This is a basic level project taking existing Local government procedures and converting them into SQL based processes. An example of which would be creating a import procedure for traffic count data that is presented in a text format (example attached) Ideal Skills: - Experienced with MySQL Database Design - Well-versed in SQL coding - Ability to simplify complex instructions - PowerShell for anything not possible in SQL This project will demand creativity and intelligence to design procedures that simplify data entry processes. Please only bid if you can offer solutions accordin...

I am experiencing slow query processing and management issues with large tables in my MySQL database, primarily storing transaction data. I am seeking a DBA specialist to diagnose and resolve these bottlenecks and improve the overall performance of the system. Ideal Skills and Experience: - Proven experience in MySQL database administration and optimization - Knowledge of query execution plans and optimization techniques - Proficiency in managing databases with 10-50 tables - Experience in handling databases primarily housing transaction data Tasks include: - Investigating and diagnosing slow query performance - Optimizing handling of large tables - Implementing necessary changes to enhance overall database performance.

...page needs to be as per the attached example (I will send through as PowerPoint and as poorly converted HTML with images) ... but we want a wordpress theme around it so it looks like a proper website and is responsive compared just loading a single image on a page. i.e. needs to have - Company Logo at the top - Colours/Styles blue as per the example template - Copyright bar at the bottom - head office contact info at the bottom - menu with two items at the top (home and contact form) - basic contact form with capatcha, and the company contact details as well - made using wordpress with NO paid third party plugins please, really aiming for native wordpress here as it's just two pages - needs to be responsive so the text moves so it looks ok on a phone - Need ...

Please use this spreadsheet: I will look over the work from Y, and give feedback before adding more files. You will find the file Y1929 under "files" in this project. Thank you.

The aim of the project is to create a nodeJS program that will retrieve an xls file from an email inbox in order to geocode the addresses present in the file via the Google Maps API and insert the geographic coordinates into an SQL table. You can follow these steps: 1. Retrieve the xls file from the mailbox - cron every hour 2. Normalize the xls file for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL table. Each line in the xls file corresponds to a ...

I need to give the class on Microsoft. Thansk

...support the import and export of products and customer data to enhance efficiency. - Scanning and printing receipts: I need the software to allow for scanning products and printing receipts with thermal printers. - User login for separate staff: It should also have a feature to allow separate logins for different users or staff members. - Inventory management: The software should include inventory management features for tracking stock levels and products. - Customer management: I need a system that can handle customer data and history, to help with marketing and future sales. - Tax calculation: The software should be able to automatically calculate taxes for each transaction. - Customizable: The software should be customizable to suit th...

...suitable crop to grow, proper fertilizers to utilize, and identifying diseases your plants may have succumbed to. My objective is to successfully and fully launch this project on my Windows-operated local machine. However, as I lack prior experience in running machine learning projects, I am in need of someone well-versed in this area. Your tasks will include, but are not restricted to: * Assisting me in setting up the project on my local machine effectively * Guidance in running the project smoothly, addressing any potential issues on its way Optimal Skills and Experience: * Proficient in machine learning project setup on a Windows OS * A broad understanding of different databases suitable for a machine learning project * Patience and willingnes...

...it in an Excel file. The specifics of the project are as follows: I am looking for a person who will conduct scraping sessions for our business on a regular basis. Desired skills are knowledge of screen-scraper software, sql, Someone with Python knowledge will be better. Willing to follow instructions. Not cramped up with other jobs or other side hustles. Need to have solid internet connection. Expected work takes 5-10 hours per week, once fully trained. Must be responsible. Able to accept PayPal. - The source of the data is a website. This means the freelancer needs to have experience in web scraping. - The data should be delivered in an Excel file. Proficiency in handling and formatting data into Excel is a must. Ideal Skills and Experi...

Data Specialist: T...Specialist is responsible for providing information that is in databases, organizing and assembling the information so that teams can make decisions using data. Responsabilities: > Access database. > Create dashboards and analysis according to the demand of the business areas. > Update and automate dashboards that need frequent updating. > Provide suggestions of improvements in business areas. Requirements: > Mandarim is a must > SQL > Office Package > Database usage At Shein, we believe that diversity is the force that drives innovation. We are committed to creating an environment where all voices are heard, valued and respected. All our vacancies are inclusive for people with disabilities, women, black people, ...

Multi-scenarios Custom Sales Commissions Excel Spreadsheets Dashboards. Develop a bespoke Microsoft Excel spreadsheet to accurately calculate sales commissions. The specifics: - The variables: the spreadsheet to take into account the Sales Volume, the Profit, and the Commission Percentage while computing sales commissions. - Calculation specifics: Commission should be determined accurately according to custom formulas (using the previous variables) that considers the Commission Percentage. - Data input: The spreadsheet will be easy to use, allowing to manually input the data for calculation. This tool (Multi-scenarios Custom Sales Commissions Excel Spreadsheets Dashboards) will enhance efficient determination of commissions, hence accuracy and...

...expert in Azure Data Factory (ADF) development, SQL, Power BI, and ADF monitoring. Key Tasks: - Creating data pipelines - Building data transformation workflows - Integrating with SQL databases Power BI Usage: - Visualizing data through interactive dashboards - Creating data reports and analytics - Real-time monitoring and alerts ADF Monitoring: - Tracking data pipeline performance - Monitoring data integration processes - Setting up alerts and notifications for job failures. Ideal Skills and Experience: - Expertise in Azure Data Factory (ADF) development - Proficiency in SQL, Power BI, and data visualization - Strong background in monitoring ADF performance - Experience setting up real-time alerts and notifications - Proven track record in working on da...

...Python library, to calculate tip velocity and the radius of the tip using Ivantsov equations. Specifically, the task involves: - Writing Python code in line with a model system I will provide details on. - Working with data that needs to be collected, since I have none pre-existing. While I expect you to have an innate ability to adapt and figure out where and how to source the required data, I am willing to provide assistance as needed. Ideal skills and experience for this job: - Proficient in using Python, specifically the pycalphad library. - Experience with Ivantsov equations and knowledge on tip velocity/radius calculations. - Proven experience in data gathering, particularly for scientific or mathematical computations. - Qu...

I'm seek...familiarity with SQL Server and Asp.net core. Your English skills will be crucial as direct communication with me is required. Key Responsibilities: - Develop a robust business management system leveraging ASP.NET - Implement user authentication and authorization features - Integrate appropriate APIs to enhance system functionality Ideal Candidate: - Minimum 5 years experience in ASP.NET development - Proficient in C# programming and SQL Server - Familiarity with Asp.net core - Experience in developing business management systems preferred - Strong communication skills for client call Please note that this project is only open to Indian-based independent developers. If you meet the requirements and are able to take active part in client...

Moda windows and doors Thailand need a comprehensive tool that can draft and m...comprehensive tool that can draft and manage quotations, invoices, and tax receipts. The ideal candidate should be able to: - Develop a user-friendly Android app with the primary functionality of creating quotations, generating invoices, and issuing tax receipts. - Include features such as data storage, enabling the app to keep track of past transactions. - Implement a PDF generation feature to allow for easy sharing and printing of documents. - Incorporate customer management functionalities, making it easy to access and edit customer details. - Calculate the cost per square meter accurately for windows and doors. The tool has to be versatile and compatible with ...

I’m seeking a professional Virtual Assistant for 10-20 hours per week to assist with the following: - Calendar Organization: Coordinating personal and business events in Google Calendar. This requires excellent attention to detail and prompt updates to avoid schedule conflicts. - Event Planning: Must be able to plan and execute all details about various types of events. This will require excellent communication skills and adept use of Google Calendar. - Task Prioritization: Helping me sort through my daily tasks and prioritize them on Trello. The candidate needs strong decision-making and organizational skills to effectively categorize tasks based on their importance and urgency. Ideal candidates will have excellent time management skills a...

We're looking for someone to qualify leads and set appointments with interested parties for our web based 3D virtual floorplan software. We'll initially enlist you for a trial period and then afterwards we'll look at paying you for a set number of hours as milestones. We currently have hundreds of contact details which need to be worked. Competitive rates will be prioritised. Skills needed: Good conversational English Preferably neutral accent Ability to evangelise a product Competent with telephone sales Duties include: Cold calling from a spreadsheet of prospects Work using a script as guidelines Pitching our product to prospects over the phone Conversationally move a prospect to a booked meeting with our Sales Director The...

I'm seeking a data operator skilled in the analysis and visualization of numerical data. The primary task is to handle the numerical data in my CSV file. Key responsibilities include: - Data Analysis: You'll be responsible for performing thorough data analysis on the numerical figures in the file. - Data Visualization: In addition to the analysis, I need engaging visualizations of the data to be created. This will help to communicate the insights effectively. Specific tasks I need help with include: - Descriptive Statistics: You should be able to calculate and present descriptive statistics for the data. - Trend Analysis: You'll also need to identify and represent any trends present in the numerical values. Ideal candida...

I'm looking for an experienced Azure Analytics specialist who c...Analysis & Data Visualization within Azure Analytics - Programming: If the opportunity arises, the candidate could get involved in programming using SQL - Proficiency: I consider myself at an Intermediate level with Azure Analytics Ideal Skills and Experience: - Proficient in Azure Analytics: You should have a strong understanding of Azure Analytics, specifically in Data Analysis and Data Visualization - SQL Programming: Experience with SQL is a must as you may be involved in programming for this project - Teaching or Coaching Experience: Prior experience in teaching or coaching Azure Analytics would be advantageous - Strong Communication: The ability to clearly explain concepts and guid...

A business-centric, data-oriented, and analytical mindset. Comprehensive knowledge of data science concepts and disciplines. Knowledge of enterprise information management processes and methodologies. Skills in database design, data security, and data lifecycle ...considerations. . Combinations of experience and education will be considered on a case-by-case basis. Experience in data warehousing and governance. Practical experience in enabling data usability, availability, and efficiency. Experience in data management, quality, metadata management, and modeling. Knowledge of database systems: MS SQL Server, Oracle, or another commercial RDBMS required, Snowflake, or other non-relational database desired. Knowledge of SQL. Experience with scripting languages, especially Python...

In order to realize the scientific research project of "International Chinese Education Demand Monitoring, Prediction and Countermeasures Research based on Big Data", and create a website that can query the real-time popularity of Chinese learning language in all countries, the following is a website layout and function plan: ### Web Site name: Global Chinese Learning monitoring platform ### Website Layout: 1. * * Home page * * -Top navigation bar: contains the site name, search box, and user login / registration options. -Global map: 1. Identify the popularity of Chinese learning in different colors.2, Click each country, can feedback heat data, etc., you can jump to the second plate 2. * * National heat query * * -List of countries: arranged alphabe...

...production, analytics, user access control, and Windows-based applications. This job involves maintenance of a warranty return tracking software, with specific attention to: - Inventory management: Ensuring that the software effectively tracks the inventory of returned products - Reporting & Analytics: Enhancing the software's capability to generate insightful reports about warranty returns. - User access control: Improving the control measures for different user permissions within the software. - Ticket creation, Data Import and Export: Aptitude in handling these features are considered a plus. The overriding purpose of this software is to track and manage warranty returns effectively. Ideally, you should have previous experience in software creation and...

I am in the process of implementing a final year project focused on Precision Farming. The project aims to leverage real-time crop images and AI to enhance crop monitoring, ultimately increasing crop yield and reducing water usage. Key requirements and deliverables include: - Building an intuitive Web UI that can analyze and display real-time crop images - Implementing machine learning algorithms using Python to interpret and predict the crop health and water requirements - Designing a robust backend system that can process and store large volumes of image data The ideal freelancer for this project should have: - Proficiency in Python programming - Experience in developing machine learning algorithms - Strong background in image processing and analysis - Prior expe...

...students, and parents to log in with different levels of access. Student Information System (SIS): Store and manage student demographics, academic records, attendance, health information, and conduct records. Teacher/Staff Management: Manage teacher and staff profiles, attendance, timetables, and leave requests. Online Exam Module: Create and manage online exams with customizable parameters (e.g., time limits, question types). Provide tools for question creation, including multiple choice, short answer, and essay questions. Enable automated grading for objective questions and manual grading for subjective questions. Ensure security measures to prevent cheating, such as randomized question orders and browser lockdown. Result Management: Record and manage exam results. ...

I'm seeking a professional well versed in biostatistics for a hypothesis testing project related to medical data. I want to calculate the number of samples needed to be sequenced for a specific disease

I need an adept SQL developer proficient in crafting SQL queries for various tables within our database. The task entails generating four queries, each encompassing approximately 20 conditions that must be met. Utilizing ChatGPT, could you assist in devising these queries?

I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design principles. - Medium...

Hello everyone. I need a query for prestashop version 1.7.8.10. I need to run 2 times a day a check script on products that have quantity 0. When I have quantity 0, I need to disable the product. I need a script that performs this operation 2 times a day.

Note: Budget Fix 2000INR and time line 5 Day's I have a project currently in Codeigniter 3, and I'd like it converted to Laravel 10. This process will require thorough understanding of both frameworks, and it's crucial that all existing features and functionalities are precisely replicated in the new version. While I don't have specific features to prioritize, I will identify specific elements as the project progresses. Skills and experience required: - Profound knowledge in Codeigniter 3 and Laravel 10 - Expertise in PHP development and SQL databases - Proven experience in similar conversion projects Note: The finalized budget for this project is 2000INR. Please only bid if you can work within this budget. The timeline for project completion ca...

I am looking for Website for B2B and B2C. Data will be reflect to the Admin portal from both B2B and B2C pages. Need to create 5 pages for Website B2B Page Tasks Need to create Query request form on B2B Need to create registration form on B2B Need to create Inventory management page on B2B B2C Pages Need to create registration page using whatsapp, social media and phone Customer can search for the desired result which will be based on the B2B inventory management page In the result page our recommendation will be listed at the top Need to create app for B2B and B2C for android/IOS

Unity released a scene that already works for Vision Pro and is ready for augmented reality. I added som...released a scene that already works for Vision Pro and is ready for augmented reality. I added some buttons and it works 100%. So, I am looking for someone to convert this augmented reality scene to virtual reality using Unity3D 2022.3, as they released it natively and configured. I need someone to do this conversion and ensure that the buttons, which already work, also function in virtual reality. Since it already works for Vision Pro (simulator and device), I need it to work for virtual reality, Vision Pro, and simulator as well. I am attaching a video below of my application in action. The bid starts at $75 just for converting it to virtual realit...

I'm looking for a UI designer to develop a clean and minimalist interface for a stock taking application. This UI will be used primarily by our Warehouse staff. Key components of the project include: - UI Design: The primary focus of this project is the design of the user interface. It should be user-friendly, intuitive, and minimalist in style. - Backend Development: The system will be powered by Microsoft Access. The backend should support: - Inventory Tracking: The system should be able to record and update our inventory. - Cost Analysis: The backend should be able to calculate the cost of our stock. - Report Generation: The system should be able to generate detailed reports based on the data entered. The ideal freelancer for this project...

Laravel Developer API Issue (Create 1 API and Fix 1 API) Work with ftp. Able to follow, fix API first Immediately.

...high-complexity T-SQL stored procedure used for data analysis that I need translated into PySpark code. The procedure involves advanced SQL operations, temporary tables, and dynamic SQL. It currently handles over 10GB of data. - Skills Required: - Strong understanding and experience in PySpark and T-SQL languages - Proficiency in transforming high complexity SQL scripts to PySpark - Experience with large volume data processing - Job Scope: - Understand the functionality of the existing T-SQL stored procedure - Rewrite the procedure to return the same results using PySpark - Test the new script with the provided data set The successful freelancer will assure that the new PySpark script can handle a large volume of da...