Need experience 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...

...promote simplicity and emphasise my portfolio itself rather than the design aspects of the site. Ideal Skills and Experience: - Proven experience in website creation on custom domains - A strong understanding and appreciation for minimalist design principles - Ability to bring concepts to life, balancing both functionality and aesthetics The final product should be a clean, sleek, and easy-to-navigate website, reflecting the minimalistic style while providing exceptional user experience. My expectation is for a thorough, detailed-oriented professional who can capture my vision and translate it into a fully functional portfolio site. Things to be done Load an API data into on premise SQL server database Client will do some data calcution The new data will ...

I'm in need of a dedicated, professional, and efficient virtual assistant capable of performing various tasks with a strong focus on scheduling meetings, managing my calendar and answering calls. This role requires someone: -Who is a female -Fluent in English, with excellent written and verbal communication skills -Experienced and proficient with Google Suite -Able to manage my time effectively through careful organization and prioritization of tasks Ideal candidates will have experience in a similar role and demonstrate the ability to handle tasks with efficiency and discretion. Your ability to provide support while maintaining professionalism at all times will be essential in this role.

...Websocket and SQL, who can help me with an automation project. Key requirements: - Profound knowledge in Python, including advanced topics and best practices. - Strong understanding of Websocket and SQL. - Experience in automation tasks would be highly beneficial. - Ability to adapt to different mentoring methods, such as video calls, live chat, or in-person sessions. Your tasks: - Mentor me through the automation project, providing guidance and support. - Help me understand and implement Python, Websocket, and SQL concepts effectively. - Adapt to my preferred session mode, whether it be video calls, live chat. Ideal skills and experience: - Proven expertise in Python, particularly in automation applications. - Experience working with Websoc...

Looking for experienced computer programmers skilled in Python for a web development project. Skills and Experience Required: - Proficiency in Python programming language - Strong knowledge of web development concepts and frameworks - Experience in building and maintaining web applications - Familiarity with front-end and back-end development - Ability to implement responsive design and ensure cross-browser compatibility - Good understanding of database management systems and SQL - Knowledge of version control systems and agile development methodologies Timeline: The project is expected to be completed within 3-4 weeks.

I'm in need of an experienced developer who's well-versed in ASP.NET and VB.NET. The project involves the event pages i need where user can login and acess the event throught calender with specific functionality.. i will share feature to slected one ... Ideal Skills and Experience: - Proficiency in ASP.NET & VB.NET is a must, with a proven track record of projects involving user authentication and database integration. - Strong understanding of SQL Server databases and how to effectively integrate them into a .NET environment. - Experience in implementing user authentication systems that cater to both roles and individual accounts. This project requires a developer who can deliver secure and efficient user authentication and database int...

I require a skilled freelancer with experience in Amazon Web Services (AWS). We have a an ERP Developed on Laravel which is currently on a On-Premise Windows Server. We would like to move the application to AWS using a windows OS and SQL Server Database. Please guide as to which option would be better. The selected freelancer would have to set up a Windows operating system. Skills and Experience Required: - Proficiency in AWS, - Demonstrated experience deploying Please ensure to include examples of your previous AWS work in your bid. Your ability to efficiently handle tasks in the AWS environment is paramount for this project.

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 in need of a Django Developer with React experience to work on projects for one of my client. Requirements and Responsibilities: - You should be comfortable working with Django, a high-level Python web framework, and have experience in building web applications with React. - The projects will include features like user authentication and registration, real-time notifications, and integration with third-party APIs. - You should be available to work on multiple projects at once, ensuring timely and quality deliveries. - The ability to communicate effectively and understand the diverse requirements of different projects is essential. - Experience with multiple projects and a strong understanding of best practices in Django and React are highly preferred...

