SQL Jobs

Stepping Back Through Data I have a table of orders, lets say. I'm trying to find all the "Completed" orders, and then step back through other "Cancelled" orders for the same Customer, that were created within 72 hours. The trick is, I want to keep stepping back until I don't find anymore orders (the 72 hour window will now be based on the last order found). Also, the logic should stop if it finds another "Completed" order for the same customer. I've included a test table and data, as well as an expected output. CREATE TABLE #Order ( OrderID int, CustomerID int, OrderDate datetime, OrderStatus varchar(25) ) INSERT INTO #Order VALUES (1, 1, '02/15/2024 07:00 AM', 'Cancelled') INSERT...

I need a talented SQL developer to create a stored procedure that will automate the process of marking certain items as 'picked up' in our Microsoft SQL Server database. This script should essentially replicate the functionality of our existing Windows application, performing the necessary changes in the database to reflect this status. Key Requirements: - Strong command of SQL and experience in Microsoft SQL Server is essential. - Familiarity with Windows application development is a plus, as this script should mirror the behavior of our existing front-end tool. - Previous experience in creating SQL stored procedures for automating database actions is highly preferred. - Attention to detail and the ability to trace SQL commands accurately is crucial. Access & Support: - I ...

I am using QuickBooks Enterprise and wish to connect it with QuickBooks Connector but need guidance. - Expertise Needed: 1. Knowledge of QuickBooks Desktop, particularly the Enterprise version. 2. Experience with QuickBooks Connector. 3. Familiarity with connecting QuickBooks Desktop with QuickBooks Connector. - Responsibilities: The freelancer should provide step-by-step assistance on how to establish the connection. - Desired Information in Applications: Despite not providing specific details, I appreciate applications with comprehensive experience overviews, along with a detailed proposal outlining how you plan to complete this task. Mention similar projects you've worked on in the past as well. Looking forward to your help!

We've developed an MS Access database front end with a SQL Server back end. Now we need to install both of these with government agencies in South America whose IT people only speak Spanish. We provide written installation instructions in English. Our clients can only meet the contractor online for server installations during business hours in American time zones. This is periodic work, installing databases whenever clients request them. At present we have six clients in the queue. The applicant must guide and troubleshoot each installation online in fluent Spanish. The successful applicant will have a record of relevant database work. We're a university-based not-for-profit.

I'm on the hunt for a skilled Data Analyst who will work closely with our customer data, primarily formatted in Excel/CSV. The primary goal of this analysis is to identify trends and patterns that could aid our business processes. Key Responsibilities: - Deep analysis of customer data to identify patterns and trends - Create visually engaging and understandable reports Ideal Skills and Experience: - Proven track record as a Data Analyst - Comprehensive understanding of data analysis methodologies - Superior skills in Excel/CSV data processing - Ability to present complex information in an engaging and understandable manner. Your contribution will hugely impact our business decisions. I look forward to viewing your proposals. Please include samples of your previous data analysis...

Tengo un ERP desarrollado en Vbasic 6.0, necesito un desarrollo complementario que permita tomar el xml generado por el ERP y que termine el proceso. Ademas necesito que la aplicacion pueda ser accesada por un movil android y generar Guias de Despacho, las cuales deben llegar al ERP con base de datos en MYSQL

I am seeking a skilled .NET developer to create a Windows application with the following features: - User Authentication and Authorization: The application should ensure secure user access and have roles-based permissions. - Database Integration and Management: Experience with handling complex data and ensuring its security is essential. - API Integration: The application needs to communicate with external systems through APIs. My primary concern is scalability. The application must be designed to grow and handle an increasing number of users without compromising performance. Hence, I am looking for a developer who can plan and implement a scalable architecture from the very beginning. The ideal candidate should have: - Proficiency in .NET framework, particularly for Windows application...

Tengo un Insert que proviene de una tabla que esta consumiendo mucho CPU al momento de ejecutarse, es un SP simple pero requiere de índices o validar que los que ya están creados no estén causando conflicto y aumenten el consumo del CPU

Se debe mantener un sistema hecho en .Net el cual esta vinculado a una base de datos SQL Server de Microsoft. El postulante debe manejar a la perfeccion el idioma Español.

