Sql jobs

This is a JOB SUPPORT ROLE Exp - 7+ years of exp in sql developer specially in Springboot Basic React 5 days in a week Daily 2 hours on zoom call Remote support role You will have to help developer for completing the task Timings - 7 am IST (or evening IST) Payment - You will be paid for those hours while you will be working, You will be informed in advance if there is no work and for those hours you will not be paid. Budget = 500 INR /hr

...installing a SQL Server certificate. I am specifically experiencing the problem of being unable to install the certificate. Error Message: The error message that I am receiving is "The certificate, asymmetric key, or private key file is not valid or does not exist; or you do not have permissions for it." Note: The "" and "" files both exist and have been used successfully before, so my hunch is that this is a possible user permissions problem on a newly installed SQL2019 instance, but it has me stuck. I can provide more details and screen prints upon request. SQL Server Version: I am using SQL Server 2019. Skills and Experience Required: - Strong knowledge and experience with SQL Server certificate installation - Exper...

...project include: - Strong knowledge of data warehousing concepts and principles - Experience with cloud-based data warehousing platforms, such as Amazon Redshift or Google BigQuery - Proficiency in data modeling and designing data warehouse schemas - Understanding of ETL (Extract, Transform, Load) processes and tools - Ability to analyze and integrate data from multiple sources - Familiarity with SQL and other programming languages for data manipulation and analysis The deliverable for this project is a comprehensive report that summarizes the research findings and provides recommendations for implementing a cloud-based data warehouse. The report should include an analysis of different cloud-based data warehouse platforms, their features, advantages, and limitations. It should ...

I am looking for a freelancer to create a database using either MS Acces...be organized. I anticipate needing 1-3 tables in my database. The Database will contain approx 4-6 columns with the option of adding more if required The db should contain a filter and a search option (User friendly) !!! After creating the DB must be filled with already existing data, approx 300-400 pdf-pages, with approx 30-40lines per page. !!! Regarding the huge amount of data a Database an sql e.g. MS Access base would be a better choise Skills and Experience: - Proficiency in MS Access and/or Excel - Experience in database design and development - Ability to understand and implement client's general idea for the database structure - Strong attention to detail to ensure accurate data entry and ...

I am looking for a skilled developer to adapt my current Python application to the web using the Flask framework. However, I would like to use the Django web framework for the adaptation. I want to retain all of the features from the current application in the web version. Ideal Skills and Experience: - Strong experience in Python web dev...framework. However, I would like to use the Django web framework for the adaptation. I want to retain all of the features from the current application in the web version. Ideal Skills and Experience: - Strong experience in Python web development - Proficiency in both Flask and Django frameworks - Knowledge of HTML, CSS, and JavaScript for web development - Familiarity with database systems and SQL - Ability to understand and work with existin...

I am looking for a JAVA developer with experience in Google Cloud Platform (GCP) to join my team. Th...an intermediate level of experience in GCP. I do have a specific deadline for this project, so time management and meeting deadlines are important. Ideal Skills and Experience: - Strong proficiency in JAVA development - Experience with Google Cloud Platform (GCP) - Knowledge of cloud computing and architecture - Familiarity with GCP services such as App Engine, Cloud Storage, and Cloud SQL - Ability to develop new applications from scratch - Strong problem-solving and debugging skills - Excellent communication and collaboration skills If you meet these qualifications and are available to work within a specific deadline, please reach out to me with your experience and ...

...who can assist me with my MS SQL 2008 cursor code. I am currently experiencing unexpected results and need someone with expertise in SQL to help resolve this issue. I have a table with ~400 rows with RGB values. For each record, I want to scan the rest of the rows and find the closest RGB record using the Euclidean Distance - BUT not for the same Brand column. I started a cursor to do this but I don't want to have to execute with hard coded RGB values. Database Environment: - My database environment is local, so the freelancer should be familiar with working in a local database environment. Deadline: - I have a flexible deadline of 1 week or more for the resolution of this issue. Ideal Skills and Experience: - Strong knowledge and experience in MS SQL ...

I am looking for a skilled professional to assist me with specific tasks in SQL Server. The main requirements for this project include accessing and searching a .bak file. Skills and Experience: - Strong knowledge and experience in SQL Server - Proficiency in database design, query optimization, and performance tuning - Familiarity with .bak file management Timeline: - The project does not have a specific deadline, as I am flexible with the timeline. However, I would prefer to have it completed within a month. If you have the necessary skills and experience in SQL Server and are available to work on this project within the specified timeline, please submit your proposal. Thank you.