MUST READ FIRST =============== MUST HAVE - Blazor experience of at least 3 years - Latest version of .NET & SQL Server - At least 1 hour of availability between 6:00PM and 11:00PM EST - Your price is the one that you REALLY want to have with 10% +- NOTE - APIs will be provided (you will not develop APIs) - No development will be done on My Computer. - DO NOT APPLY if your fees can exceed 10% or your bid PROJECT I have C# Blazor Web App that works using SQL Server Database & using APIs at the same time. For the functions that use the database, I want to replace them with the APIs 1- Make code debuggable. 2- Error message appear with no details, need to make the error message has Show More to display the details of the error. 3- Load Codes from A...

I'm in need of a professional who is skilled in both graphics and Power BI. Let's collaborate to convert raw data into clear, visual and interactive dashboards. Here are the specific needs for this project: Power BI Tasks - Effectively perform Data modeling, Data visualization and dashboard creation using Power BI - Work with various data sources that include Excel Spreadsheets, SQL databases, Online APIs, and Azure Graphics Tasks: -Even though I didn't specify any graphical needs, any creative approach or design skills you can bring to the project to enhance the visual aspect of the data would be appreciated. Ideal Candidate - Proficient in Power BI - Experienced in working with multiple data sources - Has a knack for graphic design - Detail-oriented and d...

...Responsibilities: - Perform data analysis and visualisation on trading or stock market data - Use your data science skills to provide valuable insights - Ensure the accuracy and efficiency of your predictive modeling Ideal Skills and Experience: - Proven experience in trading or stock market data analysis - Proficiency in Python, R, and SQL - Strong analytical and problem-solving skills - Prior experience with predictive modeling and algorithm development - Ability to handle a variety of data sizes and formats, as the size of the data may vary If you have previous experience in the trading industry and can confidently handle data analysis and visualisation, this opportunity is perfect for you. Your work will play a vital role in helping make informed...

Google app script expert needed for stock price and data for world wide countries. Basically we have done for 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...

I'm in need of a freelancer with strong Python skills. I require a time series forecast for my Twitter dataset. The forecast should be for 1, 3, and 7 days ahead. The key deliverable is 3 dynamic dashboards that display this forecast in real-time. Key Points to Note: - **Programming Language**: Python - **Time Series Forecasting**: The freelancer is expected to have a solid understanding of time series forecasting methods. The deliverables should include 2 Neural Network and 2 autoregressive models (ARIMA, SARIMA etc…). The validation should demonstrate each model performance. - **Dynamic Dashboard**: I'm looking for a dashboard that's dynamic and interactive. It should display the forecast for the Twitter data using a visually appealing interface. - **Real-ti...

Looking for a CPA from Philippines with strong English skills, multi-years work experience in Xero, QBO, MYOB, Sage for US/Australia/NZ companies. Tax filing experience would be an added skill. Overall engagement would start small but can grow into a full time engagement depending on the quality of work delivered. The role would entail shift working and the work hours will be a function of client requirements. (PH night shift/early morning shift). Only looking at Individual Freelancers with CPA qualification, team bids will be rejected. If this description excites you, happy to chat. Experience in automation in accounting and comfort with writing accounting / finance content preferred. The price range quoted is monthly price range.

I'm searching for an expert in Visual Studio 2022, MS SQL, and VB.net, for the main objective of maintaining and updating an existing software application. Key tasks: - Primarily, the project will involve optimizing the application's performance. Skills and experience: - Experience with Visual Studio 2022, MS SQL, and VB.net is a must. - Proven expertise in software optimization. - Knowledge of system maintenance and updating.

I have a 500MB XML file that I need loaded into SQL across approximately 20 tables. I'm in need of a Python script to handle the transformation. The script will need to handle normalization of the data. Key requirements: - Develop a Python script to read the XML file and transform the data into a normalized structure across 20 tables. - You will need to create the SQL tables as part of the normalization process. - Experience with large data transformations and SQL is vital.

I'm seeking a skilled .Net developer to assist in developing a comprehensive retail system that has features such as user authentication ...retail system that has features such as user authentication and authorization, inventory and product management. Requirements: - Proficiency in C#, .Net, Entity Framework and SQL Server - Ability to develop a retail project from scratch - Strong understanding of user authentication and authorization - Experience in inventory management and product cataloging It's crucial that the chosen freelancer has prior experience in building online retail systems and a strong understanding of the retail business model. The ideal candidate should be able to deliver a secure, efficient and scalable retail project. Any experience...

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.