I am in need of a freelance MIS Executive with strong skills in data analysis and database management. Responsibilities: - Conducting detailed data analysis using the provided tools - Proficiently manage and maintain a database Ideal Candidate: - Proficient in Microsoft Excel and SQL Server - Experience in database management and data analysis - Strong analytical skills - Excellent attention to detail This project requires someone who can work independently, has a good eye for detail, and can deliver high-quality results. A background in MIS or similar field would be a big plus.

I am looking for a talented and experienced web development team to create a unique, fully functional social media platform. Key Features: - User Profiles: A robust user profile system that allows users to create and customize their profiles. - Messaging System: A secure and interactive messaging feature that enables users to communicate seamlessly. Ideal Skills and Experience: - Proven experience in developing and deploying web applications, preferably in the social media domain. - Proficiency in programming languages and frameworks suitable for developing a dynamic web application. - Strong understanding and implementation of user experience and interface design. - Ability to create scalable, secure, and maintainable code. - Excellent teamwork and communication skills, as this project ...

I need a Python code to perform data analysis on text data sourced from tables. This project emphasizes the importance of being highly familiar with Python and its data analysis and text processing libraries. Key tasks: - Extract text data from tables - Perform comprehensive text data analysis Ideal skills: - Proficient in Python - Extensive experience with data analysis and text processing libraries - Familiarity with table data extraction - Strong understanding of text data analysis techniques and methodologies. I look forward to hearing from experts in Python data analysis. This is a chance to demonstrate your ability to solve complex data processes.

I'm on the hunt for a skilled Data Analyst who will work closely with our customer data, primarily formatted in Excel/CSV. The primary goal of this analysis is to identify trends and patterns that could aid our business processes. Key Responsibilities: - Deep analysis of customer data to identify patterns and trends - Create visually engaging and understandable reports Ideal Skills and Experience: - Proven track record as a Data Analyst - Comprehensive understanding of data analysis methodologies - Superior skills in Excel/CSV data processing - Ability to present complex information in an engaging and understandable manner. Your contribution will hugely impact our business decisions. I look forward to viewing your proposals. Please include samples of your previous data analysis...

I'm looking for an experienced .NET developer to assist with a project. This project requires someone who has a strong background in .NET technology, particularly in C# programming, ASP.NET development, and SQL database management. Ideal candidates should have experience in developing web applications, creating software solutions, and improving existing systems. The key functionalities to be implemented by the .NET developer in this project include user authentication, data encryption, and payment integration. If you're a .NET developer with a solid understanding of the above technologies and functionalities, please reach out to discuss the project further.

I want to develop a website similar to and https://www.abasteo.mx. The goal is to automate daily updates of the website's database. Key Requirements: - Daily database updates: The website should automatically update its database every day. - Products and prices: The database should include technology products, such as electronics and computer hardware. - Design and layout: The website should be visually appealing and user-friendly. - Database type: The database can be either SQL or MySQL. Ideal Skills: - Proficiency in SQL or MySQL - Experience in e-commerce website development - Strong understanding of front-end design - Ability to automate database updates - Expertise in handling technology products Your proposal should include: - Your experience in similar projects - Your appro...

I'm seeking a proficient developer to construct a robust, elegant and classic eCommerce website on Shopify. The website should comfortably accommodate a product catalog of over 4000 products. Key Features Required: - A comprehensive product catalog that is easy to navigate. - Seamless shopping cart functionality. - A secure, reliable and user-friendly payment gateway. Preferred candidate should have extensive experience in developing high-performing eCommerce websites on Shopify, have a keen eye for classic design aesthetics, and a proven track record of integrating large product catalogs, shopping cart and payment gateways. Experts in User Experience (UX) and User Interface (UI) are highly desirable. Quick turnaround without compromising quality is a must.

Looking for a skilled developer to fill in for a team member on vacation. The ideal candidate should have: - Strong experience in C# and ASP.net - Good knowledge of SQL Server The role involves: - Troubleshooting and fixing bugs in our existing applications - Enhancing and adding new features to our applications The projected timeframe for this position is less than a month, but the role could potentially be extended. You're being hired for not only your skills but also your problem-solving abilities - an essential trait when dealing with application bugs/issues. The key objectives for this role are: - Improving the performance and stability of our applications - Enhancing the user experience and application functionality Note: We skipped the outcome due to the job's short-term ...

