Sql code jobs

As a business user, I need assistance with the configuration of SS...WebPortal using Report Server Configuration manager and I am able to run SSRS reports from the Web UI. The project requires the following: 1. Automatically Scheduling of SSRS reports with default parameters. 2. Exporting the outcome of SSRS reports in a given folder every time a scheduled report runs I am experiencing the following issue while scheduling: Error: The SQL Agent service is not running. This operation requires the SQL Agent Service. You will need to help get rid of this error and set up scheduling and exporting of reports as mentioned. You will be required to get on a video call and help me set up the above over the call since this is a secured environment. Also, this needs to be executed...

... we're seeking a talented freelancer who can design an effective Power BI Dashboard to integrate various data sources including Excel spreadsheets, CSV files, and SQL databases. The ideal freelancer would: - Have extensive experience with Power BI and DAX language integration. - Demonstrate an excellent grasp of designing dashboards that report on KPIs. - Be well-versed with creating DAX calculations in the Power BI environment. We require the dashboard to focus on specific metrics, therefore, a strong understanding of reporting on KPIs using DAX language is a must. Additional Skills: - Proficient in Microsoft Excel and SQL databases. - Understanding of data integration and reporting. - High attention to detail. We're excited to collaborate with a dedicate...

I have an existing small carport enclosure that needs to be brought up to code standards. It is currently made of wood and I would like to include windows as part of the design. Key Requirements: - The carport enclosure needs to be assessed and re-designed if necessary, ensuring it meets all relevant building codes. - Windows need to be incorporated into the design without compromising the structural integrity. - The use of wood as the primary material will need to be considered and any necessary adjustments proposed to ensure it's compliance with the code. - The enclosure must maintain its functionality as a carport while meeting all code requirements. I'm looking for a professional who has experience in architecture and compliance with building codes, wit...

I need a Power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: - Retrieve Product ID, Quantity and Location. - Gather Specific Production Data including t...number. Ideal Skills: - Proficient in DAX query language - Comprehensive experience with Power BI - Excellent attention to detail - Previous experience in inventory data management will be a plus What to do: I need to get a query in DAX (Power BI) that gives me the same result as what I show in the excel file ( table (column in yellow)). The Excel file was obtained from the attached SQL query ( ) The two screenshots show the Power BI tables. I need to get a new column in Power BI that shows me the results like in the yellow column in Excel.

...for the Snipepay Payment Plugin: WooCommerce Integration: Develop a payment plugin to integrate Snipepay into WooCommerce, allowing users to choose Snipepay along with existing options like PayPal and GoUrl for payments. Deliverables: A fully functional WordPress plugin for hosting management. A Snipepay payment gateway plugin for WooCommerce. Skills Required: Proficient in PHP, JavaScript, and SQL. Experience with WordPress and WooCommerce plugin development. Strong understanding of RESTful API integration. Knowledge in payment gateway integration, specifically Snipepay, PayPal, and GoUrl. Excellent problem-solving skills and attention to detail. Project Timeline: Please provide an estimated timeline for completion with your bid. Budget: Your bid should include the total cos...

I need an Excel expert to build a tool that can automatically validate and correct any incorrect country codes in the file. Requirements: - Replace incorrect country codes: The tool should replace the incorrect country codes with the correct ones. - Predefined list: The correct country codes should be determined based on a predefined list. - Daily updates: The tool should be able to handle daily updates. Ideal Skills and Experience: - Advanced Excel skills: You should have a deep understanding of Excel functions and VBA programming. - Data validation: Experience with data validation and manipulation in Excel. - Attention to detail: It's crucial that the tool is accurate in identifying and correcting country codes. - Timely updates: Experience in creating tools that can handle dai...