...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 will require close collaboration. Dev team required to develop a recruitment relate...

...AI/ML system with distinct functionalities. Ideal skills should include: • Extensive experience with AI/ML models. • Known for providing solutions with Natural Language Processing (NLP) capabilities, recommendation systems, data analysis, and data visualization. • Proficiency with QR, WhatsApp, LLM, DB, managing user profiles, cataloguing orders, generating recommendations, and facilitating payment systems. 1. Implement a QR code as the entry point for users to access WhatsApp chat. 2. Utilize WhatsApp APIs to initiate chat sessions. 3. Employ Language Model (LM) capable of Hindi, English, and Hinglish for conversational interactions. 4. Integrate LM with backend logic for CRUD operations on a DB (SQL/NoSQL). 5. Store restaurant data including name, menu...

I need an experienced Superset developer to improve and customize my existing project. The primary focus of this project is to enhance the user interface and hunt down and replace poor layout aesthetics and confusing data presentation. Key tasks include, but may not be limited to: - Customizing the dashboard layout to make it more user-friendly and intuitive - Adding new visualization types to better represent data - Integrating the project with external data sources for wider data accessibility Ideal candidates should be proficient in Superset and have a solid background in UI/UX design and data visualization. Familiarity with third-party data integration will be an added advantage. This project requires not only technical expertise but also creativity and a keen eye for aesthet...

Description: I am looking for an expert in SQL and R programming for a detailed data analysis project. This project involves extracting, analyzing, and reporting on data from a sophisticated relational database setup. The ideal candidate should have a solid background in data science, with specific skills in SQL and R. Responsibilities: Efficiently query and manage data using SQL from a SQLite3 database. Apply R programming techniques for advanced data cleaning, analysis, and visualization tasks. Ensure data integrity and optimize data processing workflows. Analyze results to derive actionable insights and compile detailed reports. Document all processes and code in a clear and comprehensive manner. Requirements: Profound knowledge of SQL with experience...

About us: BA Marine is 3 years old company with a track record of USD 15 Million value of transaction of 60 vessels in GCC during the past 3 years and operated by the owner alone that generate 60 existing clients and 400 prospective clients. We are looking for bilingual speakers: Arabic and English...seafront cities. -Inviting users on public groups or any other boat lovers communities to join our FB page or to follow us on Instagram. -Nurturing clients who inquired about any of our services and set them if they are qualified and interested. -Updating all generated leads and/or appointments into CRM. -Providing EOD report for all activities. Required Skills: - Excellent communication skills. - Experience in using social media for cold outreach is a plus. - English and Arabic&nbs...

I am in need of a fabricated experience certificate that'll reflect my role as a HR Recruiter for 1.5 years. Along with this, I require a credible monthly payslip. Here are the details: - The experience certificate should entail job particulars such as job title and description, company name, address, and dates of employment. - As for the payslip, it should reflect a monthly salary of under $2000. This is the only detail I require for the pay slip. The freelancer to take on this project should possess excellent attention to detail and immaculate graphic design skills, with particular experience in human resources paperwork. High ethical standards required given the sensitive nature of this request.

Our company develops both desktop and web applications tailored for analysing insurance premiums. These have been developed in Delphi over the past 25 years. We are seeking to establish a long term relationship with an experienced Delphi programmer with exposure to Microsoft SQL databases. ASP.net application experience is also desirable. Our software packages require continued upgrading and enhancement and given the specialist nature of our software we are seeking to establish a long term relationship. The primary requirements include understanding our business process and system design, determining and articulating technical solutions, and implementing the design into build and install stages. Australian based is preferred, our principal office is based in Sydney NSW. ...