Somos una empresa de desarrollo de Software de producto propio () y estamos buscando perfiles para reforzar de manera remota nuestra capacidad de desarrollo. 1. PERFILES BUSCADOS: En este momento estamos interesados en perfiles JAVA2EE con experiencia demostrada y excluyente en: a- Trabajo en equipo colaborativo, español nativo. b - JAVA2EE con experiencia superior a 2 años c- Conocimientos en programación Java Swing d- Experiencia en programación previa demostrable de al menos 1 año en programas de gestión tipo ERP, SGA, POS, CRM, facturación, contabilidad, etc. e- Entorno de trabajo sobre GITHUB, JIRA, ECLIPSE f- Conocimientos de programación SQL sólidos 2.- CERT...

I'm seeking an experienced Azure Data Engineer to step in and effectively collaborate with my remote team. Given the lack of a specific task or main goal, your expertise, adaptiveness, and versatility will come in handy. Key responsibilities may likely include: - • Ideal candidates should have strong experience with Azure Databricks and Data factory. • Conducting data analysis - Data integration - Data processing - Possibly executing ETL processes - Maybe venturing into data modelling, optimization, and pipeline development. • Efficient communication and collaboration capabilities are needed for this remote role. • I look forward to working with an adaptable professional who can confidently handle diverse tasks in Azure data engineering. • Design, deve...

I'm in need of a comprehensive business owner database specifically in Tamilnadu, Chennai. The database should include detailed information of business owners Contact number, Email ID from various industries like GST Filling Database, Distributors, Industries, Dealership and more

As a client, I am looking for a professional and experienced full stack developer with a strong background in to build a new microservices architecture from scratch. The project will involve the following key components: - User Authentication and Authorization: The microservices should have robust user authentication and authorization functionalities to ensure data security and privacy. - Real-time Communication with WebSockets: The developer should be able to implement real-time communication using WebSockets, allowing for instant updates and notifications. - Integration with Third-party APIs: The microservices need to seamlessly integrate with various third-party APIs, ensuring smooth data exchange and interoperability with external systems. The ideal candidate should have: - Extensiv...

I'm in need of an Oracle expert with extensive knowledge in Exadata infrastructure. Coming into this project without any experience in the field, I am eagerly searching for someone who can guide me and transfer their knowledge, so I can gain a deeper understanding. - SKILLS REQUIRED: Extensive experience in Oracle Exadata Infrastructure, excellent communication skills, teaching/mentoring experience would be a bonus. - EXPECTED OUTCOMES: Teaching me the technicalities of Oracle Exadata Infrastructure, and making me feel at ease with managing and understanding this field. Specific topics to be covered would be discussed in further detail with the chosen freelancer. Ideally, these would cover resource management, operational tasks and data warehousing, but I am open to learning abou...

I'm seeking an experienced Google Script specialist to automate tasks and manage data for my project. Here are the specifics: Automating tasks: Your main responsibility will be to automate data import/export processes using Google Script. I need to take the data attahed to a daily email in excel format, upload this data (and historic) to a data base and then allow to consult that data from different spreadsheet in google with a query. Ideal skills and experience include: - Proficiency in Google Scripts and automation - Experience in data management - Google spreadsheet analisis reports If you have the needed expertise, I'm excited to work with you!

I'm in need of a skilled .NET developer to create a functional web application that mainly handles user registration, login, and database management. Key Requirements: - User Registration and Login: The application should have a robust system for users to sign up, log in, and manage their accounts securely. - Database Management: Proficient database management within the application is a must. This includes data storage, retrieval, and manipulation. Additional Information: - External Integrations: There is a possibility that additional integrations may be required in the future. Experience with integrating external systems and APIs would be beneficial. - User Roles and Permissions: The application may need to support multiple user roles and permissions. While this is currently marke...

I'm looking for a skilled MS Access developer to create a billing and accounting database with a modern, minimalist interface. Key Requirements: - Customizable Reporting: The system should be able to generate a variety of reports on different aspects of the business, such as sales, expenses, and profit margins. These reports should be adaptable for future needs and allow for different levels of detail. - Integration with Existing Systems: The database will need to interact seamlessly with other existing systems and software used by the company, ensuring data consistency and accuracy. - User Permissions and Access Control: The system should have a robust user management system that allows for different access levels and permissions. This will ensure that sensitive financial informatio...

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

