Asp net sql query slow jobs
I want to insert a DYNAMIC logo and text into my header bar just now all i have is 1 static logo however i want the logo to be dynamic (Store Logo) which will depend on the stores_id of the user then next to the logo will be the Store Name the stores_id is in the session and has been declared after login as $manager_stores_id = stores_id so we will need a query like $stores_query = tep_db_query("select stores_name, stores_image from `stores` where stores_id = $manager_stores_id); Then we load the logo top left which is stores_image and the name in plain white text (same styling as on the page) stores_name stores_image stores_name
...aspects of implementing this software in a business setting. The job requires an individual with: - Expertise in SAP Commerce, particularly with regard to the Development and Integration modules. Training should encompass all vital concepts, functionalities, and best practices associated with these components. - Skills in delivering effective in-person training, neither too fast nor excessively slow, to a SAP Commerce newbie. The training model needs to be highly comprehensive, interactive and learner-centered. - Ability to deliver training in a manner that accommodates my absolute beginner status, yet progressively elevates my knowledge and competence to an intermediate level or beyond. - Flexibility to modify training plans or strategies in response to my learning pace or ...
...our team in .Net Fullstack development. - Skills and Experience: As an expert in the .Net environment, you should possess deep understanding and captivating teaching methods to offer comprehensive training to our employees. While we didn't specify any particular .Net skillsets, proficiency across ASP.NET MVC, Entity Framework and LINQ is highly appreciated and valued. - Project Timeline: We are peculiar about the quality of training our employees receive and as such, we do not place emphasis on project completion time. Our ultimate goal is deep knowledge acquisition rather than a rapid, shallow understanding. Therefore, there is no set time limit for this project. Ideal freelancers for this project would be advanced level trainers with solid exposure to a ...
I want to insert a DYNAMIC logo and text into my header bar just now all i have is 1 static logo however i want the logo to be dynamic (Store Logo) which will depend on the stores_id of the user then next to the logo will be the Store Name the stores_id is in the session and has been declared after login as $manager_stores_id = stores_id so we will need a query like $stores_query = tep_db_query("select stores_name, stores_image from `stores` where stores_id = $manager_stores_id); Then we load the logo top left which is stores_image and the name in plain white text (same styling as on the page) stores_name stores_image stores_name
...help me convert US addresses from the National Address Database into a useable form for an API. This important task aims to strengthen my marketing strategies by enhancing the quality of data I use for these efforts. This is where the addresses are: I want you to place them into a database so that we can build and API around it and query the addresses for validation. Specifically, you will: - Retrieve and convert a vast number of US addresses from the source, which is currently in an online database format - Ensure the converted data is compatible and easily integrated with APIs for seamless utilization - Handle the entire range of addresses from the National Address Database, not missing out on any specific city or state Ideal
...high-level performance concerning query response time and system throughput. Load balancing efficiency and resource utilization are as crucial. • Scalability: I'm anticipating the system to be able to handle normal user requests from 100 - 1000 per second and sustain its performance, with an elasticity for peak loads. • Development environment: You should be comfortable working with Python and Docker containerization to develop the project. Crucially, design tactics must be adopted for creating a scalable and adaptable system design. The ideal freelancer for the job would have experience with software development using Python, building scalable systems, and Docker containerization. A robust understanding of performance metrics, including system throughput, qu...
I'm in need of a proficient web developer to construct a modern and visually appealing website for the purpose of sharing personal IT blogs. The aesthetic need...appealing website for the purpose of sharing personal IT blogs. The aesthetic needs to be contemporary and engaging, while being easy on the eye. Key Requirements: - Expertise in modern web design - Ability to implement easy-to-navigate functionality As I'm focused in sharing personal experiences, the site has to encourage reader engagement and discussion. However, please note: I skipped the query regarding the main website functionalities for now, this will be discussed in further detail once initiated on the project. Please provide examples of your prior work in this sector. Your creativity and innovation a...
I require a data analyst with proficiency in PowerBI to create a dashboard focused on analyzing compensation rates based on demographic details. I've attached a rough markup and source data. Will need this completed in a short timeframe due March 7th by 8am PT. The data source will probably need some cleaning in Power Query to be able to be presented accurately. You don’t need to recreate exactly, so feel free to add anything that you think would be worthwhile to look at. Thanks!!
As a website owner, I am currently grappling with some speed optimization issues. Specifically, my website loading time is quite slow, much slower than I desire - it takes more than 5 seconds to load, which is not good for user experience and may prove detrimental to my website traffic and SEO performance. I'm seeking an expert who can effectively improve this situation. My website predominantly features text-based content. Therefore, the focus will primarily be on optimizing the HTML, CSS, JavaScript and any other aspects that contribute to the loading time, rather than on graphics or multimedia files. The ideal candidate for this job would be someone with good experience in web development, speed optimization techniques, and a solid understanding of SEO principles. Also, fa...
I am urgently in need of a SQL expert proficient in MySQL. I require assistance with writing data definition queries. Work Expectations: - Writing proficient data definition SQL queries. - Extensive knowledge of MySQL. Below is my query. Need to modify the query and get the count as 0 for the column srce_syst_paty_i SELECT COUNT(*) FROM ( SELECT CASE WHEN PATY_IDNN_BK LIKE '%SAP%' THEN SUBSTR(PATY_IDNN_BK, INSTR(PATY_IDNN_BK, '+') + 1) WHEN PATY_IDNN_BK LIKE '%BCB%' THEN SUBSTRING_INDEX(PATY_IDNN_BK, '~', -1) END AS srce_syst_paty_i, * FROM dev_enr.cpln_svrq_paty_detl WHERE day = '02' AND month = '06' AND year = 2023 ) src INNER J...
I'm looking for an experienced freelancer to help with the deployment of a .NET Framework 4.7.2 code on a Plesk panel Windows hosting. Key Responsibilities: - Configure the SQL database settings - Adjust config file settings for database connections Given the specialized nature of this project, I need someone proficient in .NET Framework 4.7.2 and Plesk panel configuration. Familiarity with database connectivity and MSSQL is also a must. I expect a quick and efficient deployment without any loss of data or functionality. Let's get this done right the first time!
I'm in need of a skilled Selenium developer with significant experience in enhancing internet security. You'll need to perform three key tasks: 1. Adjusting proxy settings 2. Enabling developer tools 3. Configuring privacy settings accordingly Ideal candidates should have a solid understanding of Selenium and browser security configura...developer with significant experience in enhancing internet security. You'll need to perform three key tasks: 1. Adjusting proxy settings 2. Enabling developer tools 3. Configuring privacy settings accordingly Ideal candidates should have a solid understanding of Selenium and browser security configurations. Experience in Chrome user agent configuration, cybersecurity, and expertise in dealing with SQL injection attacks and da...
I require a website for my courier business with a primary focus on service description and pricing. The website should prominently feature: - Detailed service descriptions - Transparent pricing models Additional Requirements: - An integrated live chat support for immediate customer query resolution. Ideal candidates for this project must prominently highlight their past work related to website development in their applications. Previous experience with logistics/courier service websites will be a plus.
I am hunting for an entity extraction and vision technology expert. My nee...larger-scale use. Here's what you will be doing: 1. **Entity Extraction**: You will identify and extract entities from a text dataset. These entities will then need to be categorized into pre-defined categories. 2. **PoC Creation**: All these will culminate in the creation of a PoC to validate the feasibility of using an Entity Extractor and Vision technology. Please note, This project related to query over doctor Presciption. Ideal Skills: - Experience in Entity Extraction technology - Experience in Vision technology - Proficiency in sentiment analysis - Proven track record in PoC development - Ability to work with small datasets and identify useful patterns and insights Looking forward to wo...
I'm in need of a highly skilled software developer to build a website for an engineering project. The professional I am seeking should have extensive experience in: - Python - HTML - CSS - SQL - Javascript - Node.js The main goal of this project is to deliver a user-friendly, practical and efficient website that can facilitate project management and monitoring for engineering tasks. The end-users of this website will be individuals working on an engineering project. Your expert touch on this will help to streamline their work, enhancing productivity and communication. Please, only apply if you have a proven track record in these programming languages and the capacity to meet strict deadlines. Your portfolio showing completed similar projects will be a plus. Thank you.
I am in need of an experienced interior designer to infuse a modern theme into my living room. This project revolves around some questions: Questions to consider: -> Which furniture to create warm clean look -> We're placing a TV right to the entrance door (between entrance door & kitchen) -> Which paints on wall to create warm look -> Which lights to build? -...experienced interior designer to infuse a modern theme into my living room. This project revolves around some questions: Questions to consider: -> Which furniture to create warm clean look -> We're placing a TV right to the entrance door (between entrance door & kitchen) -> Which paints on wall to create warm look -> Which lights to build? -> other improvements ... => Link 3D =&g...
i have a mysql query i need to add some JOIN or WHERE / AND condition i tried but not working help call first to show the issue then once i award u u will work in real time live must be done realtime live
...own sales and the level difference of the downline member of his team sales. If the level difference of users becomes the same then the commission awarded to upline will be removed and added to the users whose level upgraded. You have to notify all users for the commission rewarded from which user and for which property. You have calculated Gross Sales (Total Commission of total property sold) Net Sales (The percentage of the amount in respect the total amount deposit The plan should be designed in a way that supports a complex, 15-level commission structure, ensuring automatic accumulation of commissions and real-time commission tracking. Key Features Required: - Multi-level commission structure - Up to 15 levels. - Automatic commission accumulation. - Real-time commissio...
...expansions and updates. Skills and Qualifications: Strong proficiency in C++, Python, and Java for system control and automation. Experienced in mobile app development using React Native, Swift (iOS), and Kotlin (Android). Skilled in web development with a focus on responsive design and secure payment processing. Deep understanding of backend development, including API services, database design (SQL and NoSQL), and server-side logic. Familiarity with sensor integration and real-time data processing. Experience with automation systems, robotics, or similar technologies is highly desirable. Knowledge of machine learning and optimization algorithms is a plus. Excellent problem-solving abilities and attention to detail. Strong communication skills and the ability to work as part of a...
I'm on the lookout for a skilled freelancer, preferably wit...following tasks: - Developing a HTTP server using C# programming language - Ensure the server can process json strings - Subsequent to submitting a json string, the server should be programmed to return a result. Given the project’s focus on text data encryption, the ideal freelancer should have proficient knowledge of handling different types of data using C#. Having experience working with .NET Core or ASP.NET can be an added advantage but it's not a specific requirement. In your bid, please specify your relevant experience in building HTTP servers with C#, and handling text data. Let's meet over a message to discuss in detail about the project. Looking forward to working with an enthusiastic ...
Need someone to take my videos and turn into a compelling video that attractive to look at. The videos are for a pressure washing company. I will give access to the videos the freelancer should have the skill to select the videos and make a nice upbeat video. I want it to have special effects like maybe slow motion, shudder , transitions.. Something catchy. Once again, the freelancers should be able to determine what is catchy. Not looking for something basic
I need code for a simple code using React and .NET framework. - The ideal candidate will have: - Proficiency with .NET Framework and React - Skills in both functional and class components I expect a seamless integration process without compromising the site's functionality. This role requires acute attention to detail and strict adherence to project guidelines.
I am currently using Microsoft Access 2013 and need help in migrating data from Access to PostgreSQL. This involves handling: - Text and Date/Time data types - Number and Currency data types -arabic unicode name The database that needs transformation contains between 1table The ideal candidate should be: - Familiar with both Microsoft Access and PostgreSQL - Have Proficiency in SQL - Have an understanding of data types, and how they're handled in Access and PostgreSQL - Able to accurately and securely migrate the data. If you meet these requirements, please bid on this project. Remember, it's more than just a simple transformation, I need a solution that ensures maximum data integrity during the migration.
...renowned for optimizing and streamlining query performance, specifically for numerical data. Having identified inefficiency in indexing as the root cause of my concern, my aim is to significantly improve the speed and efficacy of our system. Here's what this project entails: - Diagnosing the existing MongoDB indexing setup - Analyzing and suggesting improvements for indexing of text and numerical data - Practically implementing recommended changes and optimizing query performance - Providing detailed reports before and after optimization An ideal candidate for this project would be someone with a solid background in MongoDB, specifically in optimizing query performance. Familiarity with numerical datasets is a plus. Your skills should include MongoDB quer...
We require a Qualified Accountant to assess and provide clients a Certificate certifying their income or net assets. Payment per Certificate as and when required. The Qualified Account must be as per the below: Qualified Accountant A qualified accountant is defined in s88B of the Corporations Act as a person meeting the criteria in a class declaration made by ASIC. Under our ASIC Corporations (Qualified Accountant) Instrument 2016/786 you are a qualified accountant if you: - belong to one of the following professional bodies at the declared membership classification, and you comply with your body's continuing professional education requirements. Professional Bodies - Chartered Accountants Australia and New Zealand (formerly The Institute of Chartered Accountants in Australia)...
I'm looking for a seasoned SSRS Expert who can fix a error on SQL job that handles data extraction and transformation tasks for our project. Key tasks include: Fix error on sendgrid smtp connect error Candidates with strong background in SSRS and proficiency in automating SQL jobs are highly preferred. Familiarity with email notifications based on SQL triggers is a plus. The ultimate goal will be to enhance our system's efficiency through automation and effective data reporting.
I'm in need of an expert who can assist me in replicating my entire SQL database. This task is primarily aimed at data distribution between 2-3servers on Different IPs Ideal Skills and Experience: - Strong experience with SQL databases - Proficient in various SQL replication methods - Previous experience with large scale data replication - Detail-oriented and capable of ensuring data accuracy - Sound knowledge of data distribution techniques Please bid if you meet these requirements and are confident you can effectively assist with this project.
As an e-commerce business owner, I'm in need of a fully customized payment gateway for my online store. The gateway should encompass: - Credit/debit card transactions. - Net Banking payments. - Unified Payments Interface (UPI) transactions. - Wallet transactions. In addition, it should also provide 'Cash on Delivery' (CoD) option. It must offer unique features like: - One-click payment for expediting the checkout process. - A custom checkout feature to align with our website's aesthetics and functionality. The ideal freelancer for this project would be someone with prior experience in payment gateway development and a solid understanding of different payment methods in India. Knowledge of e-commerce industry, UPI, and digital wallets would be advantageous.
I'm in need of a SQL expert who can assist with some tasks on my MySQL database management system. The exact tasks are still being finalized, but it is essential that you have a wide range of skills and expertise in the field. Here's a potential list of tasks you might be working on: - Query optimization - Database design - Data migration Ideal Skills: - Extensive understanding of SQL and MySQL - Previous experience with query optimization, database design, and data migration - Strong problem-solving ability When applying, please ensure you include details of your past work. I'm keen to see examples of SQL tasks you've successfully completed, specifically in MySQL. Please be as comprehensive as you can be in your application. You...
Maximum bid $80 I am looking for a skilled freelancer with expertise in ASP.NET, Visual FoxPro, Office, and SQL to make the application work . I was functional before moving to the new site.. Key Job Details: - Fluency in ASP.NET, Visual FoxPro, Office, MS IIS Serve, Visual Stdio and SQL is required. - Ensure a seamless migration from the backup to a new hosting site without any data loss. - Full migration of my e-commerce site. - Preserving user data and order histories. - Ensuring a seamless transition to an identical server. Ideal skills: - E-commerce site migration proficiency. - In-depth knowledge of server specifications. - Experience in data backup and recovery. - Ability to thoroughly test site functionality post-migration. The chosen professional will safeguard a...
I'm in need of a proficient DotNet MAUI developer who can enable Chromecast functionality in my exist...is operational on both Android and iOS platforms. Here are the specific requirements: • Enable casting of entire screen • Enable casting of specific app content • Maintain and respect the existing .NET 8 platform based DotNet MAUI framework Ideal Skills and Experience: • Proficiency in DotNet MAUI • Experience implementing Chromecast related functionalities in applications • Deep understanding of .NET 8 platform • Prior work with both Android and iOS enabled apps. Interested freelancers should demonstrate their experience and understanding of DotNet MAUI, Chromecast functionalities, and .NET 8 platform. Please provide refe...
I'm in need of a professional with SQL and Tableau capabilities, I need some one who is expert in SQL and Tableau
I'm looking to build a new React application that leverages a .NET API, all from scratch while utilizing an existing SQL database. - **Core Functionalities:** - **User Authentication:** Secure login system using email and password. This system should ensure that user data is protected and only authorized users can access the application. - **CRUD Operations:** The ability for users to create, read, update, and delete data within the database seamlessly. This includes managing user details, settings, and other data points relevant to the application. - **Role-Based Access Control (RBAC):** Different levels of access and permissions for users based on their role within the application. Specifically, I need two roles: Administrator and Standard User. Administrators ...
...will have the technologies described in the “Technology Description” section below. <Technology Description> This technology relates to technology for remotely operating a vehicle from a communication terminal, and in particular, to improving security when a vehicle is moved for parking by remote control. One of the problems when remotely parking a vehicle is that a moving vehicle is relatively slow and has low acceleration, so a bad person may enter the vehicle and steal it while the vehicle is parking by remote control. To solve this problem, when a vehicle is remotely operated from a telecommunication device such as a smartphone to move a vehicle, the vehicle is prohibited from moving when the vehicle cabin is unlocked. Please search for this technology. &...
I am having some issues with my website in terms of its appearance and performance. Specifically, I believe it lacks effective organization and has a poor layout. The slow loading time and unresponsive links also add to the negative user experience. To improve it, I want to focus on the following areas: - Speed Improvement: My site suffers from slow loading times. I need someone experienced in website speed optimization who can reduce these loading times effectively. - Layout Enhancement: The organization of my website needs to be revamped. I want to go for a more inclusive page layout to enhance user experience and accessibility. - Link Repair: Several links on the site are broken and need to be fixed. Experience in troubleshooting and fixing such issues is highly pre...
I'm experiencing a persistent "Cannot establish databa...WordPress plugins, and the database credentials in my WordPress configuration file have been checked and verified. Error is Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /opt/bitnami/apps/wordpress/htdocs/wp-includes/ on line 1987 No such file or directory Ideal Candidate should: - Possess knowledge and experience working with AWS EC2 Linux Instances and SQL databases. - Be well-versed in troubleshooting Wordpress database connection errors. - Be detail-oriented, reliable, and efficient. Your job is to diagnose the problems leading to the database connection error and implement solutions to resolve them. Your deliverable will be a working Wordpress website with a stable database conne...
...preferred. - 6 + years of software engineering and development, including 2 years in technical leadership. - Significant experience as a full stack developer. - B2 level English. - Must be well versed with C#, .NET, Angular(Or React), SQL Server and Azure DevOps. - Significant experience in new computing architectures and implementation of networked computing structures. - Experience developing NT, Unix, and/or Windows based applications, strong component, process and data modeling skills. **Preferred Skills** - Azure DevOps and/or Native Cloud Services - Agile/Scrum - C#, .NET, SQL Server, or Angular or React certifications **Compensation Pay Disclosure** Top Talented is committed to pay that’s fair and equitable, which means comparable pay for com...
I am seeking an innovative architect to design a net-zero building compound of fourteen (14) one-bedroom apartments in half an acre in Lusaka, Zambia, a premium urban area. Key sustainable components to be included in the project are: - Solar panels: It is essential to integrate solar panels into the architecture in a seamless and aesthetically pleasing manner. - Rainwater harvesting system: The design should feature a system able to capture, store, and use rainwater. Other requirements include: - Car Parking: Each apartment unit should have a dedicated and conveniently located parking space covered by solar panels. - Garden: Each apartment unit should have a dedicated small garden Ideal candidate should have a strong portfolio of sustainable housing design projects, with an...
Thank you for looking into my project. I'm in urgent need of an expert PHP and SQL Developer who can assist me with my PHP code file. Your primary task would be: - Extract the UPDATE queries from my existing PHP code file. Create the sql quart form the pho file. The freelancer I am looking for ideally has: - A strong background in PHP and SQL - Extensive experience extracting and optimizing SQL queries - A deep understanding of MySQL databases Please submit your proposal detailing your experience with the tasks listed above and how you plan to accomplish it. Your ability to communicate clearly and effectively will play a factor in who gets awarded this job. Looking forward to your bids.
...Requirements: Frontend: The frontend will be developed using ReactJs, ensuring a modern and responsive user interface. Backend: The backend will be implemented using either Java or Golang, depending on the developer's expertise and preference. The backend should seamlessly handle data processing, user authentication, and overall system functionality. Database: The application will utilize both NoSQL and SQL databases to efficiently manage and store data. This hybrid approach is intended to provide flexibility and scalability. Key Features: Property Listings: Users should be able to browse and search for properties based on various criteria such as location, price range, and property type. User Accounts: Implement a secure user authentication system allowing users to cr...
I'm looking for an experienced developer who can build a simple, yet effective online management system. Essential technology skills include C#, SQL, WebAPI, Bootsrap, and CSS. Key features will include: - User authentication: You should have prior experience designing secure login systems. - Data entry forms: These need to be intuitive and easy for end-users. - Reporting and analytics: Ability to create meaningful insights from data. - Selling and inventory: Inventory adjustments should be accurately reflected and synchronized with sales. - Create invoices: This functionality should be simultaneously linked with the sales and inventory module. The primary purpose of the system is inventory management, but it will also integrate other important areas like sales management....
We are seeking a highly skilled and experienced .NET developer to integrate Windows Active Directory (AD) authentication into our existing application, which is built on Windows Server 2012 Standard. This project involves replacing the current login and password system with a more secure and efficient AD authentication mechanism. This upgrade is critical for enhancing the security and user management of our application. Project Objectives: • Seamless Integration: Implement AD authentication to allow users to log in using their existing Windows credentials, eliminating the need for a separate login and password for the application. • Security Enhancement: Leverage the robust security features of Windows AD, including Kerberos and LDAP, to protect user data and access. ...
Looking for someone with good skills in Airflow, Pyspark and SQL.
As a project initiator, I am looking for an innovative graphic designer to craft a sticker design that eloquently showcases the values and various roles within our college department. The sticker should: -We want 4 people two men and two women of all different ethnic backgrounds and races. - Depict these four roles: someone holding a map , a scuba diver, a person holding a butterfly net and a person with a rock hammer. -This should be in a cartoon style and in color - It should be a 2.5” or 1040 x 520 sticker The ideal freelancer for this project would be someone with a keen eye for detail and a strong understanding of graphic symbolism.
I am in need of a proficient Power BI specialist to create a comprehensive dashboard for my business. This project will involve reading unidentified data sources which can be in the form of Excel files, databases like SQL Server, or Web services such as APIs. Due to business confidentiality, I cannot disclose the exact nature of the data sources at this stage. However, prior experience working with diverse and varying data sources will be ideal. The dashboard should be designed to include a variety of visualizations — specifically, bar charts, line graphs, and pie charts . The exact data and metrics required to be highlighted on the dashboard cannot be stated at this moment, but the expert should be well versed in presenting a multitude of business parameters that typically...
I'm looking for a skilled Strapi developer to address several issues with my current website and make significant improvements to its functionality and overall user experience. Main Issues: - Slow loading times and security vulnerabilities - Difficulty in updating content - Need for enhancement in function and CRM - Improvement in form submission process Desired Changes: - Redesign the website's user interface, making it modern, intuitive, and user-friendly. - Add new innovative features to the platform, with a particular focus on features that cater to a Study Abroad Website audience. - Successful integration with third-party CRM to streamline data flow and improve customer data management. - Improvement in the form submission process to ensure greater user engagemen...
...dashboard using data from SQL databases. The ideal candidate should have strong skills in SQL and Power BI, with a strong understanding of customer data analysis. The project will require: * Designing a Power BI dashboard to visualize our SQL database. * Selecting specific information from the SQL databases for display on the dashboard, mainly focusing on customer data. * Performing analysis on specific aspects of customer data. SCOPE OF THE WORK: * Data Analysis: Analyze customer demographics and customer behavior trends within our SQL databases to identify useful patterns or insights. * Dashboard Design: Create a dashboard that presents this data in a meaningful and digestible way. The ideal freelancer should: * Have a proven track record with ...
I am in need of an experienced developer with strong skills in .NET and SQL. My project currently has some issues that I am unable to resolve on my own. Work needs to be done on my premises in Las Vegas. Key Tasks: * Debugging: The application has been developed but is encountering syntax errors and runtime errors which need resolution. Ideal Skills and Qualifications: * Strong experience with .NET and SQL * Proven debugging and problem-solving abilities * Knowledge of application development and programming languages If you have the ability to quickly identify and fix these issues, I would love to hear from you. Please share examples of similar work you have completed. Thank you.
