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...
...able to provide feedback and report issues related to the power outages. - Energy Saving Tips: Provide users with recommendations and tips on how to save electricity. - ZESA Tokens Purchase: Provide users a convenient platform to buy ZESA tokens online using mobile money. Ideal skills for this project include: - Proficiency in programming and web development, especially in creating custom-built websites. - Experience in integrating user registration, notification alerts, and feedback platforms. - Knowledge of power consumption monitoring tools and report generation. - Understanding of e-commerce and secure online payment methods. - Ability to work under tight deadlines and deliver high-quality work. I'm looking for someone who can start immediately and commit to completing...
I'm urgently seeking a freelancer who can assist in modifying the formatting in a PDF file I have. Your responsibilities will include: - Adjusting the text charges in the document. Ideal candidates for this project will have excellent attention to detail, proficiency in working with PDF files, and the ability to work swiftly as this task needs to be completed ASAP. Knowledge of diverse formatting styles will be a real asset. Please provide examples of similar work you've done in your proposal.
...efficient, user-friendly websites on cardd.com. The website is set to primarily cater to business owners and will serve as an informational platform about my company. my domain is from Included will be: - information of my company - Overview and specifics of the services we're offering - A function to access our contact information readily - Video Sales Letter (VSL) to help communicate what we offer in a creative and engaging way - A "Let's Talk" button leading to a booking platform, to allow easy appointment setup - maybe a couple other details Extensive knowledge in UI/UX design, functionality implementation, and experience with platform will be advantageous for the position. A background in creating similar professional business ...
...able to provide feedback and report issues related to the power outages. - Energy Saving Tips: Provide users with recommendations and tips on how to save electricity. - ZESA Tokens Purchase: Provide users a convenient platform to buy ZESA tokens online using mobile money. Ideal skills for this project include: - Proficiency in programming and web development, especially in creating custom-built websites. - Experience in integrating user registration, notification alerts, and feedback platforms. - Knowledge of power consumption monitoring tools and report generation. - Understanding of e-commerce and secure online payment methods. - Ability to work under tight deadlines and deliver high-quality work. I'm looking for someone who can start immediately and commit to completing...
I'm looking for a skilled SEO professional to help me achieve top Google rankings for two websites, each with specific goals in mind. For : - Targeted Markets: I require the site to be ranked #1 on very specific local markets. - Content Strategy: The site is already live. I plan to feature a mix of blog posts, product/service descriptions, and customer testimonials. For the second website, which is still under development: - Primary Goal: The site is being developed with the primary focus on lead generation for services. - Content Strategy: I'll be featuring a range of content types to support the SEO goals, including blog posts, product/service descriptions, and customer testimonials. Ideal skills for this project include: - Deep understanding of SEO best practices and...
I have an online database searching service and I'm looking to upgrade its current features and introduce some new ones. Key Features to Add: - Advanced Search Options: I'm interested in building on my current search function to offer more refined search capabilities. - Scraping: I'm looking to add a data scraping capability to my service. This will involve extracting data from various websites and integrating it into my existing database. - AI Data Analysis: I'd like to incorporate AI data analysis functionality into my service. Specifically, I'm interested in pattern recognition and data clustering. Other Enhancements: - Batch Searching: I need to implement a batch search functionality. - Additional Database Integration: I'm interested in ...
I need someone with specialized skills in password recovery to restore a forgotten password for an Outlook .pst files. I have an old *.pst file (outlook) from the year 2010. I put on password, and now I didnt remember, I need to find this password I m looking for somebody to find password for pst file
I need an expert to proofread a 200-page document intended for consulting in the Law Enforcement area of Public Safety. The task involves: - Correcting spelling and grammar, - Ensuring the logical flow and consistency of the narrative, - Checking alignment with charts, figures, tables, maps, and other visual aids. The ideal freelancer should have: - Exceptional English communication skills, - Strong attention to detail, - Experience in Law Enforcement or Public Safety consulting, - Familiarity with proofreading educational and research materials. This is a valuable opportunity to polish a crucial document that aids in developing efficient and effective public safety practices.
...transactions - Experience setting up advanced transaction security, especially with multi-signature wallets Additionally, I wish to integrate more than just Bitcoin in the future. To start with, Ethereum will be another cryptocurrency to support. Therefore, expertise in Ethereum transactions and familiarity with other cryptocurrencies will be a plus. Achieving top-notch security is fundamental for this task, hence preference will be given to developers with a proven record of secure checkout integrations....
I've got the UI/UX ready for my import-export services website, now I need an expert WordPress developer to bring it to life. The key features I'm looking for include: - E-commerce functionality: My website should be able to support th...that caters to import-export services, so experience in this area would be a plus. - Other functionalities that might be crucial and can be discussed with the freelancer include real-time shipment tracking, online payment gateway, and multilingual support. Ideal skills and experience for this project: - Proficiency in WordPress, including e-commerce plugins and themes. - Experience in creating websites with import-export services in mind. - Strong communication skills to understand and discuss further functionalities that might be requi...
I am looking for an expert to write a detailed review article on the BRPF1 gene, focusing on its role in disease development. The article should delve into the mechanisms and pathways through which this gene influences various diseases. The article is intended for research scientists, so it should be scientifically rigorous. Ideal Skills and Experience: - Advanced knowledge in genetics and molecular biology - Prior experience in writing scientific reviews - Ability to explain complex scientific concepts in a clear and concise manner - Understanding of disease mechanisms and the role of genes in disease development
...for a substantial 120-page research report. This summary should be designed to appeal to a business executive audience. Key Requirements: - Concise Overview: The executive summary should succinctly encapsulate the key findings and recommendations of the full report. - Balanced Detail: While the summary should be accessible to a general business audience, it should also include some technical details and analysis to provide a comprehensive understanding of the research. - Audience Focus: The primary audience for this summary is business executives. As such, the language and content should be tailored to their interests and priorities. Ideal Skills: - Proven experience in writing executive summaries or similar high-level business communications. - Strong research an...
We need a freelancer to carry out a simple task. It is about verifying that a shipment matches against a packing list. The Freelancer must go to the factory or warehouse where the shipment is located, count the products and take photos according to a manual that we will send; stay in the factory or warehouse until the containers are filled out and take pictures of the loading process according to the manual we would provide
I'm in search of ...seamlessly. The primary focus of the project is: - Building a new website: You will be responsible for developing a new website from scratch. Your ability to translate design concepts into a functional, high-performance website is crucial. Key Requirement: - Performance Optimization: I am particularly keen on ensuring the site is optimized for performance. Your understanding of strategies to enhance website speed and efficiency will be highly valuable. Ideal Skills and Experience: - Proven experience as a full-stack PHP Laravel developer - Strong background in front-end development - Excellent database management skills - Prior experience in building websites from the ground up - A keen eye for performance optimization, with a track record o...
The project requires you to send out 10 emails per hour for roughly 5 hours. You need to do research to find the correct email and personalize the email appropriately depending on who you are emailing. You will be given detailed instruction on how to do it. Rate is $0.35 per email. Potentially long term.
I'm looking for a proficient advertising expert to develop creative promotional materials for a specific product aimed at young adults aged between 18 and 35. • Task Details: - Develop engaging print materials: brochures, flyers etc. - Create enticing digital content: social media ads, banners etc. - Design compelling outdoor materials: billboards, signage etc. • Main Objective: - The main goal of this campaign is to promote a specific product. • Target Audience: - Young adults aged between 18 and 35. Ideal skills and experience for this task would include previous experience in marketing and ad creation, a strong understanding of the youth market, proficiency in graphic design, and experience in both print and digital advertising. Strong creative and...
I am seeking an ad designer to create compelling print magazine adve...visually captivating designs that align with my brand identity - Ability to research and understand the professional market segment - Crafting messages that effectively communicate the brand's values and mission Skills & Experience: - Proven track record in graphic design, specifically in print media - Strong portfolio showcasing brand-centric ad designs - Excellent grasp of marketing and how to appeal to the 25-45 professional demographic - Knowledge of print advertising standards and formats The successful freelancer will have experience creating ads that not only look great but also drive brand recognition. If you have a passion for print media and a keen understanding of brand positioning, I'...
I'm in urgent need of a professional who can change my photo background. Key requirements: - Background Change: The selected freelancer should be skilled in editing photos to replace my current background with a new one. - Timeliness: I need this task to be completed as soon as possible. Please note that I did not specify the type of background I want, giving you a free hand to suggest a fitting one. Your creativity and professional skills are highly valued.
As a fast-growing company, I need a professional well-versed in to streamline our boards and processes. This includes: - Establishing connections for our 'Leads', 'Scheduling', 'Patients', 'Reports', and 'Billing' boards. - Incorporating vital automations in our system such as task assignment, deadline triggers, document creation and reminder notifications. - Designing insightful dashboards namely, a Sales performance dashboard and a Financial dashboard. The ideal person for this job should have extensive experience and a proven track record in implementing and enhancing systems in monday.com. Their capabilities should extend to interpreting our company's needs into automated processes, and creating intuitive dashboards that ...
I'm searching for a specialist in HVAC who can edit my MEP drawings as per the markups mentioned. The tasks I'm highlighting are: - The revision of the equipment layout - Modification of our piping system The ideal freelancer should have an exceptional skill level of HVAC when it comes to detailing, as what I'm after are comprehensive layouts that also detail equipment sp...The ideal freelancer should have an exceptional skill level of HVAC when it comes to detailing, as what I'm after are comprehensive layouts that also detail equipment specifications. Proficiency in AutoCAD is a must for this project. I need someone who can deliver accurate, detailed work swiftly and efficiently. If you're an HVAC specialist with a deep understanding of this type of t...
I'm seeking an expert in AdSense approval to optimize my football-focused blog for monetization. Key tasks include: - Reviewing and fine-tuning the site to meet AdSense requirements. - Solving possible issues preventing AdSense approval. - Advising on ways to maintain approval. Ideal applicants should have proven experience in AdSense approval for information sharing sites, particularly sports blogs. Understanding of AdSense policies, SEO strategies and excellent communication skills are necessary. Knowledge of football is a plus. Overall, your role will be instrumental in ensuring the smooth operation and profitability of my blog, enhancing user experience while maximizing revenue. This will involve detailed insight and adept problem-solving - I look forward to working w...
I am in need of an experienced...informing potential customers. - It should have a user-friendly design that caters to the general public, ensuring easy navigation and seamless interaction. - Key features such as a contact form, image gallery showcasing my work, and an FAQ section should be incorporated. - The site should be optimized for search engines to ensure maximum visibility. Ideal Candidate: - Experience in developing websites, particularly for service-based businesses. - Familiarity with e-commerce platforms, as the website will serve as a point of contact for potential clients. - Knowledge of SEO principles and practices to ensure the website is easily discoverable by search engines. I own the domain so will have to use my domain which is currently with go daddy and one ...
I am in need of a capable virtual assistant who can adequately manage my calendar by scheduling personal events. Their core task will include the following: - Scheduling personal events: I often have a packed day, leading to the oversight of crucial personal events. I need someone attuned to my schedule and ready to help me manage my personal events. The ideal freelancer for this job would have: - Experience in calendar management: While this might seem basic, having someone experienced ensure maximum efficiency. - Good organizational skills: Managing multiple events requires a certain level of organization. Prior experience scheduling personal events will be a plus. Do keep in mind that this is not a typical virtual assistant role. I am looking for someone who takes initiative...
I am running an NGO focusing on healthcare initiatives and seeking an expert in grant writing who can help secure funds from international NGOs. Key Requirements: - I need someone with a solid background in grant writing specifically for healthcare initiatives. - The candidate should also have prior experience in securing funds from international NGOs. - A demonstrable track record of successful grant applications within the field of healthcare is highly desirable. The primary objective of this project is to secure funding for our healthcare initiatives through well-crafted grant applications that can convince international NGOs to support our cause. The ideal candidate should be able to draft compelling applications that emphasize the importance and impact of our healthc...
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.
...expertise in utilizing Facebook Ads to generate inbound calls. As a key member of our marketing team, you will be responsible for creating and managing Facebook advertising campaigns that drive targeted traffic and ultimately result in increased inbound calls. Responsibilities: Develop and execute Facebook advertising strategies to drive inbound calls and lead generation. Conduct thorough audience research to identify target demographics and interests. Create compelling ad creatives, including ad copy, images, and videos, that resonate with our target audience. Monitor and optimize ad performance, adjusting targeting, budgets, and creative elements as needed to maximize ROI. Collaborate with our sales and customer service teams to ensure seamless lead management and follow-up....
I'm looking for a professional who can enhance a 10-20 slide PowerPoint presentation for bu...looking for a professional who can enhance a 10-20 slide PowerPoint presentation for business purposes. The style should be corporate and visually engaging. Skills and experience required: - Expertise in PowerPoint design with a corporate style - Extensive experience in creating business-oriented presentations - Strong visual design skills: typography, layout, color selection, and more. Your task will include: - Designing and formatting each slide - Enhancing the presentation with appropriate visuals - Ensuring that the design conveys the message professionally and effectively. This project requires a quick turnaround, so your ability to work efficiently under tight deadlines wil...
I need help with my Google Chrome extension. I developed a JavaScript script that retrieves the content of a post and intends to insert . However, I am having difficulty with the process. The feature should apply to platforms like Facebook, Instagram, Twitter and LinkedIn. This should be a simple task.
I need a diligent individual to assist with meticulous data entry into less than 25 tables and slides. The data to be entered is a combination of text and numerical data which I will send. Ideal freelancer will have: - Proficiency in data entry...meticulous data entry into less than 25 tables and slides. The data to be entered is a combination of text and numerical data which I will send. Ideal freelancer will have: - Proficiency in data entry with strong attention to detail - Proficient use of PowerPoint Your primary task will be to enter data and headings into already-created table/slide templates. Typical table will have three columns and 3-5 rows. See attached examples. Successful completion of this task requires precision and accuracy to ensure the information...
Estamos procurando por profissionais de vendas para promover e vender nossos pacotes de internet de alta velocidade para clientes residenciais na região Sudeste. - Suas responsabilidades principais incluem promover e vender nossos serviços de banda larga, focando em clientes residenciais. - Os pacotes que você estará vendendo devem oferecer 400Mbps de velocidade de download, portanto, é importante que você compreenda e saiba comunicar sobre as especificidades dessa velocidade para os clientes em potencial. - Idealmente, você deve ter experiência prévia em vendas, especialmente no setor de telecomunicações ou tecnologia, o que seria altamente valorizado. - É necessário possuir excelentes habilidad...
I'm in need of an experienced US telemarketer for a cold calling market research campaign to gather feedback on Pool Service companies (business statistics, size, etc.) and software usage. Your tasks will include making calls, asking targeted questions, and gathering and reporting certain information in Google Sheets. Required: Availability from 9a-5p EST on 5/13 and 5/14, ability to make ~500 domestic calls from US cell phone/number. Key Responsibilities: - Conduct a series of cold calls to to pool service companies to collect data on their business statistics (size, etc.) and software usage (offering $USD incentive for participation) - Collect feedback on which specific Swimming Pool software they use, Net Promoter Score (NPS), Likelihood to Switch to ...
Project goal: Acquire high-quality editorial backlinks to improve the criminal law firm's search engine rankings and visibility. Target audience: Individuals seeking legal advice or representation in criminal law matters, particularly those using search engines to find reputable law firms. Scope of work: - Identify and target authoritative websites related to legal advice, criminal law, and justice for backlinking opportunities. - Negotiate and secure guest posting opportunities on high-domain authority sites. - Create compelling, informative content that incorporates backlinks to the law firm's website. - Monitor the performance of backlinks in terms of traffic and search engine rankings.
I'm in need of a skilled VFX paint artist who is proficient in Nuke. Your primary task will be the removal of large and intricate objects or blemishes from footage. Key Responsibilities: - Utilize Nuke to seamlessly remove large and intricate objects or blemishes from footage. Ideal Candidate: - Advanced proficiency in Nuke. - Demonstrable experience in VFX paint, particularly in the removal of large and intricate objects. - Strong attention to detail and ability to maintain image quality throughout the process. Please include relevant samples of your previous VFX paint work in your bid.
I need someone who can help assess the feasibility of my business idea, which is about starting a coliving space. This coliving space will have distinct design features, including: - Fully furnished rooms - Common areas for socializing - Fitness facilities - Coworking spaces - Startup Incubator Ideally, I'd want ...furnished rooms - Common areas for socializing - Fitness facilities - Coworking spaces - Startup Incubator Ideally, I'd want the space to have more than 20 rooms. I'd like the freelancer to smoke test the market. Knowledge in real estate, property management, and startup ecosystems will be beneficial. Also, someone with a background in designing or running coliving spaces is highly desirable. Your task would also be to help me detail a roadmap or busines...
...functioning the way they should, therefore need some enhancements to improve usability and the overall user experience. Ideal candidates should have a profound understanding of PHP, as the code is written in this language. Prior experience in working with web application optimization, user interface design, and functionality improvements would be beneficial. Please describe your approach to this task when posting your bid....
I need a freelancer to meticulously copy and paste data from PDF documents into a Word document. This is a simple data entry task but accuracy and attention to detail are crucial. Ideal Skills and Experience: - Strong proficiency in both PDF documents and Word documents - Excellent typing skills and attention to detail - Prior experience in data entry - Comfortable with repetitive tasks - Time management skills to ensure timely completion of the project
I'm seeking a skilled web developer to create a website for my company. The main objective of this project is to provide detailed information about our company and the services we provide. Ideal skills for this job: - Proficiency in web development languages such as PHP, JavaScript, HTML and CSS - Proficient in UX/UI Design - Experience in creating company websites Tasks: - Develop a clean and professional website from scratch - Implement a user-friendly interface that clearly outlines our company details and services - Ensure website is optimized for SEO. Your experience in creating accurate, informative and engaging corporate websites will be crucial to this project's success.
I'm looking for an experienced professional who can assist me with document retouching using Photoshop. The task primarily involves detailed text corrections in my business documents. The ideal candidate should have: - Proven expertise in Adobe Photoshop, particularly document retouching. - Keen eye for detail, primarily for text corrections. - Superior understanding of business documents' formatting standards.
I urgently need a skilled writer who has high proficiency in fixing a technical report. Due to skipped responses, the project will require a versatile freelancer who c...proficiency in fixing a technical report. Due to skipped responses, the project will require a versatile freelancer who can tackle different issues, especially: -Fix the report based on the feedback Though the specific purpose and audience of this report remain unspecified, the freelancer should be capable of handling diverse goals such as documenting research findings, presenting proposals, or providing technical analysis and recommendations. This task would be best suited for freelancers who can tailor their writing to various audiences, whether they be technical experts, non-technical stakeholders, or a ...
As the project manager, I am seeking an expert who can assist in cond...analysis, 3D modeling, and structural analysis and have knowledge of FOM, Sloshing etc. Your responsibilities will incorporate: - Analyzing the current design using CFD techniques - Identifying areas of improvement to enhance efficiency - Advising on appropriate design modifications A background in fluid dynamics coupled with an understanding of underwater equipment will be necessary for this task. Additionally, the potential to perceive potential issues before manufacturing will be a significant asset. Please ensure you've ample experience in the implementation of design changes based on CFD analysis results. With your expert assistance, I am looking forward to making equipment with enhanced operatio...
...background in web design and graphic design - Experience in creating logos - Solid understanding of website navigation and aesthetics Job Details: - You will need to create a streamlined and user-friendly website layout focusing on providing information about my business. - The website should include sections such as contact and location details, services, appointments, home page, and pricing. - As for the logo, it should be simple yet intriguing, able to convey the ethos of my business. - I will provide the content for the website. So, your main task would be focused more on the design aspect. In summary, it's about creating a visually appealing, easy-to-navigate website and a captivating logo. If you have a knack for creating professional, engaging digital platfor...
I require a professional freelancer with proficiency in handling graphic designs, specifically images, and adept in working with PDF files. Their task involves standardizing the size and format of my already existing images. Essential skills and experience required: - Proficient in PDF format - Proven record in image editing - Familiarity in standardizing image size and format - Attention to detail for ensuring consistency across all images. Please bid accordingly, taking into consideration the specific nature of this project.
...looking for a reliable freelancer who knows how to create custom WP designs. Read the requirements here and watch the video here. I'm searching for a skilled web developer to enhance a custom theme on my multi-APK website. The task involves creating unique design elements and improving the user interface of two specific pages: the home and download pages. Additional Information: - I've already attached the designs I want for the home page and download page. - The performance of the website should be maintained. - Experience in developing multi-APK websites and customizing themes will be highly advantageous. I need to replicate the design of the website to my website (Created using appyn theme). What I need is to redesign the home page and download...
Siamo un call center, cerchiamo un operatore telefonico madrelingua italiano da inserire nel nostro team di back office. Devi avere un computer (no smartphone o tablet), internet veloce, buone cuffie, spazio silenzioso dove lavorare. Conoscenza del computer e velocità di apprendimento. Offerta 4€/ora Se mi capisci fai bid da 10$ Inviate un cv per valutazione
I am looking for a highly experienced legal virtual assistant who'll he...mostly contract law, so a solid understanding of this area is paramount. Your Duties: - You will be entrusted with calendar management and appointment scheduling. - Conducting online legal research in the area of contract law is also expected. Requirements: - Proven experience assisting law firms, legal counsels or legal professionals. - Excellent familiarity with Video Conferencing Platforms as this is our primary means of communication. - Thorough understanding of contract law. A COMPREHENSIVE 3 STEP INTERVIEW SHALL BE CONDUCTED. PLEASE BID ONLY IF YOU HAVE EXTENSIVE EXPERIENCE AS A VA. Bids from skilled and diligent virtual assistants are welcome. Reliability and discretion are key to...
I'm in need of a Candid PNG Image of a Politician for social media purposes. The task details are as follows: A friend is running for the mayor's office in Focșani, Romania as a candidate. He has very slim chances, but I thought to ask for your help to create some nice banners for his Facebook/social media profile. foto of my friend is Name : Cristian Zîrnă atashed same slogas in file this is yours facebook link : Thanks all.
I require a skilled and experienced web developer to create a custom HTML emailer for me. The emailer should be compatible with both Outlook and Gmail. Here are the specifics of the project: - You will be provided with a JPG image that will form the basis of the emailer. Your task will be to incorporate a single line of hyperlinked text in the middle of this image. The hyperlink should lead to a designated URL. - The emailer should be designed to display correctly across different email clients, especially Outlook and Gmail. The ideal candidate for this project would have: - Proven experience with creating custom HTML emailers. - Proficiency in working with JPG images and integrating hyperlinks into them. - A good understanding of the unique constraints and requirements of emai...
I have a project that requires the migration of all product information from a Wix platform to a Shopify store. I have exported the data to an Excel CSV file which includes: - Product names and descriptions - Product images - Product prices - Product options and variants - Product skus Given the format, an Excel specialist with thorough experience in CSV file formatting would be particularly suited to this project. Experience with Shopify's product listing format will also be immensely valuable. The task at hand is to modify the CSV file accordingly so it's compatible with Shopify's import method. - Key Skills: Excel, CSV file formatting, Knowledge of Wix and Shopify's product data structure - Ideal Experience: Previous product data migration be...
I'm seeking an experienced image editor to enhance a photo of my house's front yard. The tasks include: - Removing selected trees and bushes: There are specific trees and bushes that I'd like to be removed in front of the main part of the house. I'm looking for a skilled editor who can competently handle this task without leaving any visible traces. - Removing cars from the driveway: The image includes cars parked in front of the house, which I'd like to have removed. This should be done in a way that doesn't leave any visible marks or changes in the driveway. - Adding a blue sky: The existing sky in the image is not visually appealing. I want to replace it with a vibrant blue sky to enhance the overall aesthetic of the photo. - Enhancing ove...