We are currently facing an urgent requirement for the implementation of Oracle SCM/demand planning modules. We are in search of SCP experts or IT consultancy partner companies with proven experience in SCM/demand planning module implementation in Oracle EBS R12. The scope of work will cover the following aspects within Oracle SCM EB R12: Predictive Analysis based on MRP Demand forecasting for peak and off seasons Demand Sensing Multi-Dimensional Analysis: Analyze demand by product, customer, region, channel, and other relevant dimensions for deeper insights and better decision-making Supply chain integration Forecast accuracy tracking Reporting and Analytics

Abstract: This white paper presents the concept of a secure iPhone application designed to assist users in organizing their financial life. The application allows users to allocate a specific amount of money, which is then distributed on a daily basis. The application charges a 4% fee for facilitating these transactions. This white paper provides an in-depth understanding of the application's architecture, functionality, and its potential impact on the community. It also highlights the importance of security measures to protect user data and ensure the integrity of financial transactions. 1. Introduction: The purpose of this white paper is to introduce a secure iPhone application that aims to empower users in managing their financial life. By providing a platform for organizing a...

Arabic & English marketplace e-commerce on both website and mobile Strengths: Clear identification of technologies used (Widgets, JavaScript frameworks, Font scripts, Miscellaneous, Web servers, Programming languages, CDN, Maps, Development, Live chat, JavaScript libraries, UI frameworks). Potential use of Module Federation (50% sure) and Webpack (50% sure). Areas for Improvement: Technology Modernization: Consider upgrading libraries (jQuery, jQuery UI, Modernizr, Slick) to their latest versions or exploring modern alternatives (React, Angular, Vue.js) for better performance and maintainability. Component-Based Architecture: Refactor code into reusable components for improved maintainability and scalability, especially with React or Angular. Performance Optimization: Implement code...

I'm looking for a proficient SQL professional with notable expertise in SQL Server 2019. Key tasks will involve: - Query optimization - Database design - Data migration The ideal candidate should have a solid understanding of SQL Server tools and a proven track record in handling similar projects. Your previous experience and knowledge of SQL Server 2019 will be pivotal in this role. Your task will be primarily centered around maximizing the efficiency and effectiveness of the SQL Server. Preference will be given to professionals with certifications in SQL Server 2019 or related fields. Solid written and verbal communication skills are desirable.

Cerchiamo un developer fullstack per training on the job per lo sviluppo di una web application MERN con Node.js e React, possibilmente Typescript, Vite, Redux, per 3D. Conoscenza per lo store da definire preferibilemnte in Mongo o MySQL con Mongose o Sequelizer. Gestione autenticazione, ' Italia o in italiano fluente.

I'm in need of a skilled .NET MVC Core developer to build a real estate web application similar to propertyfinder.ae. I'm looking forward to working with a developer who has: - Extensive experience with .NET MVC Core - Experience in building scalable web applications.

DotNet developers required for "'Errors removal and Improvement work in thenafter Host on server"'. Developers should also have knowledge about Merger of sourcecode and database of his done-work with other developer's done-work on GitHub. Website Address - User emailid- @gmail.c Password- kaspersky Errors removal and Improvement work which has to be done is explained in below link-

I have a need for a comprehensive listing of Oracle EBS customers within the manufacturing sector in USA. This is a sizable task as it requires the creation of a list featuring more than 500 companies. In the details you collect for each organization, I'd like to see the following: - Company Name - Contact Person Name - Contact Person Email. The ideal candidate for this task would be someone who is proficient in data mining and possesses broad knowledge of Oracle EBS customers in the manufacturing, retail, automotive industry. Prior experience in CRM database creation would be an added advantage. It's essential that all information gathered adheres to privacy and data protection laws, ensuring a legally compliant list. So, a freelancer with a keen understanding of these laws...

I'm looking for an expert with exceptional Sequel database administration skills on a Windows environment. Your main task will be to handle executing regular exports from our Sequel Database to Excel, performing updates in Excel, and subsequently updating the Sequel Database with the altered data. Skills and Tasks; - Mastery in handling Sequel Database on Windows - Familiarity with Data Modeling and Design - Proficiency in exporting and updating database information via Excel - Being responsive and flexible as the frequency of this task may change. Initially, I will need it done daily for a week. Afterwards, it will be an as-needed basis for remote support. Experience in Performance monitoring, tuning, and database backup would be a bonus. The role demands strong organizational sk...

