How to write sql query in sap jobs

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

I need a comprehensive responsibility matrix for our Sap MDG & BODS project. - The Matrix needs to clearly outline the roles and responsibilities of each team member involved in the project. - It should include both high-level, overarching responsibilities and detailed, task-based responsibilities. - Our intention is to use this matrix as a live document for daily project management, as a reference document and as a tool to facilitate efficient communication between different teams. The successful candidate for this project must have: - Strong knowledge of Sap MDG and BODS - Experience in creating clear, comprehensive and actionable responsibility matrices - Excellent communication skills to ensure that the matrix is effecti...

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

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.

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 f...

...delivering 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...

Data Specialist: The Data 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, wo...

...professional who's an 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 noti...

Hello, this is a simple task. One of my friend got french nationality after 7 years live in France. All he want write a simple and nice text for post all of his social media profile to tell his story.. little bit motivations will appreciate on the text. 500 words maximum. If possible give a photo with textes. But no obligation.. ask all the questions need to ask in private. Small budget. Thanks.

...seeking an independent ASP.NET developer based in India with at least 5 years of experience, strong C# programming skills, and 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 proj...

I need help for the layout, to comply with the APA 7th rules and to check the wording and spelling mistakes. Ideal Skills and Experience: Knowledge of the APA rules Mastering the layout and fluent in english It's important that the article is not only well-written, but also well-structured and free of errors.

...Analytics specialist who could coach me in the areas of Data Analysis and Data Visualization. The role may also involve programming. Key points: - Coaching: I need 1/1 coaching via Teams on Data 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 Experie...

...information management processes and methodologies. Skills in database design, data security, and data lifecycle management (i.e., gathering, cleansing, publishing, archiving, back-up and recovery, and purging) for large enterprise systems. Familiarity with master data, metadata, reference data, data warehousing, database structure, business intelligence principles and processes, and technical architecture. Knowledge of database management systems, metadata management tools, cloud storage, and associated security 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 ma...

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 countr...

I'm in need of a skilled developer who is experienced with inventory management systems, report 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 trac...

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 princi...

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

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

...who can write 20 Papers - each Paper at least 5 pages describing the critical tasks and AI Solutions on monitoring tools and Data Analytics. Each paper should consist of all the categories as attached sample along with diagrams and References. Attaching one Sample Paper for Reference. Key Responsibilities: - These Papers should be 100% plagiarism free and should not be detected under any AI Detectors - Should be able to Write Papers 20 Papers Total - 5 pages in each Paper - Explain the task in detail along with diagrams (Attaching the Sample) I'm looking for someone with: - Proficient English skills for clear communication. - Experience in data analysis, and the APM, Customer Experience tools. - Strong problem-solving skills and attenti...

...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 larg...

I'm looking for an intermediate SAP administrator to assist with the basic administration of our SAP system. Key Tasks: - Basic user management, including creating and deleting users, assigning roles, and setting up authorizations - Monitoring system performance and taking necessary actions to ensure it runs smoothly - Troubleshooting and resolving basic configuration and authorization issues - Assisting with system backups and ensuring data integrity - Providing general support to the team on SAP-related queries It's important that you're comfortable working with the SAP system and have a good understanding of its basic functions and administration. A background in SAP Administration or similar roles is prefe...

I need a custom custom GPT model in OpenAI called "GPT-Invoices". The objective of this project is to enable the GPT model to analyze invoices stored in a OneDrive folder and answer various queries related to these invoices. Once this functionality is implemented, I want to integrate it with Excel to call the GPT model directly from Excel cells and receive responses in the same cells. Project Requirements: GPT-Invoices Setup: The custom GPT "GPT-Invoices" should be able to analyze invoices stored in a OneDrive folder. The OneDrive folder will have subfolders for each month containing our company’s purchasing and selling invoices. The GPT should be capable of answering questions related to...

Our existing CGI...encountering issues when importing the exam's section breakdown from a .dat file. Due to this, we are unable to import the breakdown of results per section of the exam into the SQL database. We are seeking a proficient developer who can: - Analyze our existing CGI script and identify the cause of the breakdown import issue. - Provide actionable advice and steps to troubleshoot and resolve the problem. - Ensure the script effectively imports the section breakdown from the .dat file as intended. The ideal candidate for this project should have: - Extensive experience in CGI scripting and SQL database management. - Proficiency in handling and troubleshooting data import/export issues. - Ability to wo...

...looking for a skilled developer to update the controllers in my Laravel backend for my React Native application. Specifically, I need help with a single task to start, and if that goes well will task additional items thereafter: 1. Laravel Backend has a 'ProviderController' which sends 'Provider' results to app based on distance within radius. There is a 'Mobile Only' option that when checked is not limiting results to within that radius. The query is a bit messy, but is likely where the change needs to be made (see attached). App is published to TestFlight already and should not need to modify React Native source to address this, but can provide if needed. Ideally looking for a devel...

Hi Nima D., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

Hi Nima D., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

