Can write queries sql envoriment need jobs

Hi, we require an SQL macro that we need to be able to delete EAN codes that have less than 8 numbers from the import. So EAN codes that have between 1 and 7 digits must be removed from the import. We use a software called StoreManager that uses SQL. The formulas entered in the software look like this IF([CSV_COL(16)]=0 OR[CSV_COL(16)]=‘’ OR[CSV_COL(16)]<0,‘’,[CSV_COL(16)]) Payment and/or Milestone after the problem has been solved.

'Microplastics The Silent Invader.' Information explaining the the detrimental cause and affects to our ecosystem and our health concerning plastic waste broken down into microplastics and, the initiatives needed to annihilate this silent invader.

I'm in need of an experienced Tableau Developer/Analyst/Designer to help me enhance an existing dashboard, and improve its performance and functionality. Key Responsibilities: - Enhancing the existing dashboard by adding new features and functionalities. - Ensuring that the dashboard has real-time data update and interactive capabilities. Data Sources: - The data sources for this project include databases (SQL, NoSQL) and local files (CSV, Excel). Ideal Candidate: - Proficient in Tableau with a proven track record of developing and enhancing dashboards. - Experience working with real-time data sources and interactive dashboard elements. - Understanding of SQL and/or NoSQL databases. - Familiarity with data visualization best practices. I am l...

I made a wordpress custom theme. Devs don't like to document things (I kept asking...) so need to force the matter and have someone just do it! The focus is on what is not obvious. e.g. The footer has a "join newsletter button", but where do you edit that and how does it integrate with the CRM? (And if there is custom shortcode where is that written) I need someone who knows Wordpress and to write simple documentation in a Google Doc (for me/devs- You don't need to explain how to copy/paste! ;)). This is not hardcore stuff, it's spending time on my site (I can tell you obvious things), seeing what needs to be explained (asking questions) and then writing the shortest explanation possible with screenshots so any dev (or me!) wi...

...you passionate about programming languages and eager to make your mark in the IT industry? Look no further! We’re hiring talented individuals to join our dynamic team. Position: Software Engineer Domain: Finacle (Banking) Location: Major cities in India and international locations Why Choose Us? Comprehensive end-to-end training in Unix/Linux, JSP, HTML, Core Java, Node JS, Node red, Oracle SQL, and PLSQL. Exciting projects in the banking domain Opportunities for growth and career advancement Terms and Conditions: Commitment: Minimum 3 years with us Training: First month (free accommodation), followed by competitive salary Performance-based increments from the second year onward Global travel opportunities Qualifications: - While we do not have any specific certificat...

I'm seeking assistance to implement Adsense for search on my informational website. Priority is to display ads that relevant to the visitors' search queries. Ideal Skills and Experience: - Proficiency with Adsense integration for search functionality - Strong understanding of search-related ads optimization - Experience with informational websites Job Deliverables: - Successful integration of Adsense for search - Displaying ads related to visitor search queries - Assurance of minimal disruption to User Experience through the integration process

I'm seeking a seasoned resume writer, with a knack for crafting resumes focused on the IT industry and a comprehensive understanding of executive-level priorities. - Your target audience will be, primarily, senior decision-makers in IT recruitment. - Also, the resume must highlight my skills as an Architect. Ideal Candidate: - Proficient in resume building for executives. ...Your target audience will be, primarily, senior decision-makers in IT recruitment. - Also, the resume must highlight my skills as an Architect. Ideal Candidate: - Proficient in resume building for executives. - Knowledge of the IT industry (java Full Stack development) and architect roles. - Excellent communicator with collaborative editing skills. - MongoD...

Write financial contents for a financial blog. Category 1. Investments 2. Banking 3. Insurance 4. Personal finance 5. Loan Etc. Make sure your contents are not copy pasted. Should be 800-1000 words long atleast. Paid to you 1.5USD per article

I'm on the lookout for a skilled website manager who can handle multiple facets of my E-commerce website. In addition to managing the website, you will also be responsible for marketing through various channels. Key Responsibilities: - **Website Maintenance:** You'll be responsible for ensuring the website is running smoothly, keeping the design up-to-date, and overseeing its overall functionality. - **Content Creation:** As my website manager, you'll be tasked with creating engaging and SEO-optimized content for the site. - **SEO Optimization:** You'll need to possess a strong understanding of SEO practices to ensure the website ranks well in search engine results. Marketing Channels: - **Social Media:** Your role will include managing the social media ...

WP experts needed-Use wordpress auto translation plugin/Sitemap generator etc to auto generate seo friendly wholesite translation for seo purpose. Should have a whole auto solution for translation for auto generate seo friendly can be google indexed auto.