We are looking for backend developer with solid experience on the following: • server-side rendering • Must be able to use Linux and run automation scripts on it • have a basic background of web security and hardening • have experience using the Shopify API • have experience migrating stores • be skilled with database relations and SQL • have expericen with Sequelize • be able to use Webpack and Babel, and bundle • isomorphic web applications with Express and React API integration skills: • Ability to work with rate limits • Ability to work with webhooks • Ability to secure API endpoints • Ability to run delegate requests and handle requests from the server using API keys • Ability to...

I am looking for a PHP programmer for the development and modification tasks of dashboards, websites, and web applications. I prefer a Keralite for this job since the navigation of some of the dashboards & applications are in Malayalam. Ideal Skills and Experience:- - PHP, Laravel, My Sql - Familiarity with Dashboard development - Experience in creating APIs - Familiarity with Google map integration - Ready to start. More details will be shared with the selected candidates.

I am looking for a skilled Metabase report and dashboard developer who is an expert in SQL queries. Data Analysis: - The project involves analyzing sales data, customer data, and website traffic data using Metabase. Dashboard Creation: - I need a dashboard created on Metabase that will display the analyzed data. Specific Metrics: - I have a list of specific metrics and KPIs that I want to track on the dashboard. Data Updates: - The dashboard should be updated with new data on a daily basis. Ideal Skills and Experience: - Proficiency in Metabase and SQL queries - Experience in creating dashboards and visualizations - Strong analytical skills to analyze and interpret data - Attention to detail to accurately represent the metrics on the dashboard.

Seeking assistance with application development of projects in both C# and VB.NET with or with out Sql server database. The ideal candidate should have experience in developing applications using these programming languages. The projects involve working with databases and may require bug fixes.

We are currently on the seeking a talented and experienced freelance developer with a strong background in Node.js, Microsoft SQL Server (MSSQL), and the QuickBooks Online (QBO) API. Our goal is to create a robust integration that seamlessly syncs data between a our Sales/Invoicing/CRM system and QuickBooks Online. Key Requirements: Proven Experience in Node.js: You should have extensive knowledge and practical experience in developing applications using Node.js. Expertise in MSSQL: Proficiency in working with Microsoft SQL Server is essential. You should be comfortable with designing, querying, and managing databases. Familiarity with QuickBooks Online API: Experience in integrating with the QuickBooks Online API is crucial. You should be able to navigate and implement t...

...well-organized project updates. Provides on-call support for applications if needed. Perform other related duties as assigned. What we seek in you: 8 years of professional full-stack .NET Software development experience. 6 years experience in developing web-based solutions using technologies such as .NET Core and C#. Strong experience with JavaScript, HTML, CSS and Blazor and Razor. Strong knowledge in SQL Server or equivalent development experience RDBMS. Experience with build automation, continuous integration, and source code branching strategies. Experience with TDD and Continuous Integration techniques is required. Experience working on a Scrum or Agile team. Excellent communication and team-building skills....

...few countries we need you to replicate for more different countries, each country will consists about 8 google sheet types and some types may have dozen or up to few hundreds google sheets. Then some of the data needs be transferred and stored to SQL and taken from SQL by API also. This is team work, you will be working with bunch of server guys and python guys. So you need to possess these abilities and criteria : 1. Able to make google sheets fast, make editor for the GS fast and send all of the Google sheets ownership to me. 2. Able to work on SQL and API. 3. Able to collaborate as a team. 4. Agile, fast delivery, and responsive 5. Integrity, Honesty, Independently initiative, responsible, straight forward, loyal, modest, discipline, emphatically fair, hard wor...

Hi All, We are looking for resources who can help us with our client project. Requirement 1:- Experience – 12 + yrs Contractor – Long term Start Date – Immediate Budget - 80k Mandatory Skills – Power BI, SSIS,SSRS, CRM application ( Finance , payment gateway modules ) pref MS Dynamics, good knowledge in Snowflake,SQL Requirement 2:- Role 2: SAP Vertex Consultant Type: Contract; 6+ months Location: Remote Exp: 10+Yrs 5PM to 1AM IST Budget - 80k JD: Roles & Responsibilities: Configure and implement SAP Tax Vertex solution to meet the organization's tax compliance requirements. Collaborate with cross-functional teams to gather tax-related requirements and provide expert guidance on tax solutions. Maintain and enhance tax-related configurations withi...