Hi Yasar W., I noticed you posted a following project ( https://www.freelancer.com/projects/sql/SQL-Expert-Needed-for-Data/details )

...from backup Activate 2. change the name of to 3. add the alias domain 4. Add the prt for and cname record for @ cloudfare , now i do manually 5. create the ssl for and have to do some sql sql command to change the Admin name , Instance name -- now i do manually 7. env file need to be updated 50% mile stone will be created at the time of awarding the project, All payment will be released as soon as satisfied with your work and fit to my requirements. If you are interested, please send me a message so that we can discuss... Thanks...

I'm looking for a developer who's proficient in C#, MS SQL Server, Dot Net, and XAMARIN to work on an already existing application. Need to improvise and add amend few things. Pls note we can pay maximum INR 4,000 for the work.

I am seeking an experienced Dynamics CRM 365 developer with Virtual Entity expirence. I have got few virtual entity tables link to Azure SQL database. One table has got 1:M relationship with another. In my form, I am trying to populate custom view in lookup field of this virtual entity lookup. I tried it in two different ways but it doesn't work. Method 1: I created fetchXML and link two tables, I get the result but issue is records don't filter in query. I tried this method with advance find as well, and again records don't filter according to criteria for virtual entity. in Advance find, if I try to select the columns from second table then I get error. Methos 2: I tried to create Fetch XML query and use addCustomView method. This method works if filter criter...

...in Python, SQL Server, and MongoDB, I am currently facing a challenge. A logical error in the code is causing a bug, and I need an expert to fix it. High-level summary of the code- 1. Fetch records from SQL server ( total 680000 records) 2. Apply face recognition on each record 3. Insert the response from step 2 in MongoDB along with other data from the SQL server Issue- The existing code is currently doing steps 1 & 2 and performing step 3 at last when face recognition is applied on all records. Due to this it step 3 is waiting to complete the step 1 & 2. Expectation- After fetching each record from SQL server, the code should apply face recognition and then store the data in MongoDB immediately. I will share my screen...

...from backup Activate 2. change the name of to 3. add the alias domain 4. Add the prt for and cname record for @ cloudfare , now i do manually 5. create the ssl for and have to do some sql sql command to change the Admin name , Instance name -- now i do manually 7. env file need to be updated 50% mile stone will be created at the time of awarding the project, All payment will be released as soon as satisfied with your work and fit to my requirements. If you are interested, please send me a message so that we can discuss... Thanks...

We need Oracle resource who are expert in below skills and having 8+ years of exp. Mandatory Skills: *• Need candidates with extensive experience in data migration across CRP, SIT, UAT, and GoLive phases in Oracle Fusion ERP implementation, utilizing ETL tools. * Experience in SQL Server, T-SQL, and SSIS Job Responsibilities: Data Extraction: * Extract data from various source systems, including flat files, spreadsheets, legacy databases, and external APIs. * Develop and optimize SQL queries and scripts for efficient data retrieval. Data Transformation: * Perform data cleansing, validation, and transformation to ensure data quality. * Convert data from source formats to Oracle-compatible formats. * Apply business rules and data mapping for aligning source data ...

I need a Python code developed for vehicle route optimization. - The code should include 3 algorithms for route optimization. - Successful freelancers should include past work in the application. Ideal Skills: - Proficiency in Python - Experience in developing route optimization algorithms - Strong background in data analysis, web scraping, and machine learning, as these functionalities will be required in the project.

...need of a professional with expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficiency in ...

...need of a professional with expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficiency in ...

I'm looking to upgrade my current system, perhaps keeping the current Opencart (V1.52) system and working with it where possible... unless its deemed a rebuild is cost effective. The opencart system we use has been added and modified over time, hence it is not possible to simply upgrade to a newer opencart v...  4. Any other 3rd party systems (including internally) that the website communicates with (sending data either way) and any data grabs.    NO 5. Confirmation of payment gateways used. Realex (redirect to payment interface), PayPal   6. How the databases (products, customers, orders) are stored and if the data can be exported. Standard OC table structure… yes it can be exported as SQL data dump and all the products to stock link via the export featur...

Need help with a simple task that involves writing simple SQL statements and completion of the relevant ER diagrams. This task is in the context of simple data analysis. To be completed within 2-3 days.

I have a running Python file, who parse data from xml and insert it into sql server. Currently it isnt working. need an expert in python, who can fix it and upgrade few things as well.

I'm in urgent need of skilled professionals with experience in MySQL and Digital Ocean recovery console. My MySQL server is locked and I require assistance in exporting a SQL file. The exact cause of the server lock is not currently known but it might be due to server resource overload or a potential security breach. Required Skills: - MySQL - Knowledge of Digital Ocean's recovery console - Server management The main objective of the task is: - Successfully export the locked SQL file for further analysis and resolution - Provide insights on the potential cause of the server lock for future prevention. Experience in server management, specifically in handling locked servers, will be a great plus. Thanks.

I am seeking a skilled database developer to convert my .frm and .idb files into a SQL file. The original files are in MySQL format. Key tasks will include: - Conversion of .frm and .idb files to SQL format. - Exporting these converted files to mysql server. I did not specify any special properties or features of the .frm and .idb files that need to be preserved, but will appreciate a careful and diligent conversion to ensure no data loss. The ideal candidate for this job would have: - Extensive experience with MySQL 5.7. - Proficiency in SQL file conversion. - Strong knowledge of database export practices. - Keen attention to detail to ensure data integrity.

...the time needed to complete different task documents, on an agreed fixed price. The best offers with the right experience will have the opportunity to work with us on a long-term basis. Also, Good prospects for the right developers, based on the performances evaluated over a period of time, once you established your skills. Need to provide the changed code details and sql queries if any at the end of each sub-task, with the changed code line numbers. Unlimited Revisions are needed. Any bugs created due to your own developments are to be fixed on free of Charge. Recruitment is for a long-term big project as such, all the developers are subject to practical skill test for which not paid. Please send your details for the below-mentioned questions. 1. What type o...

I'm looking for a skilled PHP developer to create a code editor plugin. The plugin should replicate the functionality of the Shopify code editor, offering Syntax Highlighting, Auto Complete, Error Detection, and supporting both HTML/CSS and PHP languages (PHP support is optional). The plugin is intended to be a standalone component, not embedded or replacing any existing editor. the editor should include a file search (to search through templates) - similar to shopify but as well as searching filenems it shoudl also search in contents The editor shoudl work with a master theme/child theme style system such that when a template is modified its auto-copied to the child theme Key requirements: - Develop a code editor plugin similar to Shopify's - Implement Sy...

I need a ...time, drop off location - Every day 3 buses are departing to airport. Say morning 8am, 1pm and 8pm. We need to get auto emails based on this bus timings of scheduled pax list and they take manually report with date/time filter. Ideal Skills: - Strong background in web application development - Experience in booking system or related is a huge plus - Fluency in database management, preferably SQL - Proficiency in PHP or a similar back-end programming language - Strategic problem-solving skills and attention to detail The success of this project requires not just technical expertise, but also a clear understanding of travel agency operations and the importance of efficient booking management. If you have relevant experience and the right skill set, I look forward to...

...Python 3 code for our JFrog Artifactory setup. It currently handles the basic tasks of downloading, uploading, and moving our libraries, but unfortunately, it leaves quite a bit to be desired in swift performance, overall stability, and error handling. Here's what I am ideally anticipating: - Speed up Performance: We need our code to execute operations at a faster clip. - Enhance Stability: The code needs to run reliably without crashing or running into instability issues. - Improved Error Handling: The implementation of stronger, more effective error handling is a must to solve unexpected incidents. Your proficiency in Python, especially Python 3, is crucial, and prior experience in tweaking JFrog Artifactory is going to be billed as a huge plus. Your...

Details are provided in the attached files. Please read them all!

I'm currently in need of an experienced full stack developer who is proficient in both JavaScript and PHP. Key requirements: - Strong skills in front-end development, specifically using JavaScript. - Proven experience in handling backend development with PHP. - Knowledge of SQL is also important. - While not a strict requirement, familiarity with JavaScript frameworks such as React, Angular, or Vue and PHP frameworks like Laravel or CodeIgniter would be a big plus. - Experience with SSL implementation is a must, but there are no strict preferences as to the type of SSL to be used (Wildcard or EV SSL). Being able to pick the right SSL depending on the project’s needs will be part of your responsibility. If you're the kind of developer who is adept at managing the f...

I'm seeking a Python expert with a focus on code generation. Key Skills and Experience: - Extensive experience in Python - Automation and code generation expertise - Demonstrable background in improving code quality - Ability to streamline repetitive tasks - Strong understanding of enhancing productivity through coding Please provide examples of your past work and demonstrate your experience in code generation.

I need help using Squareline Studio and having arcs that are displayed on a touch screen to print their values to the serial monitor of Arduino IDE

I'm looking for a solution to generate QR codes within an Excel document. The QR codes will be primarily used for URLs. The Attached Document Need Text Data from "Sheet Data" Column A into B2 Need Text Data from "Sheet Data" Cloumn B into A11 as a QR Code Need Text Data from "Sheet Data" Cloumn C into G1 as QR Code The data will be manually pasted into "Sheet Data" I need this for 50 Sheets Pages to ignore Coverpage, Inside and Page Breaks Key Requirements: - Ability to generate QR codes in Excel: The end product should be an Excel script or add-in that can create QR codes based on the URLs provided. - Implementation of standard QR codes: Custom designs are not required. The focus is on generating functional, standard QR cod...

I'm in need of a professional to assist in C code writing for my PSoC Creator project. The main task will be to handle the dump and write operations to an I2C EEPROM. You can read the document I upload and Ican send you the part of accelerator which I have wrote successfully. The key responsibilities include: - Developing the necessary algorithms for the dump and write operations - Configuring the necessary peripherals to enable communication with the I2C EEPROM - Implementing interrupt handling for efficient operation The ideal freelancer for this project should have: - Previous experience with writing C code for PSoC Creator projects - Proficiency in handling I2C communication - Strong skills in algorithm development and peripheral configuration

...needs to be updated to SQL via a API POST call (this endpoint is developed you need to call this Only) and keep a backup at local database. POST JSON - { "Username": "", "MachineName": "ABC", "Timestamp": "", "appliedPolicies": [ { "Policy1": "0", "Policy2": "2" } ], "removedPolicies": [ { "Policy3": "2" } ], "changedPolicies": [ { "Policy4": { "oldValue": "0", "newValue": "1" } }, { "Policy10": { "oldValue": "0", "newValue": "1" } } ], "PolicyStateChangedByUser": "admin", "AdditionalMessage": "Add...

I'm looking for a skilled coder with experience in sensor integration who can create an example of code integrating a TLE4922 speed sensor. The purpose is to educate on the process of integrating sensors into programming, not specifically tied to any particular application such as monitoring vehicle speed or detecting object movement. Required Skills and Experience: - C programming language proficiency - Sensor integration experience, particularly with speed sensors - Ability to create clear sample code for a learning purpose. The resulting code should be clean, efficient and easy to understand, written in the C language. If you have past experience of similar tasks, please share it, as it will be beneficial. Looking forward to working with you to fulfill this ...

I am seeking a skilled freelancer who can convert my Python script code into JPEG images to improve its overall presentation. Key Responsibilities: - Convert Python script code into JPEG images - Ensure the output images retain the code's clarity and legibility Required Skills and Experience: - Proficient in Python coding language - An understanding of JPEG imaging format - Strong experience in code conversion - Attention to detail to retain code's legibility The ultimate aim of this project is to enhance the code's visual presentation without compromising on its readability. Only experts with relevant experience should apply.

I need someone who can simplify a c++ project for me. The project is the openDTU repository on GitHub () . I want just the inverter control functionality without all the web and cloud connection stuff. I want a library where I can add a device and control it on a ESP32 directly without connecting it to the internet.

...for jobs, and managing profiles and portfolios. - Build an admin portal with role-based access for monitoring user activity, managing complaints, and generating reports on job listings and user satisfaction. Preferred Tech Stack: - Front End: TypeScript framework with Server Side Rendering (React.js or Vue.js for web, React Native or Flutter for mobile) - Back End: Utilize GCP services (Cloud SQL, Cloud Functions, etc.) - Payment Gateway: Midtrans Indonesia. This work is going to be divided into 6 major stages, corresponding to 6 milestones: 1. Planning 2. Designing (Software design) 3. Developing 4. Testing 5. Implementation & Integration 6. Maintenance Details upon each stage will be discussed through online meeting If you're passionate about creating innovati...

I need to integrate Tableau with my SQL database, and I'm looking for a skilled freelancer to handle this. Key Responsibilities: - Setup Tableau integration with SQL database - Ensure seamless connection and data flow between the two - Deliver a functional, user-friendly interface for data visualization Ideal Skills: - Strong experience with Tableau and SQL - Excellent understanding of database management and integration - Ability to create interactive dashboards - Proficiency in optimizing data for Tableau visualization This project will require a keen eye for detail and a commitment to delivering a quality, tailored solution.

I looking for a developer which can provide how to create Art brushes in Paperjs. Developer should know: Paperjs,path, compoundpath and segment concept. Problem statement: How to make custom "Art" brushes in Paperjs like Illustrator. Apply these brushes to paths. Success Metrics: Test case 1 1. Create html page with canvas with paperjs. Should able to draw a path using Mouse click and drag or like a pencil. 2. There should be a brush stroke panel and it shuold have a brushes like crayon texture or others. 3. When user click on that path and apply brush stroke on that path(breizer curve). Test Case 2. Create a custom art brush. 1. User can upload an svg of grunged brush or crayon brush pattern in the canvas. 2. Click on that path and add to brush panel. 3. User can adjust brus...

I'm seeking a proficient DevOps developer who can skilfully set up a Linux-based Virtual Private Server (VPS) on Amazon Web Services (AWS). Configuring Nginx is also a key part of this project. and successfully run websocket code written in PHP Your responsibilities will cover: - Configuration of Nginx to ensure optimal performance Given that the expected daily user traffic is low (less than 10K users), the setup should be optimized for this range. Ideal Skills and Experience: - Extensive experience with VPS and Linux - Profound knowledge of Nginx configuration - Experience with handling low-traffic servers - Handling Ratchel web socket is iportent Your expertise in these areas will be invaluable to ensuring the seamless running and maintenance of the server. I am coun...

Adjust code to export Supplier's name

We are looking for code of website in Laravel. If you have, please share the demo link with required login access. Will buy the code. No further work will be required from your side.

I'm currently experiencing some problems with SQL Server 2019 regarding a synchronization error in my Snapshot Replication model. Present issue: - Synchronization process follows an error. Desired solution: - Ability to correct the synchronization errors to allow for smooth data replication. Ideal Skills: - SQL Server 2019 expertise - Solid understanding of Snapshot Replication model - Proven experience in troubleshooting synchronization errors. I'm seeking assistance from someone with these expertise, who can provide a quick and efficient resolution to this problem.

I'm in need of an experienced Vue.js developer to assist with front-end development and implementing dynamic components. The project specifically involves working with Vue 2 and does not require integration with external APIs. Key Responsibilities: - Front-end Development: You'll be tasked with designing and developing the user-facing aspects of the application. - Dynamic Components: Implementing dynamic components to enhance user experience and application functionality. Ideal Skills and Experience: - Proficient in Vue.js: Extensive experience with Vue 2 is a must. - Front-end Expertise: Strong background in front-end development, with a focus on user interface design and development. - Dynamic Component Implementation: Proven experience in implementing dynamic components in V...

I have an existing code written in Joomla and I am looking to convert it into WordPress. The converted website should be mobile responsive. I need an individual who possesses the following skills and experience: - Ability to use LLM conversion tools to convert an existing Joomla web app into WordPress. - Extensive experience in coding and code conversion using Large Language Models. - Capability in creating a mobile responsive design through WordPress. - Strong understanding of both Joomla and WordPress platforms. - Proven track record in delivering similar projects. The completion of this project requires a complete code conversion without any loss of data or function. I expect that you'll be able to leverage AI tools to complete this work expediently and then ...

I am looking for a Magento 2 developer who can help me fix a specific cron job error I've been experiencing. The error states "SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'entity_id' in". Ideal Skills and Experience: - Proven experience with Magento 2 development - Strong understanding of cron jobs and how they work within Magento 2 - Familiarity with debugging and resolving SQL integrity constraint violations Please note that the specific table causing the error was not identified. Your expertise in this area will be crucial. I am using Magento 2.4.6-p4 CE and I get the following error after every order. The job indexer_update_all_views scheduled at 2024-04-15 10:31:03 failed with the following error message: SQLSTATE[23000]: Integrity ...

Hi, I am using library for extracting card image from camera. It works great in portrait mode, however its not working in landscape mode. I need it to be fixed for landscape mode too. If you are able to do it then message me. Thanks!

I'm seeking a talented full stack developer for initial software development for a pathology lab. The software must be responsive, user-friendly, and robust, catering to patients, staff, and referring doctors. Here's what we need: 1. **Choice of Platform**: As the client, I am open to using Angular, React or PHP for the development along with SQL Server/MySQL for the database. Feel free to recommend a platform when you apply. 2. **Essential Modules**: - Building Patient Database (From existing Lab Software - Which will remain as is). This database will be used for Whatsapp , email , SMS Marketing (This also is part of scope) and also For Patient Web App interface. Whatsapp API interfacing will be required for sending and interacting with Patients. - Patient Web A...

...to my SQL Server database. Key Features: - Property Search: Users should be able to search for properties in my database - Property Details: Users should be able to view detailed information about the properties - Favorites List: Users should be able to save properties to a favorites list User Authentication: - The app should allow users to sign in using their Email and Password. Property Search: - The property search feature should integrate a map view for a better user experience. Users should be able to visualize the location of the properties they are interested in. - It should also include the option to save searches, which will be a convenient feature for users who are actively looking for properties. Ideal Skills: - Proficiency in Xamarin development - Experience with ...

I need a developer to create a proctoring exam application using Python and SQL Server. The primary role of this app is to monitor candidate behavior during online exams. Key features include: 1. Online Registration Of Candidates: A feature for students to easily register for exams. 2. Password-Based Authentication: To authenticate candidates before they can access the exams. Prior experience in implementing secure login mechanisms is preferred. 3. Advanced Browser Disablement: Unfortunately, there will be instances when candidates try to cheat the system. I need to prevent this by disabling browsing other tabs, accessing other applications, and the copy-paste function during the exam period. 4. Random Image Capturing & Video Monitoring: To further deter any cheating, the appl...

I'm in the process of preparing a whitepaper that aims to attract investors or partners to our project. In this regard, I'm looking to convert code scripts from my project into text format for inclusion in the whitepaper. Key project details: - I need the code scripts to be converted into a readable and engaging format for potential investors or partners. - The code scripts can be in Python, Java, or JavaScript, however, I'm open to other languages if it can better serve the purpose of the whitepaper. - The primary goal is to clearly communicate the technical aspects of the project in a way that is easily understandable to non-technical readers. - Ideal candidates should have a proven track record of similar projects and be able to provide samples of ...