I'm in need of an expert who can proficiently answer queries related to the cardiovascular system in medicine. The focal points of our inquiry could range from the heart's anatomy, blood vessels or even cardiac diseases, as our specific topics are not strictly defined. The perfect candidate for this task would possess: - Extensive knowledge in various areas of cardiovascular medicine. - An ability to provide detailed explanations on diagnostic and treatment aspects. - Clear and precise communication skills. By clearing these queries, their knowledge will efficiently translate into our understanding of cardiovascular medicine. We look forward to sharing a productive dialogue with the right professional.

...The model we want must be able to perform two functions. 1. Generate a song based on the text entered by the user using the sample voice selected by the user. 2. Converts the voice of the song uploaded by the user to the voice selected by the user. To achieve this, the developer must do the following: 1. You must search for sample voices and corresponding pictures that the model you developed can produce and upload them on the frontend page. (Please refer to ) 2. Proceed with model development and training. 3. Develop bakend API. 4. Integrates backend and frontend. 5. Integrate payment process. 5. Complete the project 7:59 Please attach your brief cover letter detailing your experience and why you are the perfect match for this role. Your application should demonstrate

I need a qualified professional to develop a very small, two-screen mobile application for Expo. This project does not require integration with any external database or backend creation. There is no login functionality. Your responsibility will be to develop an interface similar to figma and with the functions below. *Does not need to be identical to figma, but maintain logic. Link Figma: How it works: - The entire user journey is gamification. - The user chooses a project that has x days (screen 1). Then you must mark the completed days (screen 2) in the app to earn coins. - The coins are on the top bar (Fixed) and starts with 0 coins. - The number of user coins and complete days must be saved

I'm in need of an expert in c who can design and integrate GTK-based project. The project aims to enhance the GUI design and user experience. Key Requirements: - Experience in GTK: Prior experience in GTK-based software development is crucial for this project. - Cross-Platform Application: The final product should support Windows, Linux, and MacOS. Ideal Skills and Experience: - Proficient in GUI Design: The ideal candidate should have a strong background in GUI design and development. - Familiar with Motif Libraries: Prior experience in creating and integrating motif libraries is highly preferred. - Knowledge of GTK: Experience in GTK-based projects is a significant advantage. - Cross-Platform Development: Understanding of cross-platform application development and ...

Seeking a developer with experience in C# and SQL for a predictive artificial intelligence project. Your role will involve developing a model to predict user behavior on a vending machine, utilizing data stored in SQL Server. Proficiency in artificial intelligence is required. Please don't send a bid to later try to increase it. Will be declined.

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

Title: Charles Proxy support Introduction: I am seeking a skilled professional who can provide ongoing support for my personal use of Charles Proxy. As a beginner, I require assistance in setting up and navigating this tool effectively. Requirements: The ideal candidate should possess the following skills and experience: 1. Charles Proxy expertise: - Proficient in using Charles Proxy for personal use. - Familiarity with its features, including SSL proxying, request/response manipulation, and traffic analysis. - Ability to troubleshoot and resolve issues that may arise during usage. 2. Technical proficiency: - Strong understanding of networking concepts, HTTP, and HTTPS protocols. - Knowledge of web development technologies, such as HTML, CSS, and JavaScript. -...

I need a custom bot that can operate within ChatGPT, utilizing my custom PDF resources to provide accurate and relevant responses. Key Requirements: - The bot should be able to search all of my PDF documents simultaneously. This is crucial as the information I will be querying could be spread across a range of resources. - The queries the bot will be handling will be full-text. This means the bot should be able to understand and respond to complex, multi-sentence questions, and not just simple keyword-based ones. Ideal Skills and Experience: - Experience in developing chatbots and familiarity with ChatGPT. - Proficiency in creating and implementing systems for data retrieval from PDF documents. - A strong understanding of natural language processing and the ability ...

...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 be available in the database and needs to be show in website with some base UI. Project involves show some other API data on the website as well Need not have a lot of experience in UI design but need experience showing data into a page. Website would look like this --- Odds data should be displayed like this show in the page. Along with some custom stats

I'm in need of a skilled video shooter to create a short promotional video for our hospital. Person must be from Delhi. The purpose of this video is to engage our audience and communicate the essence of our hospital. I am looking for an engaging, high quality video resolution.

I am in need of a versatile individual who can expertly manage my social media accounts and provide basic video editing. Here's what I'm looking for: - Mastery in handling Facebook, Instagram, and Twitter. - Experience in creating engaging social media content. This includes posts that are visually compelling and text that provokes interaction. - Ability to schedule posts and efficiently manage content calendar. - Proactive in engaging with followers, reacting to comments, and answering queries. For the video editing part, you don't need to be Spielberg. I just need someone skilled in making clean cuts, good transitions, and basic color grading. If you're a social media maven who has a keen eye for video aesthetics, I need y...