...create an immersive acoustic environment for a medium-sized cinema with a seating capacity of 50-100. The main objective is to improve the overall movie-watching experience. While I don't necessarily have specific acoustic solutions in mind, I am particularly interested in those strategies and technologies that aid in creating a more immersive sound experience. Key responsibilities include: - Proposing and detailing the most suitable acoustic solutions. - Balancing the cinema's unique needs and characteristics with proven acoustic solutions. - Delivering a final design that enhances the immersiveness of the cinematic experience. The ideal candidate is an audio engineer or sound designer with a strong background in designing acoustics for cinema or lar...

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'm in need of an hacker to perform a thorough black-box penetration testing on my WordPress website. Key Responsibilities Include: - Testing the security from an outsider's perspective. - Identifying and using hacking techniques including SQL injections, cross-site scripting attacks, and brute force attacks to hack website as outsider so that we can plug the vulnerability. Ideal candidates should have: - Proven experience in website vulnerability testing. - A strong understanding of WordPress. - Exceptional problem-solving skills. - In-depth knowledge of SQL injections, cross-site scripting attacks, and brute force attacks. My objective is to ensure my website's robust security, and your expertise can help me to achieve this. Your keen eye ...

I'm seeking a qualified facilitator for a strategic planning session with a singular objective: to develop tangible, action-ready strategies that primarily aim to enhance our customer experience. Key Focus Areas: - Expertise in customer-centric cultures is crucial as the strategies will heavily focus on this aspect. - Proficient in identifying interventions for upping our overall membership engagement, which is currently lagging, would be notably beneficial. Inviting those passionate about improving service delivery time, product quality, and staff interactions to bid. Your innovation and wisdom will help us thrive in this competitive market. I have included the previous strategic plan (done in 2016) for your review. We are looking for four virtual sessions, two hours e...

I'm looking for Jr. Python developer to create a few functions that get all get a specific email send email based on this API:

I ...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 approach to automating daily database updates - Your estimated timeline for completing the project - Any relevant e-commerce projects you've worked on - Your preferred database management system...

...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�...

I'm requiring aid in managing and optimizing my SQL database. This database is currently handling a range of information including product details, customer details, and order details. Key Tasks: - Improve the existing SQL database - Ensure efficient handling of product, customer, and order data Ideal experience and skills: - Proficiency in SQL queries - Experience in database management - Familiarity with inventory management processes, specifically handling a limited range of 20 different products. This project will require a keen attention to detail and a comprehensive understanding of SQL database manipulation.

I'm currently facing potential malware attacks causing unexpected slowdowns, particularly affecting my website load times. Hence, I'm in urgent need of a knowledgeable cyber security professional who can identify and rectify issues within my server files. Key Responsibilities: - Investigate the root cause for the slowdown of the website load times - Pinpoint potential malware in server files - Advance and fortify the security system to prevent future occurrences Ideal Skills: - Proficiency in cybersecurity - Solid understanding of server operations, particularly SQL - Experience in malware detection and prevention Your task: Use your expertise to bring back operational efficiency and bolster my domains server's security. If you can catch the malwa...

I'm seeking a SQL and snowflake expert. I have a small table in snowflake, for which I need a view to be created. The view will have some failed from the table and then some calculated fields based on the original table.  Needs to be done asap. Will share the table data and columns of the table in and excel sheet and the desired results as well for your reference.

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. • Desig...

need seo experts/developer to fix google search console/SQL index issue. we have many pages not indexed on gsc, need seo experts/developer to fix it. I'm currently facing an issue with pages on my website not being indexed and therefore not showing in Google's SEO results. It's crucial for the successful completion of this project to have these pages visible on Google again. Ideal candidates for this task should have: * Extensive experience with Google Search Console * Proven expertise in resolving indexing issues * A deep understanding of SEO best practices Please include your past work related to resolving such issues in your application. A detailed project proposal would certainly be a plus. Prompt completion is advantageous, although a...

I'm in need of an experienced Python developer to assist with the development of critical web security tools. While specific tools aren't outlined below - Subdomain Enumeration: Subdomains to be listed and categorized. - Directory Enumeration - Sensitive Parameter Detection - XSS Testing - SQL Testing

I'm in need of an experienced Python developer to assist with the development of critical web security tools. While specific tools aren't outlined below - Subdomain Enumeration: Subdomains to be listed and categorized. - Directory Enumeration - Sensitive Parameter Detection - XSS Testing - SQL Testing