I'm currently in need of a skilled individual proficient in Elementor and JetEngine to assist in finalizing the configuration of dynamic content imported from another site. The content, which includes Artists, Styles, and Portfolio Items, has been imported successfully (as a Crocoblock/JetEngine "skin" as well as Elementor archive and single templates), but requires further configuration to ensure it functions optimally on my website and fits the visual aesthetic. Key Tasks: - Configuring Custom Post Types (CPTs): The project involves working on Artists, Styles, and Portfolio Items. These should be set up in a user-friendly way so that I can easily manage and present the content on my site. - Establishing Relationships between CPTs ...

...learning to curate content based on user preferences. The dashboard will feature an AI-driven recommendation system that not only presents news articles but also provides analytical insights into trending topics and sentiment analysis of news content. Objectives: Main Goal: Develop a web application that personalizes news content for users based on their reading habits and preferences. Secondary Goals: Implement data visualization features to display trends and sentiment analysis of news articles. Minimum Requirements: Content Aggregator: Develop a system that pulls news data from various APIs or web scraping. User Profile Management: Create functionality for users to register, login, and specify their interests and preferences. Recommendation Engine: Implement a ...

...reporting, complex SQL formation, and more. The primary purpose of the project is to streamline and enhance our data storage capabilities. By integrating new data into our warehouse on a monthly basis, we aim to improve our decision-making and business performance through enhanced data access and analysis. Key responsibilities include: - Reviewing and providing recommendations on the SOW for data warehousing - Offering expertise on ad hoc reporting and complex SQL formation - Helping to streamline data storage and improve decision-making - Ensuring the architecture can support monthly data integrations Ideal candidates should have: - Proven experience as a data architect - Expertise in data warehousing and ad hoc reporting - Strong SQL...

I am interested in finding software or a website that produces flowcharts (for an example see attachment file ). It must allow me to upload a file containing the definition of a flowchart and it creates the flowchart (see attached files and ). It will probably also allow me to manually create the flowchart one step at a time. There are three possibilities below: A (write app), B (find app) and C (find website). For B and C I will: 1. Milestone $5 and immediately release it to pay your FL fee when I hire you. 2. Milestone $10 for you to provide B or C below. 3. Release the $10 when you produce B or C. 4. Repeat 2-3 for each additional B or C that I need. For B or C you might have to ask the vendor/website for an example of a flowchart a...

I'm currently in need of a skilled individual proficient in Elementor and JetEngine to assist in finalizing the configuration of dynamic content imported from another site. The content, which includes Artists, Styles, and Portfolio Items, has been imported successfully (as a Crocoblock/JetEngine "skin" as well as Elementor archive and single templates), but requires further configuration to ensure it functions optimally on my website and fits the visual aesthetic. Key Tasks: - Configuring Custom Post Types (CPTs): The project involves working on Artists, Styles, and Portfolio Items. These should be set up in a user-friendly way so that I can easily manage and present the content on my site. - Establishing Relationships between CPTs ...

...individual to fill the role of Database Architect/Lead Developer specializing in Netezza and Oracle databases. The ideal candidate will be responsible for designing, implementing, and maintaining database solutions that meet the needs of our organization. This role requires strong technical expertise in both Netezza and Oracle platforms, as well as leadership capabilities to guide a team of developers. Responsibilities  Design and implement efficient database solutions for our organization, leveraging Netezza and Oracle technologies.  Lead a team of developers in the implementation and maintenance of database systems.  Collaborate with other stakeholders to gather requirements and define database architecture to meet business needs. ...

This is a juke box musical, i have a loose storyline. See the website with the same name.

...seasoned expert in both SAP Cloud ALM and Grafana to help me build a resourceful dashboard for optimal data visualization. Given my beginner's level in using Grafana, I'm looking for clear, thorough guidance to navigate through this tool effectively. **Your Main Task:** 1. Tutoring on how to construct a Grafana dashboard with a SAP Cloud ALM data source **Intended Metrics:** - System performance metrics - Custom metrics from calm logs and calm LMS **Skills and Experience Needed:** Preferably, you have: - A solid understanding of Grafana and how to use it for data visualization - Significant experience working with SAP Cloud ALM data sources - Proven ability to provide step-by-step instru...

Hi I will share the details with the shortlisted candidates. Thanks

Looking for a Senior BDA with experience in. AZURE SQL SERVER. English mandatory. 1d per week helping to improve and maintain our main DBs.

...am looking for an experienced course creator to develop a comprehensive video tutorial focused on Microsoft Power Query. Key Features: - User-friendly interface - Capabilities to import data from various sources - Customizable course structure The ideal candidate should have the ability to break down complex concepts and make them easily understandable. The course content should cater to beginners and intermediate level learners. Course Duration: Each video course module should be crafted with the target of a total duration amounting to 3-4 hours. This could be composed of several shorter lessons or modules, for easy consumption and better learning experience. Required Skills: - Strong knowledge of Microsoft Power Query - Proven exp...

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 URGENTELY. We need work to be done in the first weeks from 8:00PM- 2:00am UTC -3 (Brazil Time) 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 conde in . , .NET ASP WEB API + MS SQL Details of our current project STACK can be seen here -> Prerequisites: For this optimization task you can bid your normal hourly rate but for the long term project the starting wage will be as stated below. 1) Accept initial hourly rate of U$5.00 2) Accept and start work...