I've devised a dummy website primary for understanding log analysis which is a major concern in today's advanced technology world. To test its vulnerabilities, I require a well-rounded professional equipped with proficiency in PHP and Node.js. - Focus Area: Your tasks will encompass SQL injection techniques over my website's user login systems, data retrieving systems, and contact forms. - Skill Set: An experience with SQL injection tests is crucial. Knowledge of web technologies such as PHP and Node.js is essential. Understanding of website log analysis will also be advantageous. Your comprehensive reports on the performed tests and findings will enhance the robustness of my website and will aid in my understanding of the log analysis for future development and troubles...

I'm looking for an experienced SQL Developer with a strong background in MS SQL and data warehousing. You'll be responsible for designing and optimizing a new database system. The project involves working with Microsoft SQL Server Analysis Services in an Azure SQL environment. Key Responsibilities: - Designing a new database system - Optimizing queries for better performance - Utilizing Microsoft SQL Server Analysis Services - Ideal Candidate: - Strong experience in database design and optimization - Proficiency in SQL, specifically with Microsoft SQL Server - Familiarity with data warehousing concepts - Experience with Microsoft SQL Server Analysis Services - Experience working in an Azure SQL environment - Expert coding skills in SQL coding - E,perince in Data warehouse lik...

I require a proficient database administrator to import large XML file dumps (3gb, 20gb, and potentially larger sizes) into a MySQL database. The purpose of this task is database migration. The task will involve: - Handling entire data of moderately complex XML files, including several nested tags. - Ensuring the conversion captures all data comprehensively and accurately for smooth database operation. Ideal Skills and Experience: - Strong proficiency in MySQL and XML - Robust experience with database migration - Background in handling complex file structures - Demonstrated ability to manage large datasets.

I'm in need of an experienced PostgreSQL Database Administrator to assist with a few key tasks. - Connecting to Database: I need assistance in establishing a connection to the database. This is a crucial task that requires a skilled professional who can set up the necessary configurations and ensure seamless communication between the database and applications. Your expertise in PostgreSQL is paramount, especially having worked with different versions (9.6, 10, 11,16). A deep understanding of database management and connectivity is essential, as well as experience in working with Windows as the operating system of the database. I need remotely to connect to database. Locally its working. is not properly set.

DotNet developers required for Improvement work in thenafter Host on server. Developers should also have knowledge about Merger of sourcecode and database of his done-work with other developer's done-work on GitHub. Website Address - User emailid- @gmail.c Password- kaspersky Improvement work which need to be done is explained in below link-

I urgently need to create manual backups for my Remote Microsoft SQL Server database using VB.Net. This project requires an experienced VB.Net developer who has in-depth knowledge of SQL database operations, particularly in the area of Remote backup and recovery. The right candidate should be proficient in: - VB.Net programming - Microsoft SQL Server database management The timeline is of utmost importance as we need this running as soon as possible. Please provide evidence of comparable projects you've completed. Looking forward to a reliable and efficient solution.

My MySQL server is facing issues like high CPU usage and slow queries due to an incorrect configuration. I need a professional who can help me optimize my MySQL server by fixing the file and optimizing all bad queries to reduce the high CPU usage and improve the query speed. Key Responsibilities: - Review and modify the file to optimize the server configuration - Identify and optimize all bad queries to improve query speed - Reduce high CPU usage by fine-tuning the server - Provide a detailed report on the changes made and their impact Access: - You will be provided with AnyDesk access to the server for optimization. Ideal Skills and Experience: - Proven experience in MySQL server optimization - Strong knowledge of query optimization techniques - Familiarity with the file and server ...

My MySQL server is facing issues like high CPU usage and slow queries due to an incorrect configuration. I need a professional who can help me optimize my MySQL server by fixing the file and optimizing all bad queries to reduce the high CPU usage and improve the query speed. Key Responsibilities: - Review and modify the file to optimize the server configuration - Identify and optimize all bad queries to improve query speed - Reduce high CPU usage by fine-tuning the server - Provide a detailed report on the changes made and their impact Access: - You will be provided with AnyDesk access to the server for optimization. Ideal Skills and Experience: - Proven experience in MySQL server optimization - Strong knowledge of query optimization techniques - Familiarity with the file and server ...

