Small sql query punët
Pershendetje Glen. Jam e interesuar per ndihmen tuaj ne SQL. Do te me duhet ndihma jote ne nje provim neser. A mundeni te me ndihmoni me nje shume prej 10 euro per 1 or e gjysem?
Programing in Dot Net & SQL Server. Visual Studio 2010, SQL Server 2012 Express ose më të avancuar. Modify existing modules, add modules, design interface, Reports...etc
Need help with a simple task that involves writing simple SQL statements and completion of the relevant ER diagrams. This task is in the context of simple data analysis. To be completed within 2-3 days.
I have a running Python file, who parse data from xml and insert it into sql server. Currently it isnt working. need an expert in python, who can fix it and upgrade few things as well.
I'm in urgent need of skilled professionals with experience in MySQL and Digital Ocean recovery console. My MySQL server is locked and I require assistance in exporting a SQL file. The exact cause of the server lock is not currently known but it might be due to server resource overload or a potential security breach. Required Skills: - MySQL - Knowledge of Digital Ocean's recovery console - Server management The main objective of the task is: - Successfully export the locked SQL file for further analysis and resolution - Provide insights on the potential cause of the server lock for future prevention. Experience in server management, specifically in handling locked servers, will be a great plus. Thanks.
...the right audience? We're seeking an expert to optimize our Google Ads platform and drive downloads for our small business owner-focused app. Key Project Details: Objective: Increase app downloads among small business owners seeking marketing strategy support. App Description: Our app provides marketing strategy and business growth insights tailored for users with limited marketing experience. Current Situation: Existing ad campaigns are in place, but we need optimization to attract high-quality, relevant users and minimize irrelevant traffic (e.g., looking to start a business or students). Desired Outcome: Enhance ad campaign setup to increase app downloads from established small business owners seeking strategic guidance. Ideal Skills and Experience: G...
I am seeking a skilled database developer to convert my .frm and .idb files into a SQL file. The original files are in MySQL format. Key tasks will include: - Conversion of .frm and .idb files to SQL format. - Exporting these converted files to mysql server. I did not specify any special properties or features of the .frm and .idb files that need to be preserved, but will appreciate a careful and diligent conversion to ensure no data loss. The ideal candidate for this job would have: - Extensive experience with MySQL 5.7. - Proficiency in SQL file conversion. - Strong knowledge of database export practices. - Keen attention to detail to ensure data integrity.
...calculate the hourly rate and the time needed to complete different task documents, on an agreed fixed price. The best offers with the right experience will have the opportunity to work with us on a long-term basis. Also, Good prospects for the right developers, based on the performances evaluated over a period of time, once you established your skills. Need to provide the changed code details and sql queries if any at the end of each sub-task, with the changed code line numbers. Unlimited Revisions are needed. Any bugs created due to your own developments are to be fixed on free of Charge. Recruitment is for a long-term big project as such, all the developers are subject to practical skill test for which not paid. Please send your details for the below-mentioned questions....
I'm fairly new to R, but need to apply linear regression to predict an outcome. I'd be grateful to work with someone who can guide me through this process. Ideal skills: - Expertise in R - Profound understanding of Linear Regression Experience: - Previous projects involving regression analysis - Proven results in predicting outcomes using R
I'm on the hunt for a skillful coder proficient in web scraping, specifically for Website A. The goal of this project is for obtaining valuable and significant data for analysis, competitive intelligence, and price comparison. While there's no explicit mention of the type of data to be scraped, I anticipate that a capable offering will cater to a variety of needs such as: - Text content - Image content - Metadata Ideal Experience and Skills: - Proven experience with web scraping - High proficiency in handling large data sets - Comfort in navigating Website A - Ability to collect comprehensive data categories Looking forward to a potential collaboration to achieve this goal!
I need a ...time, drop off location - Every day 3 buses are departing to airport. Say morning 8am, 1pm and 8pm. We need to get auto emails based on this bus timings of scheduled pax list and they take manually report with date/time filter. Ideal Skills: - Strong background in web application development - Experience in booking system or related is a huge plus - Fluency in database management, preferably SQL - Proficiency in PHP or a similar back-end programming language - Strategic problem-solving skills and attention to detail The success of this project requires not just technical expertise, but also a clear understanding of travel agency operations and the importance of efficient booking management. If you have relevant experience and the right skill set, I look forward to...
I am seeking a skilled architect or drafter to create detailed facade, plan, and section drawings for four structures. Each drawing must be completed using a template I will provide to ensure consistency with the final output style. Scope of Work: Small Residential House (12 sqm) - I require a complete set of drawings (facade, plan, and section) for a small 18 square meter residential house. Reference images with dimensions are available. L-Shaped Small Residential House (65 sqm) - This task involves creating architectural drawings for a 65 square meter residential house in an L-shape. I will provide images with handwritten dimensions for guidance. Covered Outdoor Seating Area (24 sqm) - Drawings are needed for an outdoor seating area with a roof, covering 24 squar...
I'm on the hunt for a skillful coder proficient in web scraping, specifically for Website A. The goal of this project is for obtaining valuable and significant data for analysis, competitive intelligence, and price comparison. While there's no explicit mention of the type of data to be scraped, I anticipate that a capable offering will cater to a variety of needs such as: - Text content - Image content - Metadata Ideal Experience and Skills: - Proven experience with web scraping - High proficiency in handling large data sets - Comfort in navigating Website A - Ability to collect comprehensive data categories Looking forward to a potential collaboration to achieve this goal!
I run a software company catering mainly to small businesses. Our services include software development, mobile app development, web design and development, and cyber security. I need a professional and corporate website that reflects the serious nature of our business. Key Requirements: - The website should prominently feature our main services. - It should have a professional and corporate design style. - The site must be optimized for desktop, tablet, and mobile devices. - A well-organized navigation system that makes it easy for potential clients to find the information they need. Ideal Skills: - Proficiency in web design and development - Experience creating corporate websites - Knowledge of SEO best practices - Understanding of small business needs Please provide ...
I require a savvy Excel specialist who can effectively perform data analysis for a small volume of data. The data set to be input and analyzed has less than 500 entries and is composed of both numerical and textual data. Ideal Skills and Experience: - Excel proficiency - Previous experience with data analysis - Ability to handle both textual and numerical data The task will involve data entry and thorough data analysis to extrapolate insights from the dataset. Accuracy, attention to detail, and a keen analytical mind are essential qualities for this project.
I need to integrate Tableau with my SQL database, and I'm looking for a skilled freelancer to handle this. Key Responsibilities: - Setup Tableau integration with SQL database - Ensure seamless connection and data flow between the two - Deliver a functional, user-friendly interface for data visualization Ideal Skills: - Strong experience with Tableau and SQL - Excellent understanding of database management and integration - Ability to create interactive dashboards - Proficiency in optimizing data for Tableau visualization This project will require a keen eye for detail and a commitment to delivering a quality, tailored solution.
I'm currently in need of an experienced full stack developer who is proficient in both JavaScript and PHP. Key requirements: - Strong skills in front-end development, specifically using JavaScript. - Proven experience in handling backend development with PHP. - Knowledge of SQL is also important. - While not a strict requirement, familiarity with JavaScript frameworks such as React, Angular, or Vue and PHP frameworks like Laravel or CodeIgniter would be a big plus. - Experience with SSL implementation is a must, but there are no strict preferences as to the type of SSL to be used (Wildcard or EV SSL). Being able to pick the right SSL depending on the project’s needs will be part of your responsibility. If you're the kind of developer who is adept at managing the f...
...time a change is detected. Freelancers with experience in creating similar systems or possessing a deep understanding of the workings of Windows OS will be preferred. Additional Details: Monitor Regedit for the changes related to the policies applied through Service. Send notification to server, send mail to a group, in case of change not applied through Service. 7. Logs needs to be updated to SQL via a API POST call (this endpoint is developed you need to call this Only) and keep a backup at local database. POST JSON - { "Username": "", "MachineName": "ABC", "Timestamp": "", "appliedPolicies": [ { "Policy1": "0", "Policy2": "2" } ], "removedPolicies": [ { ...
I am looking for a professional with proficiency in Power Query and PowerBI. The key objectives are: - Data Transformation: The expert is expected to possess the skills to thoroughly transform operational data since this is primarily what's going to be handled. - Excel Proficiency: Once transformed, the data should be presented in an Excel file. A good command of Excel functionality is important. - PowerBI Reporting: The transformed data needs to be applied in creating interactive reports. Mastery of PowerBI tools is a prerequisite. - Visual Dashboard Creation: A visually engaging dashboard should be created in PowerBI. Practical knowledge of industry practices in dashboard creation is a plus. Prior experience in handling and transforming operational data and carrying out dat...
I'm on the lookout for a proficient web designer with expertise in HTML, CSS, SASS, JavaScript, AJAX, and jQuery to bring to life an informational website oriented towards professionals. Key Responsibilities: - Creating a website that effectively provides details about our specific products and services. - Crafting a user-friendly layout that resonates well with professionals. Preferred Skills and Experience: - Profound knowledge and practical application of HTML, CSS, SASS, JavaScript, AJAX, and jQuery techniques. - Demonstrated experience in designing informational websites. - Capacity to understand and target professional audience's needs and preferences. - Strong eye for detail and commitment to webpage optimization. I look forward to hearing from you, preferably throug...
Need help digitising my paperwork. This entails entering text and numbers from hardcopy documents up to 100 entries in total. The ideal freelancer should be: - Detail oriented to ensure accuracy in entries. - Proficient in fast and accurate typing. - Experienced with data entry tasks. - Familiar with document scanning and digitisation. Please take note, this project requires on time delivery and accuracy.
...as well as vector databases to store the index. All ingested documentation is cleaned up and divided into smaller chunks and labeled by source. We then use the GPT embedding API to generate a vector representation of each chunk and store it in the vector db index. When a user asks a question, we convert it to an embedding, and perform an advanced semantic search for closest matches to the user's query. Then we take the most relevant chunks, included them as context along with the original question, and use the ChatGPT API to generate a response in markdown format that we then convert to HTML and display to the user. This is from website. They provide a similarity percentage from the sources they use for the generated answer, we can use that similarity percentage for the r...
I'm looking for an experienced Electrical Engineer to design a custom electrical system for my small commercial space, which is less than 500 sq ft. Key Requirements: - Design should include lighting fixtures, outlets & switches and HVAC controls. - Pay special attention to unique needs of our restrooms and retail area. - Previous experience in electrical design for commercial spaces will be advantageous. Scope includes CAD drawings showing the correct locations for lights, switches, exits, retail window, small bathroom. This needs knowledge of US electrical code. Can you help? Please do not apply and then change your bid once I accept... I will cancel the job. I have included a sketch of basic plan outline to review before accepting the job. Ideal candidat...
I'm looking for a skilled develo...company. The platform should be comparable to Vista Print, with a focus on catering to the needs of small businesses. Key Points: - The platform is primarily for small businesses. It should be designed to cater to their specific needs, such as offering competitive pricing, ease of use, and effective customization options. - My ideal freelancer should have a strong background in e-commerce development, with a proven track record of creating similar platforms. - Experience is key. Please highlight your previous work in e-commerce, particularly projects that cater to small businesses. The main goal of this project is to provide a user-friendly, efficient, and cost-effective e-commerce platform for small businesses to explor...
I'm seeking a reliable data science professional skilled in Exploratory Data Analysis (EDA) with the ability to rank rows based on the EDA. Must be completed in less than 24 hours
...for jobs, and managing profiles and portfolios. - Build an admin portal with role-based access for monitoring user activity, managing complaints, and generating reports on job listings and user satisfaction. Preferred Tech Stack: - Front End: TypeScript framework with Server Side Rendering (React.js or Vue.js for web, React Native or Flutter for mobile) - Back End: Utilize GCP services (Cloud SQL, Cloud Functions, etc.) - Payment Gateway: Midtrans Indonesia. This work is going to be divided into 6 major stages, corresponding to 6 milestones: 1. Planning 2. Designing (Software design) 3. Developing 4. Testing 5. Implementation & Integration 6. Maintenance Details upon each stage will be discussed through online meeting If you're passionate about creating innovati...
Looking for someone that can create a web-based 3D modelling tool (or use an existing one) which allows my customers to create 3D models of Veranda's based on input of width, height and depth. Sample of a Veranda included in attachments. Requirements: - Webbased tool (might be PHP and Database for example) on my own hosting - Admin and User panel seperate - User should be able to define a Width, Height and Depth which will generate a 3D model of the veranda - Additional options like with/without glasses on the sides, color option (RGB), sample backgrounds to choose from. - Export 3D model as PNG or PDF option - Deployable on Docker (optional)
I am seeking a WordPress developer who can make specific modifications to a custom query that uses Advanced Custom Fields (ACF). The project involves: - Changing the query parameters - Adding additional query conditions - Sorting the query results The purpose of these modifications is to: - Display specific custom fields - Customize the order of displayed posts In particular, the modified query should display the 'Subfield Date' (from a repeater field) in the query results. Ideal candidates for this project should have: - Proficiency in WordPress development - Extensive experience with Advanced Custom Fields (ACF) - Expertise in modifying and customizing WordPress queries - Thorough understanding of PHP and MySQL Please provide ex...
I'm in need of a publishing expert in book publishing services, specifically for non-fiction genres. I have a fully-completed manuscript and I'm looking for someone to critically fine-tune my query letter and book proposal. Your role would involve: - Review and edit query letter and book proposal for UK and US agents - Offer constructive feedback and direction on improving the overall readability and marketability of the book proposal and letter Ideal candidates should have: - Proven experience in non-fiction book publishing with traditional publishers - Significant experience in the book proposal process - Solid understanding of what works in non-fiction book proposals to secure a literary agent Overall, your expertise will play a pivotal role in the overall su...
It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.
I'm currently experiencing some problems with SQL Server 2019 regarding a synchronization error in my Snapshot Replication model. Present issue: - Synchronization process follows an error. Desired solution: - Ability to correct the synchronization errors to allow for smooth data replication. Ideal Skills: - SQL Server 2019 expertise - Solid understanding of Snapshot Replication model - Proven experience in troubleshooting synchronization errors. I'm seeking assistance from someone with these expertise, who can provide a quick and efficient resolution to this problem.
I'm in need of an experienced Vue.js developer to assist with front-end development and implementing dynamic components. The project specifically involves working with Vue 2 and does not require integration with external APIs. Key Responsibilities: - Front-end Development: You'll be tasked with designing and developing the user-facing aspects of the application. - Dynamic Components: Implementing dynamic components to enhance user experience and application functionality. Ideal Skills and Experience: - Proficient in Vue.js: Extensive experience with Vue 2 is a must. - Front-end Expertise: Strong background in front-end development, with a focus on user interface design and development. - Dynamic Component Implementation: Proven experience in implementing dynamic components in V...
...Experience: - Proven experience with Magento 2 development - Strong understanding of cron jobs and how they work within Magento 2 - Familiarity with debugging and resolving SQL integrity constraint violations Please note that the specific table causing the error was not identified. Your expertise in this area will be crucial. I am using Magento 2.4.6-p4 CE and I get the following error after every order. The job indexer_update_all_views scheduled at 2024-04-15 10:31:03 failed with the following error message: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'entity_id' in where clause is ambiguous, query was: SELECT `o`.`entity_id`, `o`.`increment_id`, `o`.`customer_id`, `o`.`billing_address_id`, `o`.`customer_email`, `o`.`customer_firstname`, `o`....
I'm seeking a talented full stack developer for initial software development for a pathology lab. The software must be responsive, user-friendly, and robust, catering to patients, staff, and referring doctors. Here's what we need: 1. **Choice of Platform**: As the client, I am open to using Angular, React or PHP for the development along with SQL Server/MySQL for the database. Feel free to recommend a platform when you apply. 2. **Essential Modules**: - Building Patient Database (From existing Lab Software - Which will remain as is). This database will be used for Whatsapp , email , SMS Marketing (This also is part of scope) and also For Patient Web App interface. Whatsapp API interfacing will be required for sending and interacting with Patients. - Patient Web A...
...to my SQL Server database. Key Features: - Property Search: Users should be able to search for properties in my database - Property Details: Users should be able to view detailed information about the properties - Favorites List: Users should be able to save properties to a favorites list User Authentication: - The app should allow users to sign in using their Email and Password. Property Search: - The property search feature should integrate a map view for a better user experience. Users should be able to visualize the location of the properties they are interested in. - It should also include the option to save searches, which will be a convenient feature for users who are actively looking for properties. Ideal Skills: - Proficiency in Xamarin development - Experience with ...
I need a developer to create a proctoring exam application using Python and SQL Server. The primary role of this app is to monitor candidate behavior during online exams. Key features include: 1. Online Registration Of Candidates: A feature for students to easily register for exams. 2. Password-Based Authentication: To authenticate candidates before they can access the exams. Prior experience in implementing secure login mechanisms is preferred. 3. Advanced Browser Disablement: Unfortunately, there will be instances when candidates try to cheat the system. I need to prevent this by disabling browsing other tabs, accessing other applications, and the copy-paste function during the exam period. 4. Random Image Capturing & Video Monitoring: To further deter any cheating, the appl...
I'm looking for a JavaScript developer who has experience with WordPress and ideally Elementor. I need help with three specific tasks on my website that uses Elementor: 1) On mobile devices, when a user clicks on the Table of Contents component, it opens above the content. If the user clicks on a chapter, the Table of Contents remains open. I would like it to close automatically after a chapter is selected. You can see this issue here: 2) When the same page () is loaded on mobile, the Table of Contents appears immediately and obscures the content for a few seconds. I want it to remain closed during page loading. 3) I need to correctly set up the offsetting of an HTML anchor to compensate for a dynamically changing header height as you scroll. Currently, it functions correctly only...
I require an expert to set up a CPanel template for my NeoBank website. Files are already uploaded, just need installing and SQL setup. Links to website setup provided.
"Monitor Regedit for the changes related to the policies applied through Service. Send notification to server, in case of change not applied through Service. 6. Reading Frequency - 1 min, 10 min etc needs to be update in Regedit - HKEY_LOCAL_MACHINESOFTWAREVShieldService, Polling -1 7. Logs needs to be updated to SQL via a API POST call (this endpoint is developed you need to call this Only) and keep a backup at local. api/logs/ { "Username": "", "MachineName": "ABC", "Timestamp": "", "appliedPolicies": [ { "Policy1": "0", "Policy2": "2" } ], "removedPolicies": [ { "Policy3": "2" } ...
... Ideal skills and experience for this assignment include: - Expertise in Laravel & MySQL - Experience with high load applications - In-depth understanding of database performance optimization - Experience with online poll/voting systems The specific tasks I need assistance with are: 1. Addressing a database connection error which has arisen due to intense continuous voting. 2. Tackling the query performance problems coming up in our online polling setup. 3. Addressing the data inconsistency issues that have cropped up due to dynamic vote tallying. The votes are expected to be collected as per IP, hence, experience with IP-specific data handling is highly desirable. In summary, I need a Laravel and MySQL expert to revamp our online voting architecture for seamless perfo...
Job Title: Senior Master Data Management (MDM) Developer Monday to Friday Remote via Zoom 2-3 hours/day IST Night (7pm to 12amIST) Salary: 30,000 I...Developer Monday to Friday Remote via Zoom 2-3 hours/day IST Night (7pm to 12amIST) Salary: 30,000 INR per month We are seeking a Senior Master Data Management (MDM) Developer with a focus on healthcare. Strong SQL skills for data manipulation and querying. Experience with ETL development and integration. Familiarity with Azure Data Factory and cloud/on-prem migrations is advantageous. One needs to be available in the mentioned timings and willing to work by screen share and remote control via Zoom. Skills Required: Master Data Management (MDM) ETL development and integration Strong SQL skills SSIS Azure Data Factory Cloud/o...
...A data archive is expected to allow users to have a space where they can share data privately to facilitate collaboration prior to publication. Such private enclaves must only last for a defined period of time before that data set is shared with the rest of the data archive will provide an interface that is accessible to anyone with a web browser. A data archive will make appropriate query tools and summary data easily will want to analyze and/or use visualization tools to interact with the data without downloading any data.A data archive is strongly encouraged to use cloud storage and computing possible, a data archive is expected to use existing infrastructures and standards. These could include persistent identifiers such as Digital Object Identifiers
As a small business owner, I'm in need of assistance in preparing medium-length (3-5 pages) performance feedback reports. I'm seeking a professional writer who can translate my observations into constructive, actionable communication. Key responsibilities: - Translate my notes into understandable, precise content - Prepare performance reports aimed at employee development - Ensure that the tone of the written feedback is constructive and balanced Ideal candidates should: - Have experience writing performance feedback or equivalent business reports - Understand the nuances of small business environments - Possess excellent communication skills - Be able to deliver the project within a stipulated timeline Your hands-on experience in performance management writing ...
* Set label to Estimate or Invoice (using the same form to either quote client or invoice client) * Be able to Password Protect the site * pre configure services * pre cofnigure suggested price, can change price if needed * e-mail clients & myself (pre configured) * Save estimate & Invoice as PDF * Process payment using stripe using API * SQL Database to store client info for repeat customers * Search client up by name, phone, address, or e-mail * Ability to move database & php script to other domain if needed * Ability to Backup Script & DB with a click Desired Programming Language: PHP * I'm looking for the best deal possible, please be very competitive. * Milestone release upon completion of the project & is bug-free. * Need Source Code when Job is Com...
I'm on the hunt for a skillful coder proficient in web scraping, specifically for Website A. The goal of this project is for obtaining valuable and significant data for analysis, competitive intelligence, and price comparison. While there's no explicit mention of the type of data to be scraped, I anticipate that a capable offering will cater to a variety of needs such as: - Text content - Image content - Metadata Ideal Experience and Skills: - Proven experience with web scraping - High proficiency in handling large data sets - Comfort in navigating Website A - Ability to collect comprehensive data categories Looking forward to a potential collaboration to achieve this goal!
I'm in need of an expert in SQL and VBA who can assist with a one-time project. The job will entail: - Writing complex SQL queries - Automating tasks in Excel using VBA - Conducting data analysis and generating reports This will be performed on Microsoft SQL Server. As such, considerable experience with this DBMS is a requisite. Primary skills and experience for the role include: - Expert level proficiency in SQL and VBA - Extensive experience with Microsoft SQL Server - Familiarity with automating Excel tasks and data analysis - Previous experience in report generation This is a one-off project with the possibility of future collaborations for similar tasks. If you have the necessary skills and experience, I'd like to hear from you.
I'm seeking a talented graphic designer to help me bring my vision to life with a small wall mural. The theme I have in mind is nature. Key Requirements: - Experience in designing murals, particularly for small spaces. - Proven ability to work with nature-themed designs. - Proficient in the use of design software to create high-quality and professional-looking graphics. - Strong communication skills to understand and interpret my vision accurately. I have attached close of what I want but need some changes to be complete.
