Tsql xquery query jobs
I am looking for an expert who can create complex input modules in a spreadsheet tool. The included modules will be a database query module, an AWS S3 retrieval module, and a file upload module. The project also encompasses developing an advanced pop-up to configure each module effectively. The configuration options should include: - Data source selection - Query parameters - File upload settings - Advanced filters - Choosing editable cells/rows/columns - Selecting fields to be used in the modules - Other specified configurations By the end of the project, I expect to have an intuitive tool that can effortlessly retrieve, handle, and save data from Databases/AWS S3 and handle file uploads. A good fit for this project would be someone with advanced knowledge and hands-on ...
I require the expertise to create a Telegram bot purposed for customer support. The bot's major function is handling product information enquiries. A crucial feature of this bot is its ability to respond with automated answers. Experience with Telegram bot development, query handling, and automated response system should be under your belt. Prior experience in customer service bots will be a plus. tg mehmed303
I am seeking a highly experienced fullstack developer with a minimum of 5 years of expertise in Mongo, Postgre SQL, Node, and React. The ideal candidate will not only handle regular development tasks but also demonstrate a deep understanding of database structures and complex query creation relating to both Mongo and Postgre SQL. Key Responsibilities: - Design, develop, and maintain both client-side and server-side components. - Develop high-quality, reusable, and scalable code. - Debugging and upgrading existing software. - Conduct comprehensive testing of software to ensure optimal performance. Essential Skills and Experience: - Proficient in Node and React. - Strong experience with Mongo and Postgre SQL. - Pragmatic problem-solving skills. - Strong unit test and debugging sk...
I'm looking for a skilled professional to design and implement a MySQL database system. The database cluster, mysql router, should feature: - data warehousing, Data analysis tools to interpret and present data in a meaningful way. - User management systems to organize and regulate users effectively. - Cluster management, sql router management. - Open source tool to monitor the slow query, query...effectively monitor the data base. Ideally, the system should be equipped to store an estimated 10,000 to 500,000 records. Strong experience with MySQL is imperative, alongside a working knowledge in data analysis, user management, and real-time data updating functionalities. Your portfolio demonstrating similar projects will be highly appreciated.
I need a skilled Devops engineer with experience in Python, Fast API, React, and Docker to he...are being hosted on Amazon Web Services (AWS) EC2, so proficiency with this platform is essential. Upon successful completion, the desired outcomes are: - Improved performance - Enhanced service isolation - Simplified development process Backend should have APIs that are protected with authentication and are exposed to the world to allow external services as well as frontend to connect and query. Knowledge of best practices for maintaining the separation between the backend and frontend is a plus. The ideal candidate should also be capable of explaining and documenting their work for future reference. Hourly bids are required to use Freelancer hourly tracker. No manual hours will be...
Hello, I have a simple php page and a complex database. My database size is very high and when I query a data I don't get a response for a very long time. I created a basic API and I have complex data in my database. I need a system that will delete repeated data in the database, destroy all unnecessary data and work with a proper, reliable api.
...images, each representing a country from all continents. - Generating three related answers for each image, only one of which is correct. - Saving these answers in a text file affiliated with the respective image. For example, an image of the Eiffel Tower represents France, or a katana represents Japan. Questions and their corresponding answers can be generated using ChatGPT with the appropriate query. A total of 100 images and the corresponding answers for each question are needed. Images should be generated using the KI-image generator. Ideal skills will include KI-graphic design, creativity, and a sense of world geography. Knowledge of countries globally and an understanding of minimalistic design is critical. Your work's success will be measured by the players' a...
...that your offer. if you have satisfy with my work and continue with next step , kindly accept this quote otherwise kindly mention the query or doubts based on the we will do improvements our Task. our working Style : * discuss the project with client * After implemented and show the working demo * if client satisfy then will only pay !!! so kindly verify our output , its helpful for your work, then kindly accept this quote. upto Completed Work: 1. Read Audio Files 2. Preprocess the deviated values 3. Extract the features 4. Training using Neural network 5. Compute the Calculated values from Audio signals 6. Evaluate performance Thank you :) if any query related to this project feel free to ask, if you need working code also we will send. (we like to do team w...
I have a Microsoft SQL Server installed and in operation, however, I am currently experiencing issues with slow query execution that ideally require rectification. I am seeking an experienced professional with specialization in performance tuning for Microsoft SQL Server. Skills & Experience Required: - Proven expertise in Performance Tuning and Query Optimization - In-depth understanding of SQL Server's underlying architecture, metadata and statistics to optimize queries - Solid experience in system analysis, profiling and tracing to diagnose and resolve performance problems - Ability to translate findings into actionable strategies to improve performance - Strong communication skills to effectively relay steps taken and results achieved. The main objective is t...
I need an SQL and SSIS developer for my personal project. My primary goal is to optimize my SQL database, which is currently facing several performance issues. Key Problems: - Slow query execution - High resource consumption - Inefficient indexing The ideal candidate should have a strong background in SQL and SSIS for database optimization. A thorough knowledge of SQL query optimization, resource management, and indexing is essential. I am seeking an expert who can effectively address these specific issues and enhance the overall efficiency of my SQL Server development. Any suggestions for further improvements are also welcome.
...urgently need a skilled SQL Server and SSIS (SQL Server Integration Services) Developer to propel my database optimization objectives. Your primary tasks will focus on: - Fine-tuning SQL queries - Carrying out schema optimizations - Development using SQL I'm currently dealing with several performance issues, including slow query execution, high disk I/O, and index fragmentation. Therefore, for this task, the ideal candidate should possess a sharp understanding of query tuning and optimization, as well as practical experience with complex SQL Server and SSIS development projects. If you have proven experience in eliminating these types of issues and know how to implement effective optimizations, I am eager to work with you. Your high-level SQL Server knowledge can...
...proposition of through proposals and presentations to the prospects. Lead nurturing, engagement, and closing sales. Persuade clients to sign search contracts on an exclusive and/or retainer basis. Provide accurate and detailed forecasts on weekly/ monthly funnel of identified and proposed customers to meet and exceed sales requirements. Email coordination/timely update on whatsapp group by managing query flow of calls/emails/messages from candidate/internal team/clients. Stakeholder Management and Negotiation Requirements 2-4 years of business development experience in a recruitment agency/staffing firm. Proven track record in Client Acquisition and winning new business. Proven track record of increasing revenue through the generation of leads and placements. Lead and ...
Seeking a dynamic web developer to assist me with finalizing my website via enhancements in the JetEngine features. Need help with the following but not limited to: - Create queries in Query Builder that call from existing data. - Create tables in Table Builder based upon the Queries - Tie the tables into display on the front end pages that call for the inventory item.
I'm looking for a MySQL expert who can create a complex query to retrieve data from multiple tables (Table A, Table B, and Table C) of my database. These tables are interconnected, and the goal is to join data from all these tables, perform necessary calculations, then save the result into another table. Excel file with explanation is attached. Required Skills: - Experience in MySQL query writing - Ability to handle multi-table complex join operations
...do not expect you to start from scratch - please see: Responsibilities: 1) Provide a bespoke GraphQL adapter for Apache Superset, ensuring it can dynamically introspect the provided GraphQL schema and translate SQL queries into GraphQL queries. 2) Implement logic to handle both Relay-style connections and standard GraphQL schemas, including advanced query translation for filtering, sorting, and pagination. 3) Map GraphQL responses to a format that can be consumed by Apache Superset, ensuring data integrity and compatibility. 4) Write comprehensive unit and integration tests to validate the functionality of the adapter across various scenarios. 5) Prepare detailed documentation on the installation, configuration, and usage of the GraphQL adapter,
I'm looking for a talented Python developer with a solid understanding of Django and MySQL. The purpose of this project is to develop a robust database management system. These are some key features that the application should have: - Integration with Django's ORM (Object-Relational Mapping) library. - Custom SQL query functionality for advanced data operations. - A system for data backup and recovery to prevent data loss. You should have a proven track record with both Django and MySQL, and be able to show examples of similar projects you have worked on. A strong understanding of database design and management is a must.
I'm seeking a proficient FlutterFlow deve...these kind of applications will be greatly beneficial to this project. Specifically I am looking to debug my VoiceFlow Bot integration. I have copied over to a new FlutterFlow project just a test chat page to debug, then impliment into my main app. Here is the link to the page - click on the purple button in the app to launch the chat. You will see a "NULL" value returned when entering in a text query. My API Call in the backend of FlutterFlow works fine in the API Section but is not in the front end chat. I believe my issues are as follows: 1. API JSON paths, incorrect payload 2. Custom Code - JSON Return paths 3. Incorrect Launch Request upon chat page load Respond with your favorite food
Hello, I have a simple php page and a complex database. My database size is very high and when I query a data I don't get a response for a very long time. I created a basic API and I have complex data in my database. I need a system that will delete repeated data in the database, destroy all unnecessary data and work with a proper, reliable api.
I own an IT consulting firm which is recently extending its offerings to trainings in tech. The tech trainings offered are mainly focused on data analytics/science, BI and cloud computing. The courses are mainly given to people who have no prior tech or coding exper...are mainly given to people who have no prior tech or coding experience but those who want to break into tech career. I am looking to hire a skilled BI developer with extensive experience with Tableau, Power BI and other BI tools. The freelancer will be helping me design the curriculum and also teach BI and data visualization Must have skills: 1) Power BI-DAX, M Language, Data Modeling, Power Query 2) SQL 3) Good teaching skills. 4) Great command of English PLEASE SUBMIT YOUR PROPOSAL WITH YOUR RANGE OF EXPECTED HO...
I'm in need of a proficient Azure SQL developer skilled in query optimization and stored procedure. The purpose of this project is to automate certain tasks within our existing system. This will involve: - Optimizing my existing SQL scripts to ensure smoother operations - Developing new SQL scripts as required, to further enhance automation I expect candidates for this project to have robust experience in Azure SQL, particularly in developing efficient procedures and scripts. Proven problem-solving abilities and a keen eye for the fine-tuning of processes will significantly benefit this assignment. Familiarity with task automation will also be highly regarded.
I need a professional developer for my school website Jain Central school .. to create a static and creative website for me Requirements:- Html CSS Javascript Core php Ajax jQuery Media query
I am seeking to create an AI-driven application providing assistance across diverse subject areas. This application will be developed for both web/ iOS and Android platforms to reach a wider user base. Key features that the...and Android platforms to reach a wider user base. Key features that the app should include: - Personalized learning recommendations: The AI should tailor learning materials based on each student’s needs. Experience in machine learning and user data analytics will be beneficial. - Homework help: The app should be able to assist with homework enquiries. Experience in crafting AI chatbots or query systems would be advantageous. Ideal applicants should have robust knowledge in mobile application development across Android and iOS platforms, LLMs and ...
I am in need of a proficient Microsoft Access developer. The task involves designing a query to generate reports, specifically focusing on beneficiary data. This would include information such as: - Local Government Area (LGA) - Ward - Community - Household Reference Number (HOUSEHOLDREFNO) - Caregiver Name (CAREGIVER NAME) The project necessitates reliable skills in data filtering and report generation on MS Access. Any prior experience or extensive knowledge dealing with similar data or report types will be high regarded. Though not a dealbreaker, familiarity with beneficiaries' data or related fields would be beneficial.
...configuration, backup and recovery, and monitoring. • Write efficient SQL and PL/SQL code to support application development, including the creation of functions, stored procedures, triggers, and packages. • Develop and maintain ETL processes to extract, transform, and load data from various sources into Oracle databases. • Optimize database performance through tuning, indexing, partitioning, and query optimization techniques. • Collaborate with cross-functional teams to design and implement database solutions that align with business objectives. • Troubleshoot and resolve database issues in a timely manner to minimize downtime and ensure data integrity. • Develop and maintain documentation related to database design, configuration, ETL processes, an...
I'm seeking an expert web developer with extensive WordPress experience for my project. The primary task involves creating an efficient search filter that accurately produces relevant results on my site. The focus is to streamline searching so that when used, the filter produces content related to the targeted search query on general web pages. At present, the filter does not return relevant results hence the urgency. Ideal skills and experience: • Proficient in WordPress and search algorithms • Strong experience in programming diverse search filters • Agile in troubleshooting and web development • Understanding of SEO and web optimization Your qualifications should include a proven track record of similar projects. This understanding is crucial for deli...
...proposition of through proposals and presentations to the prospects. Lead nurturing, engagement, and closing sales. Persuade clients to sign search contracts on an exclusive and/or retainer basis. Provide accurate and detailed forecasts on weekly/ monthly funnel of identified and proposed customers to meet and exceed sales requirements. Email coordination/timely update on whatsapp group by managing query flow of calls/emails/messages from candidate/internal team/clients. Stakeholder Management and Negotiation Requirements 8-10 years of business development experience in a recruitment agency/staffing firm. Proven track record in Client Acquisition and winning new business. Proven track record of increasing revenue through the generation of leads and placements. Lead and...
I'm looking for a talented Python developer with a solid understanding of Django and MySQL. The purpose of this project is to develop a robust database management system. These are some key features that the application should have: - Integration with Django's ORM (Object-Relational Mapping) library. - Custom SQL query functionality for advanced data operations. - A system for data backup and recovery to prevent data loss. You should have a proven track record with both Django and MySQL, and be able to show examples of similar projects you have worked on. A strong understanding of database design and management is a must.
Excel web query to extract data into Excel spreadsheet from also extract Live odds comparison table from Currently, these 2 tables are not showing up using Excel web query
As we have already discussed about the project or if you have any query you can ask for it
You can see the Firestore data in the screenshot. I want to query for device name. So only show data which contains the word ELOC22 in app_data. Seems easy but i can't make it work. Anybody? If you know how to do it. It would be great if you can connect to my PC via Anydesk and show me how its done :)
Budget: 5$ I'm in immediate need of a professional with skills ...free to browse the internet and find the png logos. All the logos provided should be standard sized, transparent background in png format with one color and one grayscale export. I need the following logos: SAP SAP Business Objects SAP Analytics Cloud Microsoft Microsoft Power BI Microsoft Power Apps Microsoft Azure Microsoft Fabric AWS AWS Redshift Google Google Cloud Platform Google Big Query Tableau Qlik Salesforce Zendesk For your application to be considered, please: - Be experienced in creating and editing logos - Include at least one example of a logo for me to see you can edit this properly. Attention to detail and a quick turnaround time are critical for this project. I look forward to your sp...
I'm in need of a seasoned PHP Laravel developer for a project focused on database integration, specifically with MySQL. The core task for this engagement is query optimization. Skills and Experience required: - Profound expertise in PHP development - Familiarity and proficiency in MySQL - Proven track record of successful query optimization I'm looking forward to engaging with highly qualified and responsible individuals for swift, efficient implementation of this particular task.
My project revolves around a MySQL select query that is showing slower-than-desired execution times. I cannot provide the data as it has PII and is very large. Main issue is that for pulling 1 month of data it takes about 3 hours, regardless if it returns 500 rows or 500,000 rows. There is likely a required index that I cannot see. I will be providing 1) The query 2) The Explain Tree 3) The table definition from which it is pulling data.
I have a mysql query which loads customers email addresses thru a php script. inside the php script it loads all customer email and usually only takes about 5 seconds then also in the script it loads any emails which have been BLOCKED or BLACKLISTED these come from another table then it allows me to filter the emails and remove the blocked emails from the mailing list before sending emails. BUT HERES THE MAJOR PROBLEM as my blacklist or blocked list grows the query time seems to GROW EXPONENTIALLY ive went from 5 secs with 0 blocked emails to 70 secs with just 300 blocked emails its taking around 5 secs for every additional email i add i had a look at the query it doesnt seem excessive but something is slowing it down i need this looked at to see if we can come up...
Hello, I am looking for a creative freelancer who can create new teaching materials for teachers to use in the classroom every day. You can find examples of good teaching materials here: Nice cover: Currently, I would like to have different teaching materials for children in grades 1 to 4 (ages 6-10). Each material should have a goal. Please let me know in advance exactly what the material you create will be used for, what subject it will be used for and how it will be used. Each material should be 5-25 pages long with 1 cover page (in a file). No copyrights must be infringed (if other resources/licenses other than are used, always specify). Only
After reviewing the files you have sent, I understand that you are looking for SQL expert to write sql query and extract the data. I have carefully analyzed your needs and believe that I possess the skills and expertise necessary to successfully complete this project. I estimate that I will take approximately 1-2 days to complete.
...and promotions with a 50% discount. Users will have access to a wide range of purchasing opportunities, covering various product categories. Project Benefits: Expansion of research to cover a wide range of offers. Increased accuracy in online searches. Specific relevance to user needs in the buy-sell market. Overall improvement of the user experience. IT Professional Needed: Advanced Search Query Architect: We are looking for an IT expert specializing in optimizing online searches through advanced queries. Required skills include: Programming Languages: Advanced experience in scripting languages like Python to develop a dynamic and adaptable script. Google Dorking and Advanced Search: In-depth knowledge of Google Dorking and advanced search techniques. Reference Ontolog...
...into manageable sections for AI processing. Familiarity with PyMuPDF, PDFMiner, and natural language processing tools like SpaCy will be crucial. Searchable Index Creation: Creating an efficient searchable index with Elasticsearch to power quick retrieval of text segments relevant to user queries. Experience in integrating Elasticsearch with large datasets is highly desirable. AI Integration for Query Processing: Collaborators will also work on integrating AI models to analyze queries, retrieve relevant document segments, and generate coherent answers. Expertise in AI model integration, preferably with OpenAI's ChatGPT or similar technologies, is required. User Experience & Interface Feedback: Ensuring a seamless loop of user feedback and application refinement, aiming f...
I am seeking expert assistance with a Microsoft Access report that is a bit complex for me. The report is built around several linked tables, and I am currently having difficulties managing calculations and queries related to it. Key Tasks: • need last price from vendor for list of items in a table • Revising existing queries • Extracting operational data The crux of this project revolves around understanding the report and improving the queries to get the right operational data. As such, vast experience in handling Microsoft Access linked tables and proficient knowledge of SQL will be crucial. Thank you for considering my project.
... What is needed: If request URL returns 404, display a page with relevant Google search results. Get the results from my API (or your API if the price is good). How to display results: Query API for the request URL Take title (minus subdomain name if exists in title) and query API again for that title Display 4-6 results on this page. Store results in JSON in case this URL is requested again (to avoid API calls for this URL). If Query API for the request URL returns no page title, query API for the subdomain of the request URL, return 4-6 results. You will need to do it on your localhost, I cannot provide server access. Any reply without " I have fully read and understood what needs to be done and I can do it on localhost " will
I'm searching for a Laravel developer to make some upgrades in our API. The project lacks specifics as some initial questions were skipped, however, the core objective is enhancing our API. The possible changes as per initial query comprised: - Adding new features - Improving performance - Fixing bugs The subsequent questions on the specific required changes were also overlooked, so we're open to any enhancements that could be made on your professional perception. Ideal Skills: - Proficient in Laravel framework - Strong experience in API building and optimization - Deep knowledge of web performance and bug-fixing Please, provide your proposal highlighting your previous experience and your ideas on possible upgrades for this API. Let's bring this Laravel API to a ...
...then redirected to either the success or failure URL provided by the merchant, based on the outcome of the transaction. The PSP sends a server-to-server API notification to the merchant with the payment status, ensuring that the merchant is immediately informed of the transaction outcome. Step 9: Merchant Communication Beyond the immediate transaction notifications, the merchant has access to a Query API provided by the PSP. This allows them to check the status of the payment at any time, supporting ongoing order management and customer service efforts. This revised flow incorporates your specific requirements, focusing on leveraging information provided by the merchant to streamline the payment process, ensuring clarity and compliance with necessary agreements, and enhancing the...
I need an experienced Laravel developer who can identify and solve issues with the efficiency...developer who can identify and solve issues with the efficiency of specific database queries and faulty job queues in my Laravel 5.8 project. Key Areas of Concern: - Fixing slow queries: The database query that retrieves user information is running slower than it should. I am looking for a solution to speed up this process. - Resolving queue issues: Job queues are failing to run, causing an operational bottleneck. Your task also includes finding and implementing a fix for this issue. Ideal Skills: - Proven expertise in Laravel, particularly version 5.8 - Good understanding of database query optimization - Familiarity with queue and job execution in Laravel - Clear and prompt com...
...proof course - Evaluating concrete cavity filling (1:6) mix - Analyzing requirements for site protection from water from any source - Evaluating a 200 mm thick hardcore filling and any treatment required - Studying DPM mastic asphalt to BS 1418 in 3 coats - Gauging 100 mm thick concrete floor (1:2:4) mix. I also require you to provide a reference sheet showing which parts of SMM7 were used and a query sheet with assumed responses. Prior experience with SMM7 and a deep understanding of the associated measurements is a prerequisite for this job. You must be meticulous with calculating and reporting as these measurements will contribute to cost estimates required for preservation, plain concrete foundation, and hardcore filling treatments. Your ability to provide a comprehensive c...
I am looking to take an exisiting Github Project and bring it up to date with a Web App Gui that can be self hosted. Current project is here : This project was originally written in Go and I want the new version to be self hostable. Functionality needed 1. Query DB for latest titles 2. User Can specify location of files 3. Using DB App will sort files / updates int sub folders etc. 4. Further functionality to be added later on.
...freelancer skilled in Power Query for some targeted tasks. These tasks include: 1. Data Cleaning and Transformation: I need assistance to clean and transform my data ensuring its integrity, relevant, and useful for further analysis. 2. Data Merging and Consolidation: I have different datasets that need to be merged and consolidated. The goal is to improve data accessibility and usability in analysis. 3. Data Modeling and Analysis: After cleaning and consolidating, I would like the freelancer to insights from the data through data modeling and analysis. 4. Custom Functions: Alongside the tasks above, I require help in creating custom functions in Power Query to make the process more streamlined and efficient. The data source in use for these Power Query...
...be arranged in tables, generally organized like in the attached image. A list of departments is in another of the attached images. User should be able to click to hide/display prior years and click to hide/display min/avg/max values as well. At the bottom of the report, a grand total section that includes all departments should be displayed in a similar fashion as the departments. The MySQL query that is used to obtain a given total from the data is: ------------------------ SELECT SUM(llx_facturedet.total_ht) AS Total FROM llx_facture AS t LEFT JOIN llx_societe ON t.fk_soc = LEFT JOIN llx_facturedet ON = llx_facturedet.fk_facture LEFT JOIN llx_product ON llx_facturedet.fk_product = WHERE llx_product.accountancy_code_sell = "4012"
I'm in desperate need of assistance with a database management assignment. The tool of choice for this project is MySQL, necessitating an expert familiar with the specifics of this particular database system. With an urgent closure time frame of 2 hours, you will need to hit the ground running. The assignment centers on two key areas: 2. Understanding Database Concepts - In addition to query writing, a solid understanding of core database concepts is necessary. Part of the task may involve explaining these database concepts to me, so clear communication is important.
I need to setup latest mysql (v8.x) on C++ on my windows 64. The C++ is installed using Msys64 (not visual studio). I need you to figure out how set up the mysql for this c++ for me on my computer. Before I hire you, you must provide a video demonstrating the installation steps successfully on your own computer, and showcase a test by writing c++ code to run a basic mysql query. If the video convinces me that you can do the job correctly, then I will hire you so that you do it on my computer. I will give you control thru anydesk, and you will have to repeat the installation steps on my computer too. And after that, I will do the steps from scratch once again while you watch me, and you troubleshoot me if I get stuck somewhere. PAY: 3000 INR + 2 reviews of 5-star each