I am in need of a versatile individual who can expertly manage my social media accounts and provide basic video editing. Here's what I'm looking for: - Mastery in handling Facebook, Instagram, and Twitter. - Experience in creating engaging social media content. This includes posts that are visually compelling and text that provokes interaction. - Ability to schedule posts and efficiently manage content calendar. - Proactive in engaging with followers, reacting to comments, and answering queries. For the video editing part, you don't need to be Spielberg. I just need someone skilled in making clean cuts, good transitions, and basic color grading. If you're a social media maven who has a keen eye for video aesthetics, I need y...

I'm in immediate need of a practical yet advanced Store Inventory Management System. It's crucial for the system to streamline inventory tracking, significantly enhance order processing efficiency, and provide robust reporting capabilities. To create a custom inventory software tailored to the requirements of a folding and sliding door manufacturer workshop, you'll need to develop a comprehensive solution that encompasses the entire workflow. Here's a breakdown of how you could approach each step: 1. **Job Order Management:** - Allow users to create job orders with reference numbers for each project. - Capture project details such as customer information, project specifications, deadlines, etc. 2. **Requisition to Store:** - Enable users to cre...

...application will also include a chatbot feature that can be easily integrated into other websites as a microservice. Additionally, the application will support payment methods for premium features. Requirements: Website / Document Scanning Functionality: * Users should be able to input any website URL or document into the application. * The application should scan the website and extract relevant data for processing. * Extracted data should be stored in a database for future reference. AI Model Integration: * The application should integrate with an AI model capable of answering questions based on the scanned website data. * Preferably, use a free or cost-effective AI API for this purpose. * The AI model should provide accurate responses to user queries based on the sca...

We are looking for someone to take a T-Shirt mockup from a supplier and make a Photoshop action the shirt transparent so it can be used in an online customiser with the background colour set. This should retain highlights and shadows, and work correctly to show the correct colour through when any colour is set as the background. You can see an example of how this should work in the attached files (we have original and completed files). Any queries please ask.

I've run across an issue in my WordPress / WooCommerce site that I'm not sure how to fix. I keep getting the error: "WordPress database error Commands out of sync; you can't run this...". This error is not related to specific actions or queries on my site. It's clear I require someone skilled in problem-solving and debugging with: • Extensive WordPress and WooCommerce experience • Clear understanding of WP databases and commands • Proven ability to address and correct site errors Please, I need this problem solved urgently. Your expertise and prompt attention to this will be greatly appreciated.

...proficient in 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 buil...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 ...

...specializes in data, coding, and career development bootcamps for students, working professionals, and career changers. We are looking for a skilled inbound sales specialist to help us grow our business. Key Responsibilities: - Identifying and contacting potential leads who are interested in switching or starting their career out as a data analyst, data scientist, or data engineer - Addressing any queries or concerns the prospects might have about our services. - Qualifying and converting leads into customers, ensuring they understand the value and benefit of our bootcamps. Ideal Skills and Experience: - Proven track record in inbound sales, especially in the education or bootcamp industry. - Excellent communication skills to effectively engage with a diverse audience. - Unders...

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.

...candidates should have plenty of experience with Flutter Development, as well as a portfolio of past work to demonstrate their expertise. - Proficiency in Flutter development - Experience in developing for both iOS and Android platforms - Ability to work independently with minimal guidance You have to setup and configure both the flutter application (iOS and android) as well as the backend PHP, my SQL, firebase, docker etc. As the client, I did not specify the key features to be prioritized, giving you the flexibility to design the app in a way you find most effective. Similarly, there is no predesignated design requirement for the app, paving the way for creative freedom. Given the lack of specifications, the ideal freelancer should be highly creative and intuitive, capable...

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 need someone who can research the regulations for importing and selling industrial RFID reader in Hong Kong. A brief report needs to be made with the following information: 1) Regulations related to the import of RFID reader ・ Approval and license that importer and distributor are obliged to obtain prior to the import and selling of RFID reader (such as OFTA license) ・ Related laws and regulatory authorities 2) Regulations and standards related to the sale of RFID reader, such as Quality standards or quality requirements, Environmental requirements (RoHS etc.) that need to be satisfied (if any) ・ Regulations regarding labels (labeling requirements, if any) ・ Each report needs to be made in English and will be of about 4 sheets of A4 paper (about 2,000 words). I wa...

I'm looking for a talented WordPress developer to build my website. I will provide the template. I will provide the design idea and you implement the design, so you will not have to worry about that, but I do need assistance implementing it into WordPress. Specifically, I expect: - Implementation of my provided design into the WordPress platform - Creation of an e-commerce feature for my online products - A custom contact forms for client queries I have a specific WordPress theme in mind, details of which I will share after hiring. Ideally, you have extensive experience in WordPress, particularly in building e-commerce sites, and in working with custom themes. Your expertise in my theme would be a huge plus. I'm also looking for someone who's communicative, ...

