The mssql database you are currently using is slow to search You want to improve the speed of this slow search speed.
...주문내용(총금액, 건수, 미배송건수)을 보여주려 합니다. Eclipse 소스를 원합니다. 달력은 월별로 이동이 되어야 하고, 현재일자는 배경색을 달리해서 표시가 되어야 합니다. 주문이 없는 날은 표시가 안 되면 됩니다. 일자를 선택하면 그 날 주문한 상품의 이름,수량이 보였으면 합니다. 주문상세내용이 보였으면 합니다. 그리고, 원격 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=...
...evaluations and a significant volume of personal data will be furnished, necessitating strict adherence to medical documentation protocols. It is crucial to independently assess the evidence provided to mitigate potential biases from prior MRO reports and offer an additional expert viewpoint. Content Pieces: 1. Simplifying toxicology for a lay audience and the media. 2. Incorporating new information beyond the court-mandated disclosure for anticipated outcomes. An extensive MRO analysis has been executed to establish innocence, involving LC-MS-MS and GC-MS-MS tests on blood and urine promptly post-incident, arranged through and the bright side clinic collection site, yielding a negative result. Additionally, a hair follicle test was conducted on day 50, wi...
Hello, I want someone good with compiler construction subjects Like creating a parser for a language You can find the project file from attachment you can find readme file in there explaining the project and task You would utlize the scanner that is in src/scanner, and build the parser in , which is the starting file you can also find it in the src folder The goal is to build the parser and pass all test cases Please read and check before bid
We need someone reliable and trustworthy to help us store and ship our clothes. As our Clothing Storage and Shipping Assistant, yo...a postal service is ideal). Each shipment will be compensated separately. Your payment will be determined by agreement: a monthly fee for storage + a fee for each shipping service (or as mutually agreed upon). This is an excellent opportunity for someone with extra space who is willing to provide storage and shipping service. Please note, that storage and shipping service would be required until all 19 sets would be shipped. Location: Vancouver or around Vancouver only Skills needed: - Must be reliable and trustworthy - Good at organizing - Pay attention to details - Excellent communication skills Size: Small Duration: Up to 4 month...
I'm seeking a tester to evaluate our PHP Laravel website. Your responsibilities will include both manual and automated testing. Manual Testing: - Focus on Functionality, Usability & Compatibility: I need the tester to pay particular attention to these aspects of the website. - Test Case Creation: You will be required to create test cases for the website as they are currently unavailable. By doing so, you will essentially be putting yourself in the shoes of our users and assessing the website's strengths and weaknesses. Automated Testing: - Browser Compatibility: I need the website to be compatible with three major browsers (Chrome, Firefox, Safari) and require you to automate this testing. Ideal Candidate: - Proficient in PHP and Laravel: You shoul...
...created for the Brisbane area. - **File Format**: The directory should be in Excel (.xlsx) and easily editable. - **Data Required**: The spreadsheet should include Business Name, Address, Phone Number, Email (if available), and any other relevant contact details. - **Usage**: I'll be using this directory for sales lead generation, so it's crucial that all the information is up-to-date and well-organized. - **Categorization**: The businesses should be categorized by specific industry (e.g., Hospitality, Retail) to help with targeted marketing efforts. I would like this done for the retail/hospitality e.g. butchers, newsagents, cafes, and convenience stores. We are not targeting large chains or franchisees. **Ideal Freelancer**: - **Excel Expert*...
...is a tampered or real one. There are chances like in the computer generated bill some people can change the amount, name, address sections and submit. This model should able to detect all those tampered PDFs with minimum false positives. Do metadata analysis QR code reading in the receipt and validation Key Responsibilities: - Develop a fraud detection algorithm using Python. - Test and tune the model for maximum accuracy. Ideal Experience and Skills: - Proficient in Python programming. - Proven experience in creating algorithms, preferably in fraud detection. - Ability to demonstrate relevant past work. Applications without showcasing relevant past work will not be considered. I encourage you to include detailed descriptions of previous projects, highlighting how y...
I'm seeking a killer videographer capable of compiling short, engaging videos for my social media platforms, which include TikTok, Facebook, Instagram, and YouTube shorts. A key part of your role would involve scrapping relevant content from various social media channels in New Zealand. This content should end up with massive reach and engagement and range from accidents, spills, bungy-jumps, jetboat fun, and people having fun. In all occasions we should advise the content creator we are using the content as we do NOT want a META ban. The perfect candidate would have the proficiency to go through other sites, get tge content, and turn this scraped content and data into compelling 5,10 15 to 20-second infographics animations that are news worthy, informational. You shoul...
I'm searching for a highly skilled developer well-versed in Ninja Trader platform to create a scalping strategy addon. This project will focus specifically on Futures. Here's what you'd need to make this successful: * Solid understanding and experience with Ninja Trader * Ability to develop automated trading strategies * Familiarity or previous experience with scalping strategies * Deep knowledge of Futures market. Aside from development, I will need you to test it to ensure it's functionally effective and free of bugs. This endeavor entails: * Implementing Scalping strategy effectively * Ensuring strategy functions correctly and without failure * Rendering a scalable and efficient solution. As well as a detailed report on how to use it. Demonstrated ...
Storecheckers are a Global Ma...well-presented, as you will be representing us during the audit. As an auditor, you will arrive at the test center an hour before the start of the exam, give your ID, show a letter of authorisation, which we will provide for you beforehand, and tell them what you are there to do. You will then sit with the TCA or the manager and ask a series of questions, and ask to see various things. The audit itself is very simple and easy, as we give you the form and you only have to ask the TCA/manager all the questions exactly as they are written and take a few pictures. The fee is $125 for the visit, which lasts four hours in total. Note that you will need a valid, photo and signature bearing ID for this visit. If you are interested, ful...
...subscription tracking, member services management, and trade references. The system should facilitate data import from Excel and accommodate online and offline accessibility based on the user’s capacity to meet online hosting costs. Member Registration: Develop a module for member registration capturing key details such as Name, address, and any other contact information. Village, group, area, district, province, sub-group affiliation (e.g., Study circle, VSLA, commodity association etc.) Demographic information (age, gender, household size, etc.) Implement functionality to adapt and import member data from Excel sheets. Enable different access levels (Project team, Donors and trading partners) for viewing, analysis and with rights editing member pro...
I'm on the lookout for a skilled fashion designer fron NIFT who specializes in women's wear, ideally someone with a flair for casual styles. Your material of choice should primarily be cotton. Skills and Experience: - Ability to design trendy women's casual wear - Expertise in working with cotton fabric - NIFT graduates preferred Your tasks will span from conceptualizing design ideas to creating stylish and wearable casual pieces for today's discerning women. Not just aesthetically pleasing, these designs should be comfortable and practical as well. This is an exciting opportunity to put your creativity to test and explore the endless possibilities within the realm of casual women's wear.
...functionality of the contract is to facilitate fund transfers and sharing. Ideal Skills and Experience: - Solid experience in Ethereum smart contract development - Expertise in Solidity and libraries - Familiarity with test networks I need to create a smart contract and wallet connection using metamask. Here's an example; On this link, they only can donate using a credit card or debit card. I want to pay with eth test network (using metamask) and the smart-contract is; Person A needs 2000ETH for their project with a deadline of 30 days and share the profit 10% after 10 days of the project to reach the goal of each ETH donated by another person, Person B donate 1000ETH Person C donate 1000ETH The project reached the goal
I'm seeking a talented machine learning e...within Protein-Protein Interaction networks. Key Requirements: - No Data Availability: You will be responsible for sourcing a suitable dataset for this project. The dataset should be substantial, relevant to healthcare, and appropriate for predictive analysis. - Designing, Implementing and Evaluating a Strategy. - Evaluation of the Model - Making predictions on a New Test Set Ideal Candidate: - Strong Machine Learning Skills: You should have a proven track record in creating predictive analysis models. - Healthcare Industry Knowledge: Little experience in working with healthcare datasets would be a significant advantage. - Data Sourcing Ability: Being able to identify and access appropriate da...
I'm seeking a proficient individual to help with a data entry project. I have about 40 URLs, from which I need to extract the product names, prices, and descriptions. The goal is to collate this information in a pre-defined Excel template. Key Aspects: - Extract product names, prices and descriptions from 40 URLs. - Populate an Excel file with the gathered data.
...The tasks at hand are primarily data entry, table creation in Excel and development of an instruction manual in Word. Key Responsibilities: - Efficiently perform data entry tasks in Excel. - Create tables in Excel to visually present the data. - Develop an instruction manual in Word. Ideal skills for this project include: - Advanced proficiency in Microsoft Excel, with a strong expertise in data entry and structuring information. - Proficiency in creating tables, and potentially pivot tables. - Strong experience in creating documents in Word, preferably instructional or informative content. - Attention to detail, as accurate data entry is vital. - Strong communication skills to understand the specific requirements...
...approximately 200 trial products, with the possibility of more work in the future. I offer a payment rate of $0.5 per correctly published article. The ideal candidate for this project would have: - Proficiency in Spanish language. - Experience with the Wix platform. - Attention to detail in product specifications. Your responsibilities will include, but not be limited to: - Uploading product details, specifically including size and material. - Attaching corresponding images for each product as per requirement. Please make sure all information is accurate before publication to avoid misunderstandings. Previous experience in data entry, especially related to clothing, is preferred. Your ability to ensure the successful execution of product uploads to my o...
I need a Python expert to create a robust parser for extracting data from large JSON files, each exceeding 10 MB. Key Requirements: - Comprehensive knowledge of Python - Strong grasp of JSON data structures - Experience in handling and processing large data files - Familiarity with data extraction techniques The parser should be highly efficient and capable of managing substantial JSON files seamlessly, without compromising on the speed of execution. I value your expert advice on the most suitable Python libraries to use for optimal results.
I'm in need of a virtual assistant to help with a variety of tasks, specifically: data entry, email management, and conducting research. Ideal Skills and Experience: - Proficient in Google Docs and Sheets - Experience in managing email inbox - Can attend video calls and meeting to write MOM with clients I'm looking for someone who can commit to more than 20 hours per week. The ideal candidate should have a basic understanding of Excel or Google Sheets. Your job will be to document data, answer emails effectively, and conduct research on various topics. I am looking for someone who is timely, organized, and detail-oriented. Please reach out if you think you are a good fit for this role.
...profile, e.g. with photo, location, nickname. Registration via email + password must be confirmed via double opt-in. The app should be able to access the device's contact lists. Now the user can create a new thread. In this he enters the following information: - Message part 1 (public) - Message part 2 (not public) - Recipient - Date The recipient (from the existing contacts, or an individual entry, e.g. telephone number or email) then receives a message via internal private messaging (if the recipient is also logged in to the app), SMS or, if known, via email. If the notification is sent via email, it will be as follows: --- START OF THE MAIL --- You have received a new message from XY, you cannot open the second part of the message until {date}. {personal message p...
Hello potential freelancers. I'm in need of a proficient typist to enter data from an unspecified source. The source material could be handwritten notes, printed documents, or scanned images. Regardless, you should be able to decipher and accurately input information. Skills and attributes: - Exceptional typing speed - Attention to detail - Experience with data entry - Ability to work with unstated source material In your application, please include your experience relating to this task, past work if available, and a detailed project proposal. The number of pages or documents that need to be typed is not specified yet. However, your application should be flexible to handle any range - less than 10, between 10-50, or even more than 50 pages. Looking fo...
In this project, I'm needing assistance to extract text data from printed documents and entering it into Google Sheets. This task involves meticulous attention to detail to ensure the accuracy of the data entered. The project requires a freelancer with strong data entry skills and the following qualifications: - Proficient in Google Sheets and Microsoft Excel - Excellent typing speed - Previous experience with data extraction - Ability to work with printed documents - Good at data categorization and organization - Proven track record of accuracy - Strong attention to detail If you have these skills, please bid for this project. Thanks in advance for your time and effort.
As a business owner with a Shopify store, I require an experienced professional to help me with product listing. I have 5000 physical products that I need to be added to my store. Key Responsibilities: - Inputting product details such as title, price, and description - Uploading high-quality images for each product - Ensuring that all data is accurate and consistent Ideal Skills and Experience: - Prior experience with Shopify product listings - Familiarity with product data entry - Attention to detail to ensure accuracy - Ability to work with a large volume of products Please let me know your experience with similar projects and how you plan to manage the high volume of products.
...offer functionalities such as: 1. **Manual Entry:** The app should allow teachers to manually enter attendance data for the students. This means user-friendly interface is key. 2. **Automatic Notifications:** The system should have the capability to automatically send notifications to absent students. The notifications should be programmed in such a way that as soon as a student is marked absent, an automatic notification message will be triggered to the student. 3. **Attendance Reports:** The app should generate comprehensive attendance reports, providing insight into the students' attendance habits. These reports should be easily accessible and user-friendly, giving teachers a clear understanding of student attendance patterns. Ideal candidates for...
1. We are seeking a proficient HTML5 and CSS3 expert to improve alummoottil.com. This website is purely HTML5 and CSS3 and there is no usage of javascript (except for google analytics) 2. Your task will be to optimize the performance of the website with the following objectives. a - Improve the website's loading speed b - Enhance its mobile responsiveness c - Increase the desktop performance (see performance report) from 46 to 100 d - Increase the mobile performance (see performance report) from 37 to 100 3. I do NOT want any changes to the existing look and feel. 4. I do NOT want any additional functionality. 5. Delivery must ASAP 6. The freelancer who is awarded must sign a Non Disclosure Agreement (NDA) and Intellectual Property Agreement (IPA). This will requi...
We are a small and international team looking for a long term partnership with individuals or teams skilled in seamless background removal/replacement and retouching - capable of handling large quantities of images daily without compromising on quality. Our budget and payment structure is negotiable and flexible, and we are also open to hiring full time. Applicants must be open to signing an NDA and doing a test so we can assess editing proficiency. Looking forward to hearing from you!
Available driving test slots scraper with autobook for selected dates
...This should include optimization of page load speed, SEO, and methods to increase conversion rates. Although there are no specific features or functionalities I want to be included in this improvement process, any recommendation you bring to the table will be considered favorably. As a Shopify store owner, I am interested in seeing an increase in sales and trafficking, so experience in these areas will be highly valued. For candidates to be considered I would like a thorough review of and provide your recommendations in the quote. Key Details: - I expect work to be completed within a month - Extensive experience with Shopify store optimization is a necessity Ideal Skills: - Expertise in SEO - Proficiency in Page load speed optimization - Experience with Conver...
I'm seeking a talented graphic designer to create an eye-catching, elegant design for my brand . As it's a luxury cosmetic brand, I'm keen for the design to convey an air of both luxury and elegance. - The Ideal Candidate: A well-versed graphic designer with significant experience in the cosmetics industry, and has an eye for modern luxury design. Working knowledge of industry trends and familiarity with admired logos, such as La Roche-Posay, RhodeSkin is strongly desired. - Desired Feel: While I want the logo to be elegant and luxurious, it's also important that it retains some level of simplicity, similar to the La Roche-Posay logo. I'm not looking for anything overly intricate or complex. - Key Concepts: Luxury and Elegance. Our...
As a business owner, I need a data entry operator who is proficient and experienced with Excel formulas. This is fairly urgent, and I am looking to make a quick hire for this role. The complexity of the task at hand includes: - Data entry with calculations - interpretations are not necessary - The project needs to be completed as soon as possible The ideal candidate for this job would possess: - Speed and accuracy for data entry tasks - Strong proficiency with Excel - A deep understanding of Excel formulas - The ability to work under tight deadlines I look forward to seeing your bids and working with you. Thanks!
Storecheckers are a Global Ma...well-presented, as you will be representing us during the audit. As an auditor, you will arrive at the test center an hour before the start of the exam, give your ID, show a letter of authorisation, which we will provide for you beforehand, and tell them what you are there to do. You will then sit with the TCA or the manager and ask a series of questions, and ask to see various things. The audit itself is very simple and easy, as we give you the form and you only have to ask the TCA/manager all the questions exactly as they are written and take a few pictures. The fee is $125 for the visit, which lasts four hours in total. Note that you will need a valid, photo and signature bearing ID for this visit. If you are interested, ful...
I'm searching for an expert in BTC-TRC20 USDT flasher development. The goal of this project is to significantly improve transaction speed. Key Requirements: - Experience with private wallets: This project primarily involves work with private wallets. You must be well versed in working with these systems. - Enhancing transaction speed: The main objective of this project is to increase the speed of transactions. The successful candidate should have a deep understanding of how to achieve this. - Semi-automated operation: While the system should be semi-automated, user decisions will still play a crucial role. You should be able to create a system that allows for user input. - Security expertise: This project involves valuable assets and security is of ...
We are an IT consultant organization based in Spain. We are looking for help in the following project. Project description available in Spanish below. Project Description:We are seeking a freelance IT consultant to assist with the implementation of Peer-to-Peer (P2P) distribution solutions within our Microsoft SCCM environment. The project involves setting up either BranchCache with OSD Toolkit or Peer Cache to optimize the distribution of Windows 11 images across our network. The primary goal is to reduce network congestion and improve distribution speed while ensuring minimal disruption to our existing SCCM infrastructure. The consultant will collaborate closely with our internal IT team to define objectives, configure the P2P solutions, conduct a proof of concept (POC), a...
I am looking for a skilled professional to conduct a comprehensive penetration test on my website. Key Objectives: - Identify vulnerabilities: I need to ensure that no exploitable weaknesses exist that could compromise the security of my website. - Assess compliance with security standards: My website must meet industry security standards to ensure data protection and user privacy. - Evaluate potential impact of a breach: It's crucial to understand the possible consequences of a successful security breach. - Bug identification: I would also like any bugs found to be highlighted so that they can be fixed. I have not conducted security testing on the website before, so this will be the first time and it's important that the expert I hire is thorough and expe...
I'm looking for a talented illustrator and designer to assist in revamping our Lab Collection guide. Specifically, I need new illustrations and drawings for the 'Test Tube Requirements and Specimen Collection Methods' section. This section should include information on various types of test tubes, specimen collection procedures, and safety precautions. Key Responsibilities: - Create visually appealing and informative illustrations for the Lab Collection guide - Ensure that the new illustrations and drawings are consistent with the existing guide - Format the guide in an engaging and user-friendly way Ideal Skills and Experience: - Proven experience in creating scientific or technical illustrations - Strong graphic design skills - Ability...
...am seeking an experienced SharePoint developer to create a new SharePoint site and list for my team. This list should encompass both team member contact information and task assignments. Organisation of the list should be by both task category and project phase, for easy navigation and maximum efficiency. The significant aspect of this project is not only creating the SharePoint list, but also implementing Power Automate flow for seamless operation. Key Responsibilities: 1. Creation of a new SharePoint site and list 2. Inclusion of team member contact information and task assignments in the SharePoint list 3. Organizing the list by task category and project phase 4. Configuring Power Automate flow for the list Ideal freelancers should demonstrate: * Profi...
We have partially designed the website and dashboard on Figma already, nearing completion for the platform and some changes may require. We aim to seamlessly incorporate IoT monitoring and control system into our website, requiring full development of an interactive website with a focus on safety, security, and speed. There will be different clients like admin, super admin and different clients etc. I require the design and development of a robust IoT platform that includes dynamic dashboard capabilities, using and Node.js technologies. Key Features Required: - Real-time data monitoring controls and device management for continuous tracking. - Data visualization interface for presenting data in a digestible format. - User-friendly '...
This is a small 3 or 4 page WordPress website. Skills needed: MySQL / AJAX / fetch / Axios / PHP / JavaScript - Registration & Profile Management page - User Data Entry Form with Data Entry History page - User Data search field page Site will need to integrate into a page builder (Oxygen) Be sure to View attachment for bidding instructions to avoid bid deletion.
...apply if you are not skilled in all of the above , especially in Linode. 1) Part A: Homepage formatting and changes: a) Loading of website very slow. Fix this. b) Homepage: i) Logo: Alter log in the top left-hand side to Lernitt logo. Make logo, font and colours the same as the Lernitt logo the banner to 2x the current height. Make logo larger also. ii) Font style: alter the font for the heading on the homepage with font and colour to be provided iii) Under “Approved Tutors” heading: Get the tutor videos working. iv) Under “Safety” heading: Change “Safety” heading font to that provided by us. v) Under “Courses” heading: The “My Tutoring World” logo needs to change to the “Lernitt” logo. vi) Under &ldqu...
Storecheckers are a Global Ma...well-presented, as you will be representing us during the audit. As an auditor, you will arrive at the test center an hour before the start of the exam, give your ID, show a letter of authorisation, which we will provide for you beforehand, and tell them what you are there to do. You will then sit with the TCA or the manager and ask a series of questions, and ask to see various things. The audit itself is very simple and easy, as we give you the form and you only have to ask the TCA/manager all the questions exactly as they are written and take a few pictures. The fee is $125 for the visit, which lasts four hours in total. Note that you will need a valid, photo and signature bearing ID for this visit. If you are interested, ful...
I'm currently in dire need of a competent C++ programmer to fix a bug in my existing code. The timeframe is extremely tight and the task must be completed ASAP. Key Requirements: - Strong command of C++ programming language - Experience in debugging and fixing errors in C++ code - Ability to work quickly and efficiently, under tight deadlines Your primary task will be to identify the issue causing the bug and rectify it promptly, ensuring the software runs smoothly. Your understanding of the codebase and the C++ language is crucial in this. Please respond only if you're confident in your ability to deliver high-quality work promptly.
Scope work only setup running sonarqube locally, run Sonarqube analytics + unit test to Sonarqube code use : nextjs,javascript,typescript
I'm seeking a detail-oriented data entry expert with aptitude in website testing to assist in testing user registration forms on website. The goal is to evaluate the robustness and validity of the system through specific input scenarios. It will be a monthly fixed part time job. I'm looking for 20 hours a week. Your responsibilities will include: - Conducting tests on different input scenarios using the provided data.
I'm looking for an experienced professional to test Stock Trading applications, preferably with experience in the financial sector. Key Points: - Primarily concerned with the Stock Trading aspect - You are required to have experience in the field Please do not hesitate to include your stock trading experience in your application.
... - Real-Time Processing: The model must process in real-time. This means that it should be able to detect objects with minimal delay, crucial for surveillance applications. Other requirements include: - mAP, F1 Score & FPS Analysis: Provide a comprehensive evaluation of the model's performance through mAP, F1 score, and frames per second (FPS) analysis. This will help us gauge the model's accuracy and speed, two critical factors in its effectiveness. - Model Explanation: Offer an in-depth explanation of the model architecture. I would like to understand the internal workings of the model and how it detects objects in real-time. Ideal candidates for this project should have: - Strong TensorFlow expertise: The professional should be well-versed in Tens...
I'm looking to set up a WordPress website specifically designed for course creation and tutorials. This will encompass a variety of topics including academic subjects, professional skills courses, hobby classes and English language courses. The main content delivery will be in the format of video tutorials. Ideal Skills/Experience: - Proven experience in creating WordPress sites for e-learning - Knowledge of optimal formats for video tutorial integration - Understanding of e-commerce if applicable to course payments - Ability to ensure smooth user-friendly course navigation design - Familiarity with creating dynamic, engaging course pages - Strong grasp of SEO tactics to attract traffic to the site - Ideally, experience in launching similar multi-disciplinary ...
...song (2-4sec) creating a new cool unpredictable music video. You need to try and test our app as well to understand it a bit. Key Responsibilities: 1. Check our Shopify Collabs Account and optimize it using our website, pictures, videos, reels, etc. You can create some pictures, reels as well. 2. Find Influencers using our Shopify Account or maybe you have some other source of influencers? 3. Negotiate with Influencer to bring their followers inside our app to dance with him in their song (influencer should use his channels to invite his followers - as youtube to describe app, instagram, facebook, let them be creative) 4. After their song is finished inside our app, then we can pay them Ideal candidates for this role should have: - Proven experience in influencer market...