...Check the SSL certificate of the server Check if the server software is affected by known vulnerabilities Analyze for interesting URLs Check whether a client access file exists, and if it contains a wildcard entry (, ) Discover server configuration problems such as Directory Listing Check if HTTP TRACK/TRACE methods are enabled Crawl website Check for SQL Injection Check for Cross-Site Scripting Check for Local File Inclusion and Remote File Inclusion Check for OS Command Injection Check for ASP Cookieless Cross-Site Scripting Check for Server Side Request Forgery Check for Open Redirect Check for PHP Code Injection Check for JavaScript Code Injection Check for outdated JavaScript libraries Find administrative pages Check for sensitive files (archives

We are looking for a Full-time Data Engineering Experts ( experience 5-15 years) with the following skills and experience: Skills: - Proficiency in Python - Strong knowledge of SQL - Familiarity with Big Data technologies - Snowflake experience is a plus Ideal candidate: - Has experience in building data pipelines - Can efficiently clean and process large datasets - Can create a robust data infrastructure Scope of the project: - Data cleaning and processing

Input: Excel file with a list of strings (full mames) Web for get data based by full name (previous authentication with user and password) Output: In the excel the result of extraction should put in the column B. Using Excel si a sugestión, could be a table un sql server or another way.

* Get SQL Queries Responsible for 8-10 Reports on Oracle * Analyze Queries * Modify Queries to support multiple/suitable reports against different metrics for online Data Visualization Tool/Platform called Databox

...current backend and implement the remaining API endpoints for deposit, wallet, trade, etc. Our backend is developed using Node.js Express and MySQL database. Your task is to develop smart contracts and develop backend api endpoints to integrate with the smart contracts. This is what we have built until now. please work on this 1. Please setup our project environment and database server with the sql file in the db folder. 2. And develop the "Test" token smart contract and deploy it to the testnet. 3. please create a test api endpoint "getbalance" that receive Ethereum wallet address from the request and get the Test token balance of the address and respond it. And then test it using Postman. You make a short video of the full test process to show that you can ...

I am in need of a SQL developer who can assist me with query optimization tasks on a SQL Server database. The ideal candidate should have experience in optimizing SQL queries for improved performance. Specific requirements for the project: - Experience in SQL Server database platform - Strong knowledge of query optimization techniques - Ability to analyze and identify performance bottlenecks - Proficiency in writing efficient SQL queries - Familiarity with indexing strategies and query execution plans The deadline for this project is less than a week, so the candidate should be able to work efficiently and deliver results within the given timeframe.

I am looking for a skilled SQL developer to create a script that will mark certain items as picked up in my database. Here are the details of the project: Specific Condition for Marking Items as Picked Up: - The items will be marked as picked up based on their status in the database. Script Requirements: - The script should be able to identify items with a specific status and update their corresponding field to indicate that they have been picked up. Additional Requirements: - There is no need for the script to mark items as not picked up based on any conditions. - The preferred programming language for the SQL script is SQL Server. Ideal Skills and Experience: - Strong proficiency in SQL Server and database management. - Experience in writing SQL scr...

I am looking for a part-time full stack developer with experience in JavaScript/Python/CSS/HTML5/SQL. Long term contract - UK based ideally, Europe only (would love to meet at least once a quarter if not more.) 20 hours a week on average.

...i'm in Customer1 account, i want to be able to view Customer1's subscriptions, instead of leaving Customer1 account to go to the subscriptions page, then search for Customer1 in the list to find Customer1's subscriptions. 4) I have imported customers list into the db, but the phone numbers are showing as +1.123-456-7890 and i want them to show as 1234567890. this should be fairly easy if you know sql db. 5) when customer registers (create a new account), i don't receive any notifications about it until i log in the cloudonex and check myself, or if the customer tells me about it. also same problem when a ticket is created i think last time i tested it. so is there a way we can setup a notification email sent to staff when someone successfully create an account...

...SUBSCRIPTION PRICE (day, week, month, year, and one free day if I want) NEXT options add!!!!!!!!!!!!!!!!!!!! / add for customers a photo or video gallery (the customer can publish videos and photos (public, private or between friends, or open this private gallery for 5 minutes or 15 OR 30 minutes ((all software and other opensouce) ) no other paid services) JavaScript JS, JavaScript JSON, HTML, CSS, PHP, SQL A version of the software PHP 8;4.x,, MySQL 8.x, MySQL 5.x INSTALLATIONS of the script on the server with the domain. .... .............................................. ...... secures the script against malicious code injection, the script will be checked by admin webmaster clients if compliant coding no error or bad work I refuse ///////////// //////////////// //////// / ....

i need ios and android app there talk with my website and sql database

I am looking for a skilled developer to help me connect my MS Access database to a SQL Server and ensure that any changes made in Access tables are automatically updated in the SQL DB. Multiple users should be able to change the Access tables. Skills and Experience: - Proficiency in MS Access and SQL Server - Experience with database connectivity and synchronization - Knowledge of data transformation techniques (if required)

I am looking for a data analyst with expertise in Power BI, SQL Server, and Excel to assist me with a one-time project. The specific tasks that I need assistance with are data analysis and visualization. Ideal Skills and Experience: - Proficiency in Power BI, SQL Server, and Excel - Strong analytical and problem-solving skills - Experience in data analysis and visualization techniques - Knowledge of SQL server management and Excel data manipulation The project needs to be completed within 1 week, so the ideal candidate should be able to work efficiently and meet tight deadlines. If you have the necessary skills and experience, please reach out to me with your portfolio and relevant work samples.

Role Description: A great opportunity to add to any CV. The aim of this role is to help speed up IT equipment refurbishment to clients, by configuring laptop and desktop machines. The IT Technician will be required to inspect IT equipment, diagnose faults on machines, re-configure and re-image (load any software necessary for user to start working) as well as decom...environment * End-User environment Required Qualifications: * Bachelor's Degree or higher in Information Technology, Computer Science or related field * Industry Professional Certification: A+; N+, MCSE, MCSA, MCP * Fundamentals of Windows Server Infrastructure * Microsoft 2013 (Excel, Outlook, PowerPoint, Word) * Microsoft Windows 8 * MS Security; (user rights, group policies, patch management) * SQL knowledge a...

I am looking for a skilled web developer to crea...should take input of following student details (a) Student Name (b) Course (c) Overall Marks - The above data is to be stored on an SQL database - There should be an output page with the name "Check Student Grading" where on entering the name of the student it should display the Grading of the Student Grading will be as follows 40 to 50 per cent marks Grading is E 50 to 60 per cent marks Grading is C 60 to 70 per cent marks Grading is B 70 to 80 per cent marks Grading is A 80 per cent above marks Grading is D for marks below 40 percent, the grading is F Skills and Experience: - Proficiency in web development languages such as HTML, CSS, SQL database and JavaScript. - Strong design skills to bri...

I am looking for a skilled Visual C# developer to create a data management application with medium complexity. The purpose of the application is to efficiently manage and retrieve data. Skills and Experience: - Proficiency in Visual C# programming - Strong knowledge of database technologies (SQL Server, MySQL) - Experience in designing user interfaces - Familiarity with data management tasks, including relationships between data - Ability to handle medium complexity tasks, such as data entry, retrieval, and implementing relationships between data - Understanding of transactions and concurrency in data management If you have the necessary skills and experience, please submit your proposal.

Seeking a software developer with expertise in Java, Php, Sql for a web development project involving developing a calculator to be embedded in the website. The ideal candidate should have experience in developing web applications using Java pr python and integration of same with database. The purpose of the software is to create a web-based calculator for data analysis. The excel format prototype of the calculator will be provided which needs to be converted into web based app which is capable of storing data, making calculations and allowing the user to download the results in pdf or emailing it. The user need to be verified by email verification link. The project needs to be completed within a timeline of less than 10 days.

I am looking for a Shopify API developer to help me build connection between shopify store and SQL database, right now host our ERP. I am planning to set up a new Shopify store and need assistance with integrating. The specific functionality I need to develop using the Shopify API is inventory upload from local ERP at begining and then order download from shopify to ERP, fulfillment upload. The timeline for this project is flexible. Ideal skills and experience for this job include: - Proficiency in Shopify API and SQL Server integration - Knowledge of inventory management and custom app development on Shopify

Required Skills: • Experienced with and scrum agile methodology • Know how to collaborating closely with Development Teams • Experienced in refinements of test cases with Dev. • Experienced writing and executin...Experienced in refinements of test cases with Dev. • Experienced writing and executing test cases •Experienced creating test data • Solid hands-on experience on Automation - any tool > Selenium - JavaScript, C# > Cypress - JavaScript > Playwright > API with C# • Git commands with CICD pipelines (ADO) - understanding basics of branching strategies • SQL Query experience • Best practices for automation • Challenges they have overcome testing • Best ways to ...

I am seeking a SQL query expert with experience in MySQL for assistance with an advanced level database design project. There are 4 tasks in total. You can solve them in any order. There's no option to pause. Make sure you will not be interrupted for 135 minutes. Your solution(s) should consider all possible corner cases and handle large input efficiently. If you accidentally close your browser, use the invitation link to get back to your test. Assessment and hiring policies: For testing purposes, we'd consider using copied code, code from opensource websites, Generative AI (GAI) responses, or anything but your own code, as not meeting the requirements of this test. We are hoping to see how you create your own code, and your unique approach to the challenges set. Respon...

I want help in teaching my child C#, .Net, Web Apis, Javascript, Jquery, React, Sql Server. My child already understands all the programming concept. Just need a refresh of all the concepts again then continue with the project for example Quiz App, Blog App, etc

Responsibilities: Should have strong knowledge of Node.js and frameworks Hands-on experience with JS, ES6, Node.js, , MongoDB, Building REST APIs and Graphql, Restify Strong experience with MongoDB Experience in Integration with data storage solutions [RDBMS, No SQL DB] Experience working with WebSockets is a plus Experience working with Redis and its various applications like task queues etc Should have experience and knowledge of scaling, data protection, and security considerations Good understanding of revision control tools, such as GitHub, JIRA Practical knowledge of Git/Bootstrap/Grunt/Babel/Webpack In-depth understanding of the entire web development process (Design, Development, and Deployment) Understanding of AWS Services – EC2, S3, Cloud front, SES, Code Deploymen...

I have a python procedure which needs to be written in sql compatible to run in snowflake environment. All the tables in procedure should be called explicitly.

I am looking for a freelancer who can help me deploy my website on Azure cloud. The website I have is a faculty management system in a university. Specific Requirements: - I have specific requirements for deploying my website on Azure. Primary Function: - The prima...Specific Requirements: - I have specific requirements for deploying my website on Azure. Primary Function: - The primary function I want my deployed website to perform on Azure is data storage and management, web app services, email and communication services. Ideal Skills and Experience: - Experience in deploying websites on Azure cloud - Proficiency in Azure virtual machines, functions, SQL, and storage the above link is the github link which is to be deployed

...background in software development, informatics or similar You have gained relevant experience in software development (frontend, backend or fullstack); eCommerce and start-up background is a plus You feel comfortable in the frontend technologies (VueJS preferable) and e-commerce development (Shopware 6 preferable). You also provide strong full stack skills (PHP preferable) and you have expertise in SQL You are experienced with e-commerce and heterogeneous system integration You must have an eager-to-learn attitude and a growth mindset, which drives you to embrace new challenges and seek continuous improvement You describe yourself as analytical as well as proactive and self-responsible You are business fluent in English. German language skills are a plus What We Offer He...

I have a Powerbuilder application where I need to print data from my database into an employee ID card both front and back. I need help to achieve this. I'm using Powerbuilder 12.6 and SQL Anywhere 16.

I am looking f...in the Azure cloud. I have no experience with Azure cloud services, so I need someone who is familiar with the platform. The ideal candidate should have experience with the following: - Deploying PHP projects in Azure cloud - Working with VM instances, cloud storage, SQL Database, and cloud functions - Using the Azure Portal to access cloud storage This project involves deploying a PHP project consisting of 10-50 files in the Azure cloud. The developer will need to set up VM instances, configure cloud storage, and integrate SQL Database and cloud functions. The preferred method for accessing cloud storage is through the Azure Portal. If you have experience with Azure cloud services and are confident in deploying PHP projects in the cloud, please reach out ...

We currently possess an in-house Java/J2EE application dedicated to performing technical analysis on the US Stock Market, utilizing the latest trading data. The application has been developed using J2EE technologies such as Spring JPA, Spring JDBC, REST Web Services, Java Streams, Lambda expressions, Spring Boot, Sw...Security Protocols: Good experience with Spring Security-based authentication and authorization protocols. 2. Cloud Technology: Knowledge and hands-on experience working on AWS technologies and services, integrating them with the Java application. 3. Charting Libraries: Familiarity with front-end charting libraries like in both Angular and React. 4. Database Querying: Good knowledge of SQL queries, especially using Oracle databases. Project Duration: 6 to 12 month...

Hi There, I have REST API and I need to import the data into a Azure SQL Server table. I am using Azure Data Factory Data flow (attached) which was working fine but as the data grew I started getting the below error Azure data factory REST API Job aborted due to stage failure: Serialized task 16:0 was bytes, which exceeds max allowed: (134217728 bytes). So I had to split the source API data into two parts using $top and $skip Like below, two URL calls. abc?$expand=xx,yy,zz&$top=40000&$skip=0 abc?$expand=xx,yy,zz&$top=40000&$skip=40000 I am looking for efficient way of doing it by using for loop or parametrization or anything which makes it work even if the data further grows. Example API data : $expand=Trips

...data AI-Driven Testing: Conducting exhaustive testing, leveraging AI, to guarantee the system's adaptability and reliability across diverse scenarios. Integration: I am unsure if the software needs to integrate with an existing system. The developer should be able to assess the requirements and suggest the best approach for integration if necessary. Currently our database is SQL server which already has Ideal Skills and Experience: - Strong programming skills in languages such as Python, Java, or C++ - Experience in developing AI or machine learning algorithms - Familiarity with invoice processing and data analysis - Ability to work independently and deliver high-quality results within the given timeframe. If you have the required skills and experience, please submit

I am looking for a developer to create a webpage that will allow me to save images and videos from iPa...for a developer to create a webpage that will allow me to save images and videos from iPads. The main purpose of this webpage is to take pictures and videos of products and save them to an SQL database before shipping. Features and functionalities for this webpage are open to suggestions, so I am looking for a developer who can provide innovative ideas and solutions. The webpage should be compatible with all major browsers, ensuring easy access for users. Ideal Skills and Experience: - Experience in web development and database management - Knowledge of HTML, CSS, and JavaScript - Familiarity with SQL databases - Strong problem-solving skills and ability to provide c...

I am looking for a freelancer who can help me deploy my small (less than 1GB) PHP project in Azure using VM instances, SQL database, cloud functions, and cloud storage. I require the latest version of PHP to be used for this project. Additionally, I need assistance in setting up the SQL database and cloud functions, including a full setup. Ideal skills and experience for this job include: - Experience deploying PHP projects in Azure using VM instances, SQL database, cloud functions, and cloud storage - Proficiency in the latest version of PHP - Knowledge of SQL database setup and configuration - Experience with cloud functions and cloud storage setup Please provide examples of similar projects you have completed in the past.

The lifetime value (LTV) of users are accounted by the revenue they generate over their lifetime after they have installed. The data you has the revenue events for each user up until the first 14 days after...the revenue events from the 14th day until the lifetime after the install for each user are removed on purpose. Form a regression function using ARPI values to estimate the average lifetime value (LTV). Skills and Experience Needed: - Proficiency in data analysis, - Visualization - Recommendation Writing - Regression Analysis - Data Modeling - Time Series Analysis - Google Sheet Skills - Writing SQL queries to combine datasets and generate a summary table. - Calculating metrics such as ARPI_D1, ARPI_D14, ROAS_D14, and CPI. Preferred Tools and Software: - Python - Jupyter - Go...

I am looking for a freelancer who can provide assistance with my Python project. The specific area of Python that I need help with is web development. Skills and Experience: - Strong understanding of programming concepts in Python - Experience in web development using Python frameworks such as Django or Flask - Knowledge of HTML, CSS, and JavaScript - Familiarity with databases and SQL - Ability to create and integrate APIs - Experience in deploying web applications Ideal freelancer should include the following in their application: - Past work examples showcasing their experience in Python web development - Detailed project proposals outlining their approach and timeline for completing the project I have an urgent deadline for this project and need it completed as soon as possi...