Please bid if you have Android development skills and CloudFront services experiences.

I am seeking a skilled administration officer who can work remotely with reliable I.T. equipment and a work-friendly environment. This is a full-time position with a monthly salary of $2,000 (Australian Dollars). Responsibilities: - Data entry and file management: The ideal candidate will be responsible for inputting, updating, and maintaining data accurately and efficiently. - Email and calendar management: Handling and organizing emails and managing calendars, scheduling appointments and meetings. - Customer service and support: Providing excellent customer service, addressing queries and concerns. Software and Tools: - Microsoft Office Suite: Proficiency in Word, Excel, and PowerPoint is required. - Vettrak Student Management System: Experience with this software is bene...

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 need an artist to create a unique invitation for my son's birthday. I want a nautical theme centered around cruise ships and sea life. The color base should majorly be blue. As for design style, I am open to any cool and eye-catching concepts. - Skills Required: Graphic Design, Photoshop, Illustrator - Experience: Designing expertise - Personal Traits: Creative mind, attention to detail, cool and fun design approach Inside the image there will be some text (location address, hour, kid's name, etc.) I am open to any queries regarding the project. Looking forward to working with a pro!

I'm in need of a sleek and professional website that will mainly serve as an online presence to display information about my technology company. Additionally, I'd like to incorporate a blog or news section to keep visitors engaged and up-to-date with our latest offerings. The website should also offer two-way communication through contact forms and live chat support for instant customer interaction and feedback. Key Features: - Corporate Information Display: The website should effectively showcase our company's profile, services, and expertise in the technology domain. - Blog/News Section: Regularly updated blog or news section to keep visitors informed. - Contact Forms: Enable users to reach out easily with queries or collaborations. - Live Chat Support: Real...

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

...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 decisions in the trading sector. A deep understanding of trading data and the ability to work ...

I didnt know how to sell on here... (Nudes) So im using this. If u want any of my nudes either hit me up on here or kik: kissesfrommwah1376. Im only accepting paypal. i have 70 nude photos. 20 nudes: 10$ 40 nudes:20$ 50 nudes:35$ 75 nudes: 50$ (Own me) I sell myself... meaning u can call me,get nudes from me, videos whenever u want 1 week: 60$ 1 month: 100$ 3 month: 150$ 1 year: 400$

I am in need of a skilled and experienced sales representative to drive chandelier sales, both in-store and online. Key Responsibilities: - Promote and sell high-end chandeliers, aiming to boost revenue and build a loyal customer base - Monitor and respond to online sales inquiries and ensure swift delivery of products - Provide exceptional customer service, ensuring each customer's needs are met and queries are answered promptly - Utilize strong online marketing skills to increase the visibility of our chandeliers online Key Skills Required: - Proven experience in luxury goods sales is a must. You should be able to demonstrate an understanding of high-value products and how to effectively sell them. - Strong online marketing skills are crucial - you will be responsib...

I need assistance in pointing my Namecheap domain to my WordPress site and migrating it. I currently have a wedding planning website hosted on WordPress. I'm seeking a skilled professional who can help me with the following: - Domain Pointing: I need my domain with Namecheap to be configured to point to my WordPress site WITH SITEGROUND. This includes setting up the necessary DNS records, ensuring the domain properly resolves to my website. - Website Migration: I need assistance with migrating my WordPress wedding planning site to a new web host. This should be done with minimal downtime and ensuring all the content, functionality, and design elements are correctly transferred. Ideal candidates for this project should have: - Proficiency in managing and ...

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

Your expertise will contribute to a cutting-edge project that combines music generation with voice cloning to create songs sung by virtual personas. We want our app to have the following features. - Create unique music based on user input information (speed, type, length...). - Create music based on the voice provided by the user - Change the voice of music provided by the user to the voice provided by the user Skills expected of you 1. Strong background in machine learning, deep learning, and neural networks. 2. Experience with audio signal processing and familiarity with audio data preprocessing techniques. 3. Proficiency in Python and experience with machine learning libraries such as TensorFlow, PyTorch, and Keras. 4. Knowledge of music theory and composition is a plus. 5. Experience...

Please Sign Up or Login to see details.

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

I need a proficient HTML developer to construct a detailed contact form for my business website. This form should be equipped with several features to enhance our correspondence with clients. Here are the critical requisites for this project: - Form Capabilities: The form must support file uploads specifically for image and document files. No video file uploads are permitted. - Auto-Response: Configure the form to send an automated reply once a customer fills it out. This reaction should reassure the client that their message has successfully been received. - Database Utility: Arrange for all submitted information through the form to be securely stored in a database. This will streamline tracking and handling of client queries. Details of the DB structure will be provid...