I...Web Form application on a Windows Server 2022 on VPS. Key Requirements: - The SQL Server DB and ASP.NET Forms have already been set up on the VPS Windows Server 2022. The main task is to ensure the successful deployment of the ASP.NET Web Form application. Additional Details: - The cloud provider I am currently using is WABYNE. Ideal Skills and Experience: - Proficiency in cloud engineering and deployment processes. - Experience with ASP.NET Web Form applications. - Familiarity with Windows Server 2022 on VPS. - Knowledge of SSL certificate installation, database configuration, and firewall settings is a plus. Please provide your relevant experience, certifications, and portfolio when applying. Your approach to this project and estimated timeline will ...

...expert data analyst with proficiency in SQL and R for a comprehensive evaluation of a recently completed data analysis project. This project requires a review of SQL queries, R scripts, and database connections as detailed in a provided PDF. If you're ready to start right away and can deliver within 24 to 48 hours, please get in touch. Responsibilities: Conduct a thorough review of project requirements as specified in the PDF. Evaluate the accuracy and efficiency of SQL queries and R script implementations. Verify database connections and the effectiveness of data visualizations. Identify any discrepancies or areas for improvement. Deliver a comprehensive report detailing findings, issues, and potential improvements. ...

...skilled full stack developer to help with a web application project that I'm working on. The ideal candidate should be proficient in JavaScript and .NET, with specific experience in Angular and SQL Server. Key Skills and Experience: - Proficiency in JavaScript and .NET. - Strong knowledge of Angular and SQL Server. - Previous experience in developing web applications. - Ability to work collaboratively in a team setting. Responsibilities: - Develop the front-end using Angular. - Design and maintain the back-end of the application using .NET. - Ensure seamless integration of SQL Server for database management. - Conduct thorough testing to guarantee the application's functionality. This is a great op...

We are a forward-thinking healthcare practice dedicated to providing exceptional patient care through innovation and technology. Our team comprises passionate professionals who are committed to improving patient outcomes and streamlining healthcare processes. As we expand, we are seeking a talented Microsoft Power BI Specialist to join us in transforming our data into actionable insights. Job Description: Are you a skilled Microsoft Power BI Specialist with a passion for healthcare? Do you thrive on turning complex data into clear, actionable reports? If so, we want to hear from you! As our Power BI Specialist, you will play a pivotal role in our healthcare practice by compiling crucial reports that will inform our clinical decisions, enhance pat...

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

I'm searching for a proficient Go coder to develop a software application tailored for the Linux platform. Key requirements include: - Proficiency in the Go programming language - Proven experience in software development - Keen understanding of the Linux operating system - Network programming - Geneve encapsulation - CoreDNS development Looking for Go programmers with strong networking background to write a DNS handler plugin for CoreDNS which can receive Geneve packet from client, decap the underlying DNS query in UDP or TCP or DoH preform DNS resolution as normal through the built in forward plugin. On the response side the plugin must be able to encap back to Geneve and respond to client.

As of 2024, I'm in need of a comprehensive guide on exchanging Bitcoin to a bank account. The guide should be tailored towards: - Advanced users seeking in-depth analysis and insights. - Written in a comprehensive analysis style. The guide will need to cover the following aspects: - Step-by-step process of converting Bitcoin to a bank account. - Detailed explanation of each step and its technical nuances. - In-depth analysis of the current trends and challenges in this process. - Recommendations for the best practices and potential pitfalls to avoid. The ideal candidate for this job should have: - Profound knowledge and experience in cryptocurrency, especially Bitcoin. - Strong understanding of banking systems an...

I'm seeking a skilled C# developer to create a software solution aimed at processing data from a Winsock for a wifi connected Weight Scale and get the reading and put in a Microsoft SQL database.

...presentation done on the Disabled Facilities Grant (DFG) in the UK. This will be presented in PPT and should run for 8 minutes, no AI: MAIN QUERY OF TASK: "The DFG team currently has a large backlog of cases, both children and adults, that need to be dealt with and processed promptly and efficiently. We will be undertaking a process review to enable us to achieve eliminate the backlog. What suggestion would you have to update the process, and the service, ensure HBC compliance, and ultimately customer satisfaction? Key Task: - Conduct Research: The main focus of this presentation will be the process review of the DFG application process in the UK. The ideal candidate should have a strong background in thorough researc...

I am in need of an expert React Native developer to upgrade my existing app running v0.59.9 and bring it up to date with the latest version of React Native v7.0+ In addition to the platform upgrade also need to: - Upgrade Facebook SDK for FB login to continue working - Adjust query in 'My Activities' to only show activities created in the past, while 'Latest Activities' should only show future activities from all users within radius Skills and Experience: - Proficient in React Native - Experienced in upgrading apps to support multiple platforms - Familiar with the latest version of React Native