NOTE*: AUTO GENERATED APPLICATIONS WILL BE DELETED! I need someone to quickly guide me on affiliate marketing services & products. I need some suitable affiliate products for my Instagram account. Your job will be to tell me about the services that you have tried. And tell me the best way to implement some of these affiliate products into Instagram. I really need someone that can help me. DO NOT APPLY IF YOU HAVE NOT SUCCESSFULLY DONE AFFILIATE MARKETING VIA INSTAGRAM

Only Apply if you meet the following: Have experience with outreach and strong understanding of SEO, know how to use tools such as ahrefs, majestic, MOZ etc. You also have strong VA experience and know how to follow orders and instructions and can perform a wide range of various tasks. So you need to be an all rounder. First task will be sending out some emails to check they are working, then you will do some sourcing of potential sites for advertising then outreach. Tasks will be given as per when needed. You need to communicate clearly and regularly and should be available whilst working if needed for communication. I am in need of an experienced virtual assistant with a deep understanding of link building specific to the technology sector. My primary...

NOTE*: AUTO GENERATED APPLICATIONS WILL BE DELETED! I need someone to quickly guide me on affiliate marketing services & products. I need some suitable affiliate products for my Instagram account. Your job will be to tell me about the services that you have tried. And tell me the best way to implement some of these affiliate products into Instagram. I really need someone that can help me. DO NOT APPLY IF YOU HAVE NOT SUCCESSFULLY DONE AFFILIATE MARKETING VIA INSTAGRAM

I'm in need of a website and customer portal. The website is an informational site, but the customer portal is the heart of the project. It should be designed to handle our Software as a Service (SaaS) licensing. The main functionalities required are: - **Payment Processing:** The portal needs to process payments from our clients. - **License Management:** The portal should manage our SaaS licenses. Ideal candidates for this project should be well-versed in web development, particularly in creating user-friendly and efficient customer portals. Experience with integrating Square and Zoho Books is a plus. It's crucial that the website and portal are secure and scalable. A good understanding of SaaS models would also be beneficial. Additional Requirements IoT Hybri...

MUST HAVE - Blazor experience of at least 3 years - Latest version of .NET & SQL Server - At least 1 hour of availability between 6:00PM and 11:00PM EST NOTE - APIs will be provided (you will not develop APIs) - No development will be done on My Computer. PROJECT I have C# Blazor Web App that works using SQL Server Database & using APIs at the same time. For the functions that use the database, I want to replace them with the APIs 1- Make code debuggable. 2- Error message appear with no details, need to make the error message has Show More to display the details of the error. 3- Load Codes from APIs instead of loading from JSON file. (1 API) require updating treeview to load on demand 4- Packages Load from APIs instead of loading from DB (2 API...

Require a video which needs to be created using high resolution satellite and mosaic teaser shots and other online tools for a YouTube Short Video. Possible ongoing and continued work with working proof of concept delivered. Further details upon contact. Will Look at new Freelancers also.

I am in need of an individual with experience searching for people online. You must be experienced. It's urgent. If you made the proper result, I am willing to pay more and more. $50 per each. you need to find several persons. If you are confident in that, apply with "IESFPO"

I am in need of an individual with experience searching for people online. You must be experienced. It's urgent. If you made the proper result, I am willing to pay more and more. If you are confident in that, apply with "IESFPO"

I'm searching for a talented bookwriter to help me pen a medium-length (100-200 pages) memoir focused on my personal journey leading up to a divorce from a narcissistic partner. This project requires: - Experience in writing memoirs or similar non-fiction genres - Excellent research and storytelling skills to accurately portray circumstances and emotions - Ability to convey the delicate subject matter tactfully and with great sensitivity - Strong command of the English language Your role will entail assisting in organizing the structure of the memoir, refining my drafted ideas and experiences, and filling in necessary narrative gaps. If you've worked on such projects before and feel you can handle this with the gravity it demands, I look forward to your proposal.