I'm in need of an experienced developer to bring my SQL codes with the triggers to life with a well-designed Apex Oracle application. The app is expected to have the following features: - Implementing data entry forms that are intuitive and user-friendly. - Developing robust data analysis reports that provide valuable insights in an easy-to-understand format. - Setting up a comprehensive user authentication and security system. - Creating a visual design that aligns with my company's corporate branding while also being colorful and vibrant. - Ensuring the application is responsive and works seamlessly on both desktop and mobile devices. - Implementing an efficient navigation and information architecture to enhance user experience. The ideal candidate for this project should hav...

I'm looking for a security expert (Ethical Hack) to help me run testing on my website's login system and database access. After the testing, I need you to implement SSL encryption and two-factor authentication, as well as ensure regular security audits are in place. Ideal skills and experience include: - Proficiency in web security testing - Experience with implementing SSL encryption and two-factor authentication - Knowledge of conducting regular security audits - Familiarity with different website platforms and the ability to adapt these security measures to a custom-built website.

I am in search of a skilled developer with expertise in both MsSQL and ADF to assist me in achieving the following project goals: - Database Management: Your primary responsibility will be to manage our MsSQL database. This includes designing the database and ensuring smooth data storage and retrieval operations. - Data Integration: A crucial aspect of this project would be integrating MsSQL with various other systems and databases, mainly focusing on MsSQL itself. This will involve ensuring seamless data flow between these systems. Key Skills and Experience: - Proven experience in MsSQL database management. - Strong capabilities in database design and data storage and retrieval. - Adept at data integration, specifically integrating MsSQL with other systems. - Familiarity with ADF (Azur...

I need a proficient expert to help establish, configure, and visualize data using a Power BI server. The data for visualization will be pulled from several resources such as SQL Server, SharePoint, Excel Spreadsheets, and Teradata. Key Responsibilities: - Setup and configure the Power BI server - Connect the server to mentioned data sources - Implement interactive data manipulation capabilities into the Power BI reports Ideal Skills and Experience: - Proficient in Power BI server setup - Experience with SQL, SharePoint, and Teradata - Excel data management skills - Competence in interactive data manipulation and visual analytics - Familiarity with report generation and data analysis Please note that this project requires an emphasis on interactive data manipulation in the Power BI re...

I'm seeking an experienced web developer to create a tool designed specifically for planning faculty timetables. This tool will be a web-based application to accommodate users universally. Key Features: - Automated scheduling: The software should be able to suggest best-fit schedules automatically using input data. - Flexible adjustment options: Users should have the option to manually adjust proposed schedules or elements of the timetable. Information Needed: The application must be sophisticated enough to work with the following information: - Course names and codes - Classroom availability - Faculty availability. Ideal skills: - Experience in web development, preferably creating scheduling tools - Understanding of faculty requirements, university operations will be a plus - Pro...

I'm in need of an ASP.NET developer to help me implement user authentication, database integration, and file uploading functionalities for a small project. Below are the details of the project requirements: - User Authentication: The system should allow users to register using their email and create a password. They should also be able to log in using the same credentials. - Database Integration: I need the system to store user profiles, transactional records, and product or service listings. The database should be seamlessly integrated with the ASP.NET application. - File Uploading: The project involves a file uploading feature. Users should be able to upload files to the system. I'm looking for someone with experience in ASP.NET development, particularly in implementing us...

Are you looking to master SQL, Excel, or Python? Look no further! With years of experience in data analysis and programming, I offer comprehensive tutoring services tailored to your learning needs. **What I Offer:** 1. **SQL Mastery:** From basic queries to advanced database management, I'll guide you through understanding SQL syntax, optimizing queries, and database design. 2. **Excel Expertise:** Whether you're a beginner or looking to enhance your Excel skills, I'll cover everything from formulas and functions to data visualization and automation. 3. **Python Proficiency:** Dive into the world of Python programming with personalized lessons covering fundamental concepts, data manipulation, scripting, and more. **Why Choose Me?** - **Tailored Approach:** Each lesson ...