The mssql database you are currently using is slow to search You want to improve the speed of this slow search speed.
...선택하면 그 날 주문한 상품의 이름,수량이 보였으면 합니다. 주문상세내용이 보였으면 합니다. 그리고, 원격 Database 접속정보와 관련된 쿼리는 아래와 같습니다. OS는 windows 2012 , 데이터베이스는 MS-sql이고, 원격주소, 계정, 암호는 실제 내용을 알려드릴 수 없는 점 양해바랍니다. 현재 디비접속은 이런 형식으로 하고 있습니다. -> ,1000 (사이트주소,포트번호) , 계정 : Testaccount , 암호 : Test 입니다. 금액 쿼리 : Select replace(convert(varchar, cast(Isnull(Sum(Ori_price*qty),0) as money),1),'.00','') as Orderamt from Orderdetail where Convert(Varchar(8), Order_date,112) = '달력 일자' and DelYN='N' 금액은 붉은 색 글씨로 표시되었으면 합니다. 주문 건수 : Select count(Order_id) from Orders where Convert(Varchar(8), Order_date,112) = '달력 일자' and DelYN='N' 미배송 건수 : Select count(Order_id) from Orders where Convert(Varchar(8), Order_date,112) = '달...
...freelancer to quickly customize an admin UI template for our project. The template has already been installed on the server and customization has already begun, we just need help finalizing the designs for the remaining pages. The template needs to be modified to match our design requirements which will be provided to you upon request. The ideal candidate should have experience in UI customization and be proficient in HTML, CSS, and JavaScript. PHP experience is a PLUS since the entire site is programmed in PHP using a custom framework. Attention to detail and the ability to work efficiently are essential. The main tasks include using existing template elements to create and design the needed pages for our back office or using your de...
...sample it has the word All things. Replace that word with JMR This logo should ideally convey the core values of professionalism and trustworthiness we stand for. I have not decided on specific colors yet and I am open to creative suggestions from the designer to come up with the perfect color scheme that enhances the brand identity. Ideally we wanted elegant emerald green or elegant royal blue or Gold The ideal designer for this project: - Should have a portfolio demonstrating a knack for creative logo designs - Must be proficient in major graphic design software - Has a detailed understanding of color psychology in branding - Understands the delicateness and impact of typeface selection In your proposal, kindly share your previous relevant work ...
...with editing the search module of my website. The primary focus of this project is on modifying the way images are retrieved then displayed in the search results. Key Requirements: - Modify the retrieval of images in the search results to use URLs for specific sizes as opposed to the current methodology of storing images locally and then displaying. - No specific enhancements are needed for the image thumbnails, just an adjustment in the retrieval and subsequent display methodology. Ideal Skills: - Proficiency in PHP and MySQL - Experience with implementing search modules in web development - Familiarity with retrieving and displaying images in various sizes - Strong problem-solving abilities to modify existing code It's c...
...sales brochure that is mobile-friendly and primarily includes text and images. The brochure that I’ve attached is for heated driveways. The new brochure needs to be about standard concrete driveways, no heating systems. You can get all the text and images from our driveway page: ** I will only interact with contestants that use the phase “ Colorado Springs’ Best Driveway Contractor” in the subject line The main goal is to educate the customer on the entire process from start to finish including all the materials and methods that make our driveways better than anyone else’s. The objective of the brochure is to be distributed via email and text, so it needs to be designed with
Since the error message isn't displaying after Yoast SEO plugin update, the verification process is incomplete. I'm looking for a freelancer with t...issue: Identify why the error message isn't displaying, even after the update. - Resolve the issue: Implement a solution that will allow for successful verification with Google Search Console. - Test and validate: Ensure the verification process is successful and that the error message is correctly displaying. Ideal Candidate: - Experience with Yoast SEO plugin: Proven track record of working with Yoast SEO and fixing similar issues. - Proficient in Google Search Console: Understanding of how Google Search Console works and how to verify a website. - Problem-solving skills: Abil...
I'm in need of a fast and efficient Photoshop expert to remove the background from 1 image and replace it with a solid color background. The priority for this project is speed of delivery. I understand the usual need for precision in the edges around the subject, but in this case, speed is of the essence. Required skills and experience: - Proficiency in Photoshop, particularly in background removal and replacing with solid color backgrounds. - Prior experience in delivering similar projects quickly and efficiently.
I require comprehensive as-built drawings for a small residential building that needs to undergo renovation. The scope is to cover the entire building, with an emphasis on structural details, floor plan and elevation. - The primary purpose of these drawings is to facilitate architect to get a proper dimensional plan of the building as it is along with heights i have a laser device for measurement if that helps and the location of the task is in Navi Mumbai structure is about 1600 square feet x ground + 2 floors
HRM Modules: This application allows representing the relationships between employees, the groups they belong to, and the training they have attended. 1. "Employee": They are characterized by: name: The employee's last name. first_name: The employee's first name. date_of_birth: The employee's date of birth. position: The position held by the employee. establishment: The establishment where the employee works. hire_date: The date the employee was hired. contract_type: The type of contract. seniority: The seniority. 2. "Group": They are characterized by: group_name: The name of the group. group_selection_criteria: The selection criteria of the group. 3. "Training": Each training is characterized by: name: The name of the training. descrip...
Google Search Ads Cold Traffic Analysis - Select best countries and why - budget requiremetns - KPIs to follow
...involves migrating a medium-sized database (between 1GB and 10GB) to Oracle, and optimizing its performance. The database schema will also need to be designed, as this is not yet finalized. Key responsibilities include: - Migrating existing data: I need an expert who can handle this without losing any data or causing downtime. - Performance optimization: Once the data is migrated, the database needs to be optimized for speed and efficiency. - Designing the database schema: Your ability to design a schema that aligns with our business goals is critical for this project’s success. Ideal candidates should have extensive experience in Oracle database development, with a focus on data migration and performance optimizatio...
I have an image that needs the person in the background removed. I'd like to replace it with the same wall of the room. Once that's done, I need the edited image saved in JPEG format. Key requirements: - Background removal: You'll be tasked with cutting out the existing background person in the image. - Save in JPEG: The final output should be saved in JPEG format. The ideal freelancer for this project is someone with: - Strong skills in Photoshop - Experience in background removal and image editing - An eye for detail - Ability to follow instructions precisely Please include previous work examples in your bid.
I will create and enable "Custom Search Feature" in Google Adsense.
I'm looking to improve search engine rankings for my website from Quora, specifically focusing on technical topics. Key Requirements: - Promoting technical content: The answers should be SEO-optimized for technical topics, with relevant keywords and phrases. - Linking to my website: The answers should also include links to my website for more information, without appearing spammy or overly promotional. -Most Searched Questions About Dry Fruits Ideal Freelancer: - Experience in Quora SEO: I need someone who knows how to optimize Quora content for search engines effectively. - Technical background: A background or strong understanding of technical topics will be a big plus for this project. - SEO expertise: Knowledge of SEO best practices and experience wit...
I seek for 20 CAD for the entire project which will be delivered in an hour upon receiving files.
I'm in need of a skilled PHP developer to implement a table filtering and search feature on an HTML table. - The search functionality is to be based on name, facilitating instant search results as the user types. Ideal candidate should have: - Proficiency in PHP and HTML - Experience with implementing search features on HTML tables - Understanding of optimizing search functionalities for large data sets.
... and extract all the short abbreviations inner in (....) from entire document(with PDF,...extensions). The report/result will like this table with 2 columns: sentence | terms-founded | string of terms | check-selection | button "do-it" Then I will select the terms by checking and then I will press the button "do-it" and the selected terms founded between (...) will be savet into MysQl Table. So for Document-URL: this is simple example of line from this report -sentence: "With the deployment of the fifth generation (5G) mobile network systems and the envisioned heterogeneous
...developer to create a captivating word search game for mobile platforms, specifically iOS and Android. This game is intended to be highly detailed and animated, so experience with creating visually engaging mobile games is a huge plus. Key Requirements: - Development for Mobile Platforms: The game should be compatible with both iOS and Android, ensuring a wide audience reach. - Visual Excellence: The game is expected to have highly detailed and animated graphics. A strong portfolio showcasing similar work would be highly beneficial. Optional Requirements: - Social Features: While I'm open to the idea of incorporating social features within the game such as leaderboards, player profiles, or in-game chat, this is not a strict requirement. Ideal...
I require a...Calendar's API as a consultant to help us resolve issues with adding attendees to events and having the events show on the customer's calendars. Key Issues: - Replace Google's standard email to Customer about adding the event to their calendar with our own customized template. - Help us understand different approaches to synchronization to customer events - Best approaches to handling recurring events that have multiple days, different times on different days, and numerous exceptions Ideal Skills and Experience: - Extensive experience with the Google Calendar API. - Strong understanding of event creation and management. Importantly, we are counting on your expertise for this task - ensuring seamless integration and...
I have an Oracle database configured with WE8ISO8859P1 character set (call it DB1). The database needs to be updated to character set WE8MSWIN1252. I need to preserve the DB1 database, so I've created a new database with WE8MSWIN1252 (call it DB2). I would like someone to do this for me: 1. Export entire DB1 including data 2. Import the DB1 export into DB2 Communication and control will be done with Zoom
I am in need...Access specialist to create a straightforward database. The main aim of this project is the production of a simple database with a focus on data reporting. Key Points: - The database is intended for data reporting purposes. - There will be 1-5 different types of data entries (tables) in this database. - The final database should be equipped for generating various types of reports from the data it contains. - I am looking for a freelancer who can also document the database effectively. Ideal Skills and Experience: - Experience in designing and building Microsoft Access databases, specifically with a focus on reporting. - Strong knowledge of structuring databases for efficient reporting. - Ability to provide clear a...
...representing KB Institute, and we are keen on collaborating with an experienced professional like you to develop a comprehensive Course on Computer Concepts (CCC) from scratch in Hindi. This course is intended for beginners who wish to grasp computing fundamentals. Course Overview: The CCC course aims to thoroughly understand computer concepts across three levels: Basic, Intermediate, and Advanced. The course structure will cover the following key topics: - Introduction to Computing: Basics of computers and their applications. - Operating Systems: Understanding different OS functionalities. - Word Processing: Essential skills in word processing software. - Spreadsheet Software: Data management and analysis using spreadsheets. - Presentation Software: Creat...
Please read the entire description carefully. I'm looking for people who can follow instructions. I'm in need of a virtual assistant who's fluent in Mandarin to assist with managing my properties. Key Responsibilities: - Coordinating viewings: You'll be responsible for coordinating property viewings. This includes scheduling appointments and providing property details to interested parties. Ideal Skills: - Fluent in Mandarin and English: You need to be able to communicate fluently in both languages to effectively coordinate viewings and communicate with interested parties. - Property Management Experience: Experience in the property management sector would be beneficial but not essential. - Organized and detail-oriented: You'...
Current project is built on Laravel for both front and backend. Need to build React frontend to replace Laravel frontend side. All the pages inside current pages should be moved to React with new template UI and all same functionalities. Main Laravel frontend back end Login this saas/superadmin version (include All modules) USE THIS Admin TEMPLATE FOR Frontend Current system making this stacks - Laravel, MySQL, VueJS, JQuery & Bootstrap, DOCUMENTATION API DOC
...engaging and visually appealing banners and ad sets for my Web3 project. The main aim of this project is to drive traffic to my website. Key Requirements: - The banners and ads will be used across various platforms, including social media, search engines, and partner websites. Hence, they should be tailored to suit these different platforms. - The target audience for this project is primarily between the ages of 18-44, so the designs should be attractive and relevant to this demographic. Ideal Skills and Experience: - Previous experience in creating web banners and ads, particularly for diverse platforms and audiences. - A good understanding of Web3 projects and the ability to design with the aim of driving website ...
...labels for my medical items. These labels will be for medium-sized packaging, and they do not need to be waterproof. Key Requirements: - Create visually appealing and professional product packaging labels - Prior experience in designing product labels, especially for medical items, is a plus - Ability to deliver high-quality, print-ready designs in a timely manner - Understanding of SFDA regulations for medical product labels is preferred - Experience with medium-sized packaging is important The ideal freelancer for this project should have a strong portfolio of label design work and should be able to demonstrate their understanding of the nuances of designing for medical items. A meticulous attention to detail and the ability to work within given dimensio...
I'm in urgent need of an AWS expert to deploy my entire SaaS application. Key requirements: - Deployment of the entire SaaS application, utilizing key AWS services such as EC2 instances, S3 storage, and Lambda functions. Ideal Skills and Experience: - Proficiency in AWS services and deployment strategies. - Experience with SaaS application deployment. - Ability to work under tight deadlines.
I'm in search of a Shopify expert, proficient in troubleshooting and SEO. Currently, I'm facing an issue where some of my products aren't appearing on Google despite optimizing my website. I'm not using any SEO plugins on my Shopify site and I manually enter product details, so I need a professional who can provide a solution to this issue and help boost my product visibility on Google. Key Responsibilities: - Troubleshoot and identify the root cause of the products not appearing in Google search results - Implement solutions to improve product visibility on Google - Provide expert guidance on SEO best practices for Shopify store Skills and Experience: - Extensive experience with Shopify troubleshooting - Proficient i...
You will need to visit and search for the following categories. Drainage Glazing repair Appliance repair Plumber Electrician Roofer Use the postcode W2 4DP After you have the search results You will need to open a google sheet and have the following categories Name of Business Website (you will need to find this either from checkatrade or google if you use google do not put LTD on the end) Companies house link for each business use this link The task is to complete 500 companies - please bid knowing this and only bid if you read the brief and understand it
...property search portal with Andriod and IOS mobile application / Apps. Website similar to property portal. Using laravel flexhome to customize IOS and Android application will be associated with the website. The project entails creating a seamless user experience, allowing individuals to search for real estate properties across different sectors - residential, commercial, and industrial. Below are some key requirements: - **Advanced Search Filters:** The portal should offer users advanced search filters, facilitating precise property searches. This may involve filters based on price range, location, property type, and more. - **Property Listings:** It's important for the site to have a large database of propert...
I have a STEP file of a PCB that includes submodels of various components. Each submodel is named by the component, e.g., resistor 0402. I need someone experienced to identify and accurately place components (e.g., resistors) in the STEP file. Attention to detail and precision are crucial for this job. Start comment with fustion3
...create a website where parents can enter their child’s name, and the name will be automatically integrated into a pre-recorded audio story. The child’s name will be generated using Text-to-Speech (TTS) technology and merged with the main audio file. Scope of Work: Setup and Configuration: Install and configure WordPress on a suitable hosting platform. Ensure the environment is secure and optimized for performance. Frontend Development: Create a user-friendly form for parents to input their child’s name and provide consent. Ensure the form is responsive and works seamlessly across different devices and browsers. Backend Development: Develop a custom WordPress plugin to handle form submissions, ge...
I'm in need of a skilled digital marketing professional who can significantly increase the Domain Authority of my B2B website. This project is crucial as it's directly linked to my overall SEO strategy and online visibility. Key Goals: - Improve the search engine rankings of my website - Increase organic traffic to the site - Enhance the online visibility of my brand Ideal candidate: - Extensive experience in digital marketing, particularly in boosting domain authority - A proven track record of improving search engine rankings and increasing organic traffic - Demonstrable expertise in enhancing brand visibility through effective online strategies Your proposal should focus on your relevant experience, particularly on how you plan to approach this p...
I am looking...old site has performance issues and loads quite slow. There for we have decided to switch from OpenCart to Bagisto store. Responsibilities: - The template needs to match our existing site at least at around 90% ! - No perfection issues at our side - Accepting improvement ideas - There is no need to made it ready for Bagisto, our need is only the CSS and base HTML with dummy content. - Duplicate an existing website to stand alone TailwindCSS template. - Ensure the template is Responsive as our main target is mobiles but desktop as well. - Implement few dummy pages: Homepage, Category, Product, Search, Login / Account. Required Skills and Experience: - Expertise in TailwindCSS, HTML, JavaScript - Experience with website templates - Ability to work...
I'm seeking a proficient front-end HTML developer to manage an entire website development project. The ideal candidate should have expertise in: - Front-end Development: You should have a solid grasp of HTML and be able to craft responsive designs. - Frameworks and Libraries: Familiarity with Bootstrap, jQuery, and React is essential, as these will be used in the project. - Site Implementation: The successful candidate will be responsible for overseeing the complete implementation of the site. You should be able to translate design mockups into fully functional websites, ensuring smooth navigation, cross-browser compatibility, and responsive design. A keen eye for detail and a strong work ethic are crucial for this role.
I'm currently experiencing database connection errors on my Wordpress website. Key Requirements: - Fix database connection errors causing website load problems - Ensure the website is running smoothly and all features are fully functional - Full access to the website's hosting account and database for troubleshooting - Clear and timely communication using instant messaging for updates and feedback Ideal Skills and Experience: - Proven experience in resolving database connection errors on Wordpress websites - Strong understanding of database management and troubleshooting in Wordpress - Excellent problem-solving skills and ability to work efficiently - Previous experience in instant messaging f...
...portal for me. The portal should incorporate the following features: - I also want learn this - A job search and filtering module, allowing job seekers to find suitable positions. - An option for resume submission, where job seekers can upload their CVs for potential employers to view. - A company profile section to provide a brief about various potential employers. Within the platform, we'll have two distinct roles: job seekers and an admin role. The admin should have extended access and capabilities to manage all activities on the portal. The layout and design should resonate with a professional and corporate feel reflecting our business nature. We favor a design that is neat, clean, and intuitive. Freelancer Qualifications: ...
I have a photograph that needs a specialist touch. The primary task will include: - Removing the shadow from my face to achieve a more natural look. The project doesn't specify any particular area of focus so a balanced approach to the entire face would be appreciated. Ideal candidates will have a robust understanding of photo editing, specifically shadow reduction, and are mindful of preserving the photo's natural appearance. Proficiency in various photo editing software and an eye for detail are essential.
...money into the business as we build. Key Tasks: - Create and manage Google Search Ads: Your primary focus will be on this platform as we aim to attract a national audience to our site. - Optimize for Conversions: We need you to not just bring traffic but also to help us convert these visitors into customers. Your Expertise: - Proven Experience: I'm looking for someone with a track record of success with Google Ads, specifically in driving sales. - Understanding of E-commerce: It's important that you understand how to bring potential customers to our site and convert them. - National Targeting: You should be familiar with targeting a national audience and making sure our ads reach the right people. If you think you fit the bill and can hel...
I need a developer proficient in and a good understanding in API development. I have a parameter I would like to pass which is a string value to pull an entire user object with all of the properties in a database. this would be a string parameter passed into a Get request with a response of an entire record pulled from a MySQL database and using an Interface to extract the properties into a page. This is a very small project and should only take a few minutes of time.
I'm looking for a professional Flask and Python developer to help me implement a user management system for my website. The user management system should have Social Media login integration. Additionally, I would like the selected developer to set up a payment gateway and a MySQL database. Ideal Skills: - Proficient in Flask and Python - Experience in implementing user management systems with social media login integration - Proficient in setting up payment gateways - Proficient in working with MySQL databases
I'm in search of a WordPress developer with experience in WP Bakery to provide design modifications and content updates to my existing website. - The primary focus will be on the Header, Footer, Homepage, and Inner pages. The ideal candidate should have a keen eye for design and be able to enhance the visual appeal of these sections, while ensuring a consistent look and feel across the entire site. - Additionally, I will require text and image updates to be made. This will involve updating existing content to keep the site fresh and engaging for visitors. The task will also include ensuring that all updated content is well-integrated with the design changes. I'm looking for a developer who can work efficiently, pay atte...
I've attached two drawings which is what I would like professionally replicated so I can eventually print across say 3 x A3 sheets and display on an easel. I have attached a photo of what the old building looks like which is what one of these two drawings will replace.
[NO AUTO GENERATED APPLICATIONS… WILL BE DELETED] I need someone familiar with affiliate marketing programs and sites. Someone that can find me some good affiliate products for me to ask. Tell me some good affiliate products into Instagram. You will search programs like Clickbank, Amazon, etc. In your application tell me about some products that you have found for clients. Have you ever sold affiliate products through Instagram?
I am in need of a technophile with expertise in Microsoft Access databases. Your task will involve: - Populating my database with customer data which includes names, addresses, phone numbers, organisation affiliations, and details of last interactions. - Inputting sales transactions data which include dates, product names, and prices. The ideal freelancer should demonstrate an adept understanding of database management, particularly Microsoft Access, and be able to accurately input data with keen attention to details. Efficiency, accuracy and attention to detail will be paramount for this project.
The search feature for addresses on our website, powered by Google Maps, is currently not functioning as expected. We are seeking a skilled developer to diagnose and resolve this issue promptly. Key Responsibilities: - Investigate the cause of the search address malfunction, and rectify it accordingly. - Thoroughly test the search feature to ensure it is functioning as intended across various browsers and devices. Ideal Skills and Experience: - Proficiency in JavaScript, particularly with Google Maps API. - Experience in debugging and troubleshooting web applications. - Strong understanding of web development and browser compatibility issues. Please note: The user did not provide information on the browser used, changes to ...
...drizzle in a photo to a sauce. The edited photo should look as realistic as possible. Here are the key points: - Replace Drizzle with Sauce: The main task is to replace the drizzle in the original photo with a sauce(the organge color). The sauce should blend seamlessly with the rest of the image, making it hard to discern the editing. The end result should look as if it was the original intention of the photo. - Realism: The level of editing required in this project is photo-realistic. The sauce should not only look like a sauce but should also appear as if it belongs in the original image. - Attention to Detail: I am looking for someone who can pay close attention to details and ensure that the edited photo is of high quality, with no visible signs of manipulati...
...logos: T-Shirt Logo: Designed for the upper chest of a black muscle t-shirt, this logo should be bold and visually engaging, reflecting our role in the tech-driven service sector. Hat Logo: Intended for a flat brim black baseball hat, this logo needs to be sleek and easily recognizable. Design Specifications: Style: Contemporary with a hint of industrial design. Color Scheme: Predominantly dark with neon or metallic accents. Visual Elements: Should reference tools or digital elements like a spreadsheet. Typography: Bold, modern typeface. Judging Criteria: Creativity and uniqueness. Alignment with the design brief. Visual and practical appeal for merchandise. T-Shirt: Design a compact and vibrant logo for 'Quote Quest' that fits entir...
I have a 5,000-word article that needs to be urgently (24 hours) formatted according to APA 7th guidelines. The syntax, wording, and spelling also need to be checked. The primary requirements are: - In-text citations - Reference list - Page layout conformance with APA 7th rules The specific sections of the article that require special formatting are: - Title page - Abstract - Introduction - Method - Results - Discussion - Conclusion - References The entire document needs to be formatted according to APA 7th rules. Please note that the preferred font style is Times New Roman.
