Sql server return codes jobs
As the developer of an existing project written 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...
We need a report which works like that: We upload a list of EAN Codes to system. System give us back: - EAN - ASIN - BuyBox Price - Who is a seller - Sells in 30, 60 90 days All data from Amazon helping with our JungleScout
As a business user, I need assistance with the configuration of SSRS Reporting Service on a staging environment. I have configured the 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 ...
... 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...
Update Wordpress Child theme to work with latest version of X-Pro theme and PHP 8.2 First I would like you to estimate the work using the WPEngine credentials I supplied. Environment is: volleyball2stg From the ticket: I have tried again to update the staging site ...the WooCommerce collapsing categories pro plugin. I am not sure if this plugin is still maintained for the only review that it had was way back 2016. The last post on their twitter account is way back in 2021. This plugin needs to be updated to match the requirements of PHP 8.2 before we can update the PHP version on the server. - update: I already have updated the plugin codes to match the requirements of PHP 8.2 and was able to update the PHP version on the staging server to the latest one.
I have an existing small ...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, with specific expertise in carport design. The ideal candidate will also have experience working with wood and windows...
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...
...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 too...
Hi Yasar W., I noticed you posted a following project ( https://www.freelancer.com/projects/sql/SQL-Expert-Needed-for-Data/details )
...Key Responsibilities: - Designing a modern residential structure that aligns with the provided blueprints and specifications - Incorporating innovative and contemporary architectural techniques in line with modern design trends - Ensuring that the construction project adheres to all necessary building codes and regulations Ideal Candidate: - Proven experience in designing and overseeing new construction projects - Proficiency in modern architectural design - Strong knowledge of building codes and regulations - Excellent communication skills to effectively collaborate with contractors and other stakeholders Please provide a portfolio showcasing your previous residential projects, particularly those with a modern architectural style. It would be a huge plus if you have exp...
I need an expert to design a DICOM database specifically for storing and retrieving radiology images. Key requirements are: - Comprehensive understanding of DICOM Standards - Proficiency in database design and administration - Experience in handling medical images, particularly radiology The proposed database should support retrieval of images via Unique Identifier Codes (DICOM's UID). Being well-versed in medical systems integration will be considered a great advantage. This project will require strict adherence to privacy regulations and standards.
I need a script to automate server updates. It should be able to handle operating system updates, software updates, and security patches. Key Requirements: - The script should be able to automate server updates - It needs to handle operating system updates, software updates, and security patches Ideal Skills: - Proficiency in scripting languages - Experience with server management and updates - Understanding of cybersecurity and best practices - Strong problem-solving skills and attention to detail.
I'm looking for an experienced programmer to develop a custom trading algorithm in Trading View using Pine Script. I already have the source codes for all the indicators I want to include, so your primary task will be to integrate them into a comprehensive and effective trading algorithm. Key Requirements: - Previous experience with trading algorithm development in Trading View using Pine Script is crucial. - Ability to integrate multiple indicators and create a robust algorithm. - Comprehensive understanding of trading strategies and indicators. - Strong analytical and problem-solving skills. - Familiarity with financial markets and trading platforms. Please note that this algorithm is intended for personal use and to be shared with my friends and family, so it needs to be ...
I'm seeking a highly skilled system administrator capable of installing CloudLinux with LVE and cPanel support on my server. - Purpose: The key goal behind this project is to optimize resource allocation for my server. I intend to host multiple websites on this server, making resource optimization crucial to seamless performance. - Websites: The server will host a diverse range of websites including e-commerce, blogging, and corporate websites. - Volume: The server should comfortably accommodate between 10 to 50 websites simultaneously. The ideal candidate for this project should have strong CloudLinux and cPanel working knowledge. An in-depth understanding of server management, specifically for resource management in high-traffic env...
...popping up and the sheet becomes protected every time I enter a price. Ideally, instead of locking the entire sheet, only specific columns should be locked when a password is triggered by clicking a button. Key issues: - Error message arising upon entering a price - Automatic sheet protection following action Work Required: - Identify and fix the error triggering the message pop-up - Adjust VBA codes to lock specific columns upon password entry: - Columns A to L - Columns Y, Z to AK - Columns CW to DH - Columns DO to DS - Columns DT, DV, DX, DZ, EB, ED For this task, I need a freelancer proficient in VBA and Excel, specifically with experience with sheet protection issues. A thorough understanding of Excel functions and spreadsheet error troubleshooting is also req...
...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 am seeking a knowledgeable AWS specialist to provide server support including the maintenance of an Application Load Balancer. The project also uses Git CD/CI, and support on GIt is required as well. Ideal freelancer skills and experience: - Deep knowledge of AWS services, particularly EC2 and RDS - Experience in setting up and managing Application Load Balancer - Familiarity with Git & CD/CI To make a successful application, please include: - Details of past work experience particularly related to AWS EC2, RDS and load balancer configurations. Looking forward to your applications.
I'm seeking an experienced residential architect to help with a single-family home project. Key Services: - Conceptual Design and Planning: Your role...who can also assist with the interior design and layout of the home, ensuring a seamless and functional design throughout. Ideal skills and experience: - Proven experience in residential design, particularly single-family homes. - Proficiency in architectural software. - Strong design and spatial planning skills. - Prior experience in interior design is a plus. - A good understanding of building codes and regulations. Please provide samples of your previous residential design projects when applying for this job. Your design philosophy, creativity, and ability to balance functionality and aesthetics will be important factors ...
We need a report which works like that: We upload a list of EAN Codes to system. System give us back: - EAN - ASIN - BuyBox Price - Who is a seller - Sells in 30, 60 90 days
I'm in need of a competent AI developer who can build an innovative mobile application that integrates Artificial Intelligence. The main tasks of this AI system include: 1. Scanning Grocery Receipts: - Should be able to read QR codes, UPC codes, EAN codes efficiently. 2. Organizing Food Items: - The app should be able to filter food items only and categorize each into either fridge, freezer or pantry based on the information obtained from the barcodes. 3. Estimating Expiration Dates: - Application is to estimate expiration dates of food items based on the day they were bought as well as correlating with the expiry dates of similar items previously scanned. Ideal freelancer should have comprehensive knowledge in AI, mobile application de...
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.
...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 criteria is small. If I pass filter for say 50 GUIDS then this query does not return any reco...
I'm looking for a professional programmer, proficient in Python to craft a script. This script is for the main purpose of finding mobile numbers, identifying their carrier, and matching this information with corresponding zip codes. This process is vital for my verification purposes. Not only this, but your script must provide these details in a CSV file output format. Key requirements are: - Extensive knowledge and experience in Python - Experience in number location and carrier identification script writing is a plus - Knowledge of data presentation in CSV format This task requires high attention to detail and a strong understanding of number location matching technology. If you meet this description, I'm excited to hear from you.
...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...
Are you a Vesta Panel expert? Ok Then help me upload a simple 1-page WordPress site to my server & connect to the domain name Hosting is Digital Ocean with Vesta Panel
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 sourc...
I'm looking for an experienced cloud engineer who can resolve a server downtime issue I'm experiencing with my OVH Public Cloud. Key Responsibilities: - Analyze and troubleshoot the root cause downtime - Implement a robust solution to prevent future occurrences - Ensure that during downtime, website and database access functionality is restored promptly Ideal Skills and Experience: - Proven expertise in OVH Public Cloud management - Strong troubleshooting and problem-solving skills - Understanding of website and database access best practices - Excellent communication and teamwork abilities I'm open to suggestions on how we can best approach and solve this issue, so if you have ideas, I'd love to hear them.
...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 ...
...current developers have answered the below questions (their responses are in Yellow) 1. What are the current versions of software being used? OpenCart, PHP, MySQL etc in the various systems used?  Opencart V1.52 PHP Version 5.6.40 (any other newer version won’t be supported by the platform) MySQL - 10.4.28-MariaDB Laravel V5 … custom interface Active cron jobs running   2. What is the server spec & software versions? RAM, CPU, disk space etc. Full Software list here:  https://xxxxxxxxx/ We run a dedicated machine and resources can be allocated on demand… as minimal requirements: 4Gb RAM, OctaCore 3.2Gb CPU, 100Gb space (bkp included)   3. Any APIs integrated & Any Data grabs between and other 3rd parties including any internal ...
...and complementing the overall look of the house. - Assisting in the selection of appropriate, cost-effective, and durable brick materials for the porch construction. - Ensuring the design meets local building codes and regulations as it will be used for a planning permission application. Skills & Experience needed: - Proven experience in architectural design, particularly traditional-style buildings. - Extensive knowledge of construction materials, specifically brick. - Familiarity with creation of building plans for planning permission. - Strong understanding of local building codes and regulations. Your role in this project is crucial to both increasing the functionality of the space and enhancing the aesthetic of the home. If you believe you'd be a great f...
I am seeking an experienced IPTV app developer to rebrand an application similar to smarters pro. It's crucial for the rebranded app to support Android platform. the app must be working by activation codes instead of username and password with panel management dns if possible
I need an expert in architectural design and drafting, with a specialization in industrial building code compliance, to devise a...the necessary building permits 2. Ensuring total adherence to safety regulations The project's focus will mainly regard fire safety regulations, with a priority on mapping out proper evacuation routes and exits. This task requires an in-depth understanding of safety norms and passionate dedication to establish a secure environment. Ideal skills include: - Extensive experience with industrial codes - Expertise in architectural safety plans - A thorough understanding of fire safety regulations - Proficiency in drafting evacuation maps. Your role is to ensure a swift permit acquisition process and the creation of a safe, regulatory-compliant indus...
I'm in need of someone who can create a small college project based on blockchain technology. I'll provide the codes and other stuffs required. The person just needs to debug some errors and do some front end and back end work. Key Requirements: - Capable of using Remix, CSS, and Java Script for the project. - Understanding of blockchain fundamentals, including user authentication, data encryption, and smart contracts. Please feel free to share your past work and experience related to blockchain, along with any detailed project proposals you might have.
I require an expert electrician to assist me with wiring installations in both new construction and existing structures. Key Responsibilities: - Installation of wiring in residential settings - Ensure adherence to electrical codes and standards - Identify and resolve electrical problems Ideal Skills and Experience: - Proven experience with residential wiring - Excellent understanding of electrical codes and regulations - Ability to troubleshoot and resolve electrical issues efficiently - Strong communication and problem-solving skills Please note that I'm looking for a professional who can consistently deliver high-quality work.
...clients - Income tax return filing - Coordinating with clients on monthly basis for the documents The majority of my clients have less than 70 transactions per month and I use tally software, thus a good grasp of tally software and excel is necessary to handle the above tasks. - Skills and Experience: - Gst return filing experience - Proficient in tally software - Experience with handling multiple clients simultaneously - Knowledge of GST and TDS filing systems appeciated. This is an ongoing project and I am looking for a dedicated and reliable partner in this area as this will be an ongoing and long term project. The fee rates are as follows non negotiable and will be as follows and will increase the rates on an yearly basis at the rate of 8-10%. Gst ...
Your job is to develop a RESTful API only, no website, no UI of any kind. The API would work something like GET After called, the API will return a JSON response that contains all the data from sample reports. In other words, this API would perform a similar AI based analysis of the given website URL and produce a JSON format response of that. The website is provided here as a sample of the report to produce, we are NOT using its API. In your bid, please specify what third party libraries and/or APIs you would use, such as what APIs from Huggingface, RapidAPI etc. I want this to be developed with PHP and/or Python. Pure PHP solution would be preferred
For this crucial project, I’m searching for a seasoned AWS developer experienced in setting up advanced server security. Key Responsibilities: - As I've got an EC2 server in place, I am seeking to fortify the security measures associated with it. - Although I've not finalized the specific measures, your expertise and suggestions in IAM, Security Groups, or Network Access Control Lists (NACLs) would be greatly appreciated. - Emphasis on ‘Advanced Security Setup’ – a step beyond basic security – to comprehensively protect server's integrity. Ideal Skills: - Proven experience in AWS server security, specifically EC2. - Proficiency with IAM, Security Groups, NACLs. - In-depth AWS server security acumen. I'm exci...
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.
I'm looking for a proficient developer capable of creating a customized web crawler for eBay and AliExpress. The primary function for this crawler will be to accept a list of keywords of any length and return specific data about those products. Here's what I need in detail: • Find top hot selling products at any given time • Crawl eBay and AliExpress for specific product data based on entered keywords. • The data retrieved should include product names, quantities sold and locations of sellers, images, • The crawler should be capable of providing this information for a variable timescale, ranging from 1 to 30 days in the past. • The results should be sortable. Php or python preferably The task would best suit a freelancer with previous exp...
...calculate the hourly rate and the time needed to complete different task documents, on an agreed fixed price. The best offers with the right experience will have the opportunity to work with us on a long-term basis. Also, Good prospects for the right developers, based on the performances evaluated over a period of time, once you established your skills. Need to provide the changed code details and sql queries if any at the end of each sub-task, with the changed code line numbers. Unlimited Revisions are needed. Any bugs created due to your own developments are to be fixed on free of Charge. Recruitment is for a long-term big project as such, all the developers are subject to practical skill test for which not paid. Please send your details for the below-mentioned questions....
...focus would be: This is a two part job. I want to know a price for two separate jobs: 1. I have three websites and I need to know what their seo keywords are, and what their ppc ads are. I also need the monthly search volume, and google spot they rank for. 2. After you have the SEO and PPC keywords available, once I receive this list, I will then condense it and give you approx. 30 keywords in return that I need to know CPC for. Skills and Experience: The ideal candidate should possess comprehensive knowledge and experience in SEO, PPC, and competitor analysis. An understanding of industry trends would be an added advantage. I would highly appreciate bids from those who are familiar with tools and techniques in data analysis, keyword rankings and competitor assessment. The...
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...
Language C# .NET 8 Create a Blazor (or ASP CORE) application that hosts a razor page. Create a second console application. These applications should communicate using SignalR. When a client application connects (there could be several at a time), those connections are listed on the RAZOR page. this razor page shou...application. These applications should communicate using SignalR. When a client application connects (there could be several at a time), those connections are listed on the RAZOR page. this razor page should use radzen blazor for a framework. On disconnect, they should be removed from the list. When a user clicks on a specific agent connections, the razor page will send a command to that agent ONLY to return the current windows user (communication through the asp core ...
