Crosstab query sql server 2008công việc

...clear report on insights and suggest changes to team composition, drop spots, in-game decisions. **Project Deliverables** * Structured dataset in Google BigQuery with our team's gameplay stats + relevant opponent data. * SQL queries designed for meaningful performance insights. * Analysis reports with visualizations focused on: * Player performance over time * Our strengths and weaknesses * How we compare to top teams * Map rotation analysis with suggested changes * Final presentation summarizing key findings & action plan. **Required Skills** * Expert SQL and querying, especially Google BigQuery. * Strong analytical skills with statistics experience. * Passionate about PUBG Mobile - understand gameplay and competitive scene. * Ability to turn...

I am looking for a PERL, HTMX, MYSQL programmer who can help me with an intermediate level project. The ideal candidate should have experience in these areas and be comfortable starting a project from scratch. I will give you a dump from my MySQL table. From which I need an interactive HTML inter...entries into one, all via one HTML::Template file with a single perl script as interface to the MySQL table. I do want an active submit button for all changes, as well as a single interactive upload button for each field of the MySQL table. also each field needs to be validated via a given specification. All code needs to be well documented and commented. Perl based database interaction needs be "SQL Injection" save. So i want a maximum of 3 files. HTML page, stylesheet and cgi...

Vui lòng Đăng Ký hoặc Đăng Nhập để xem thông tin.

Vui lòng Đăng Ký hoặc Đăng Nhập để xem thông tin.

Hi Yusuf A., I noticed your profile and would like to offer you my project. We can discuss any details over chat. Procedure:  Upload Excel file containing Expediente Codes  Use automation and OpenCV to solve Captcha and download files  Upload files to s3 bucket  Integration with existing system query api sunat use email for login

I need an in-depth and comprehensible 2000-word report on relational databases. This should include: - A focus on normalization and handling of relational database constraints. - An E-R diagram and an SQL query. The project description doesn't specify requirements for these, so use your expert judgment to determine what is necessary. - The report should also be accompanied by a 15-slide PPT presentation summarizing the report's highlights. Ideal Skills & Experience: • In-depth knowledge of DBMS • Expert understanding of relational databases • Proficiency in E-R diagrams and SQL query • Excellent report writing skills • Experience in creating engaging PPT presentations.

I'm seeking a professional who can help me craft a comprehensive 2000 word report on Database Management Systems (DBMS). The report needs to cover the key concepts of DBMS, including E-R Diagrams, Normalization (3NF), and crucial SQL queries. The report should be well-researched, well-structured, and free of any plagiarism. I also need a PowerPoint presentation to be created, consisting of 15 slides based on the content of the report.

I'm looking for a GoLang expert to assist me in developing a cutting-edge IPv6 proxy server. The main aim of this project is to enable users to access IPv6 websites efficiently. Key Project Requirements: - **GoLang Proficiency**: You should have a deep understanding of GoLang, particularly in terms of its concurrency support, networking capabilities, and memory management. - **IPv6 Experience**: Prior experience with IPv6 implementation and networking is highly recommended. - **Proxy Server Development**: Experience in developing proxy servers will be a definite advantage. - **General Internet User Focus**: The server should be user-friendly and accessible for general internet users. - **Developer and Tester Friendly**: It should also cater to the needs of devel...

I am looking for an expert to automate my daily incremental SQL scripting to extract multiple tables from my ERP system, and export them to CSV files. Key Requirements: - The system in question is Progress/OpenEdge. - The extraction should include tables such as Customers, Orders, Products, General Ledger detail, Job Costs, Invoicing, and Budgets. - The script should be set to run on a daily basis. I need a freelancer who: - Has a strong grasp of Progress/OpenEdge. - Has experience with automated SQL scripting. - Can efficiently export data to CSV files.

I'm currently seeking a skilled database specialist who can write sql query and can give me ai free report around the entity relationship diagram and normalisation. I need a 2000-word report + 15-20 slides presentation Objective: This assignment aims to enhance your understanding of database design through the practical application of Entity-Relationship Diagrams (ERD) and normalization techniques. You will work in groups to design a database system that is both efficient and scalable, addressing a real-world problem scenario provided below. Assignment Scenario: Your team has been tasked with designing a database system for one of the scenarios listed according to your group number; if you are in group N, you must choose scenario N. For example, Group 10 must choose S...

I require a skilled developer to address my Breakdance Builder issue urgently. Here are the specifics: - I am currently unable to retrieve specific content using the existing query to get taxonomy (Meta Box) content in Breakdance Builder. - I prefer the method of rewriting the query from scratch. This way, we can avoid any potential issues within the existing query and ensure the accurate retrieval of specific content. Time is of the essence for this project, so I need someone who can commit to completing it ASAP. Ideal Experience: - Proficiency in Breakdance Builder - Strong background in PHP and MySQL - Previous experience with Meta Box - The ability to work quickly and efficiently Please get in touch if you have the necessary skills and can commit to this projec...

I'm in need of a proficient PowerBI analyst who can effectively connect to different data sources: Excel spreadsheets, SQL database, and CSV files. Your tasks involve creating detailed reports and conducting: - Sales performance analysis - Financial dashboards - Customer segmentation I have a preference for Bar and Pie charts in the visualization of these reports. Ideal applicants should have valuable experience in these fields and have an innate knack for making data comprehensible. Excellence in the mentioned chart formats is paramount. Having a solid background in Excel, SQL and CSV data manipulation will be a plus.

We are in the initial stages of launching an exciting e-commerce project aimed at enhance the online shopping experience. Technical Aspects of the Project: - Development of a browser...development with JavaScript, HTML, CSS, and modern frameworks (React, Angular, Vue.js). - Proficiency in backend programming, particularly with Node.js or Python. - Strong understanding of RESTful API design and development. - Experience working with cloud services (AWS, Azure, Google Cloud). - Skills in data analysis and machine learning are a plus. - Proficiency in database management, especially SQL and NoSQL databases. If you are passionate about technical innovation and want to be part of a team striving to change e-commerce, please announce your interest and state previous experience wihtin ...

I am looking fo...looking for technical help to address and solve a persistent connection error that occurs on my Android device - a smartphone. The primary issue lies in the fact that the phone fails to establish a successful connection to the server. The nature of the server is slightly ambiguous as I'm not quite sure. • Requirements: - Experience with Android systems - Deep understanding and expertise in server connection dynamics - Ability to accurately diagnose and resolve server connection issues • The immediate task is to: - Identify why my smartphone cannot connect to the server - Implement a foolproof solution that will ensure a smooth and reliable connection in the future. Skill in android development, networks, and pro...

I am seeking an expert who can integrate SSL 3.0 into an existing Laravel installation on my local Wamp server. I have installed Laravel already, but now I require enhanced security through SSL. The purpose for this task is strictly to increase the site's security. No other modifications or tasks need to be carried out. Comprehensive knowledge and prior experience with Laravel, Wamp server, and specifically SSL 3.0 integration are mandatory for this job. Key Requirements: - Proficiency in Laravel - Previous experience with Wamp server - Experience in SSL 3.0 integration - Able to execute task quickly and proficiently - Enhanced concern for site security

I am working on React JS with Javascript Development Project. I need someone to Support me for this Project atleast 4 to 5 hours Per day. Project will Exist more than 2 years. I need support through Remotely(zoom). I am looking for Good Experienced(4+ years) Person as a Frontend Developer, Who can work on the tasks ...Experienced(4+ years) Person as a Frontend Developer, Who can work on the tasks Quickly. I am looking for Long term relationship. After this Project Completed means, we will give immediately another support project. I will Give you the Sample Task for 1 Hour, If you Completed ON TIME means we will give you the Project. Required Skills : React JS, HTML, CSS, Javascript, Cypress Test Cases(Mandatory), SQL Basics Language Speaking Person : English Note: I will pay on ho...

I've developed ...once I upload it to the server. The server in question is hosted on Hostinger. I'm unsure if any changes have been made to the server configuration file. Key Points: - Troubleshoot the server upload issue - Resolve discrepancies between local and online versions - Clarify if server configuration files have been altered - Ensure the webpage functions as intended on the server Ideal Freelancer: - Experienced in HTML, CSS, and JavaScript - Proficient in server hosting with Hostinger - Skilled in server configuration file troubleshooting - Capable of identifying and correcting server-side programming discrepancies I'm seeking a professional who can quickly pinpoint the problem, resolve it, and m...

...corresponding php file/path on the server and correct it, so that the balance uploads correctly when uploading the customers on the ASTPP both for prepaid and postpaid customers. Positive balance must upload as positive balance. Negative balance must upload correspondingly. 0 uploads 0. You need to make a detailed document how to do that on any ASTPP server, so that someone without technical knowledge takes the document, follows it and gets the same working on the other ASTPP server. Example of the document: Someone from our side will try to upload customers on the provided server to make sure it works, if yes, then we will take your document, which you provided and will correct the balance upload on other ASTPP server following the doc, if that

...Python coder who can develop a program that effectively reads numerous reviews and generates a concise summary, encapsulating the main points in 300 words in multiple bullet points. Key Functions: - Extract data from a relational database via SQL queries. - The ability to process and analyze reviews from different platforms such as blogs, social media, and online stores. - Generate a coherent 300-word summary from a multitude of reviews. Required Skills and Experience: - Expert level understanding of Python programming. - Knowledge and experience in SQL querying is a necessity. - Experience with Natural Language Processing for summarization. - Familiarity in dealing with relational databases. - Prior experience with text summarization or related projects is a definite ...

I'm in need of an expert to set up SQL Server 2019 on a Windows-based virtual machine. The system will be used to support website and desktop applications. Key Responsibilities: - Configuration of SQL Server 2019 on a Windows virtual machine - Ensuring secure and optimal performance of the system - Testing the setup to confirm seamless connectivity with website and desktop apps Ideal Skills: - Extensive experience in managing SQL Server 2019 - Expertise in Windows OS and virtual machines - Should have strong troubleshooting skills on SQL server - Familiarity with website and desktop app integrations.

Excited to work with an experienced ASP.Net webforms developer, who will bring their skills to facilitate the Database integration aspect of our project. Key Responsibilities: - Integrate SQL Server with our existing ASP.Net project. - Create smooth and efficient functionality. - Ensure system robustness and efficiency. Skills and Experience: - Strong proficiency with ASP.Net Webforms. - Knowledge and hands-on experience working with SQL Server. - Excellent troubleshooting capabilities. It is not necessary for this project to migrate data from an existing database to SQL Server. However, the capability to do so may be beneficial in the future. If you are an experienced developer with the aforementioned skills, I would love to have you on bo...

As a Windows user with IIS 10, I am in need of a professional who can help me configure the server properly. My main goal is to host a website, and domain mapping is an essential part of that process. Key Responsibilities: - Map domain to the IIS server - Ensure website is accessible via the domain - Handle any other essential configurations for smooth website hosting Ideal Skills: - In-depth experience with IIS 10 - Proficiency in Windows server administration - Strong understanding of domain mapping - Good communication skills to ensure smooth interaction and understanding of the task. Project Detail as below, I have my own Windows Server and I am using IIS for website deployment. I have a total of 5 websites. Currently, I am using a static IP with differ...

I'm in search of a highly skilled server engineer who understands VPS and email servers. The current system I have in place with Contabo and Zimbra is unreliable and requires daily restarts, clearly, this is far from ideal. Your task will be to either create a stable setup with the current tools, or propose and implement a new, more reliable solution. Key Aspects: - High uptime: The system should rarely, if ever, require manual restarts. - Scalability: While the exact number of email accounts needed is not yet determined, the setup should be highly scalable to accommodate growth. Support: - Although no specific level of support was specified, basic troubleshooting is expected as part of your proposal. Higher level support options can be discussed based on your recommendat...

I'm on the hunt for an experienced JavaScript developer. While the exact functionality isn't fully defined, the project will involve server-side JavaScript application development. Unfortunately, I do not have any specific JavaScript functionality or purpose to provide at the moment. Ideal Skills: - Strong experience in JavaScript, preferably in server-side environments - Capacity to discuss functionality possibilities and advise on solutions - Proactive, able to operate effectively with minimal project-specific guidance. Please use your proposal to demonstrate your JavaScript know-how and experience with server-side applications. Show me that you can figure out and build the functionality we need.

E-comerce hecha con React, Tailwind CSS , Framer Motion y cuenta con un chatbot con IA como asistente virtual En el Backend cuenta con una base de datos SQL y node Js y Javascript para la conexión a la BD Tiene una auténticacion de usuarios Y cuenta con integración a MercadoPago

I'm in need of an experienced SQL developer who can assist with writing stored procedures in SQL Server. The purpose of these stored procedures is for data loading. Key Responsibilities: - Writing stored procedures for data loading Ideal Skills & Experience: - Proficient in SQL and SQL Server - Prior experience with writing stored procedures - Experience with data loading processes The complexity of the stored procedures is expected to be at the basic CRUD operations level. As this is focused on data loading, it requires someone who is meticulous and well-versed in data manipulation within a SQL environment.

...create a chatbot whatsapp business integrated with Mikrowisp The chatbot will serve as a tool for registered companies to interact with their customers. Key Features: - Options menu: The chatbot must provide the options menu, and a limit of queries to exit the chatbot and transfer the advisor. - Invoiced amount query: The chatbot must provide users with a simple way to find out the amount owed and due date. - Consultation of the user profile: The chatbot must respond to the contracted profile. - Spanish Support: The chatbot needs to be capable of interacting with users in spanish - Company Management: The ability to enable, disable, or delete companies from using the chatbot should also be integrated. Ideal

I'm looking to create an application using NoCode developmen...credentials are securely handled and stored. Experience with implementing this in a NoCode environment is a must. - Database Integration: The project will make use of an SQL Server. The freelancer should be able to efficiently integrate and manage an SQL Server database with the NoCode tools. Previous experience with SQL Server is required. - We need to integrate some process, after all, we need to implement the solution in Azure. In summary, I'm looking for a freelancer who is skilled with NoCode tools, specifically Bubble and FlutterFlow, has implemented email/password user authentication before, and has experience with SQL Server database management. Ple...

I want to... Features: * E-mail me the Lead with all information collected * Save in Google Sheets as a database * Main thing is to have it look nice and don't look out of place, similar font style, sizing, font size, etc * Use embed code to copy and past into my page builder * Create a plugin to help me customize the quiz, like images, text & size, etc. Desired Programming Language: PHP / SQL * 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 Complete, After any Bug fixes, and Updates ⭐⭐⭐⭐⭐ Please post "I've read everything" when applying to be considered, too many bots applying. Failure to do this step, you will not be contacted ⭐⭐...

I'm in need of an experienced PowerShell script writer, specifically for Power BI associated data management tasks. As part of the project, code will be required to execute the following tasks: - Data extraction from Ex...experienced PowerShell script writer, specifically for Power BI associated data management tasks. As part of the project, code will be required to execute the following tasks: - Data extraction from Excel files, CSV files, and SQL databases - Transformation of data, including extraction and update of parameter values from Data Models in each Workspace Ideally, the freelancer would carry a strong understanding and hands-on experience with PowerShell scripting, Power BI, data transformation techniques, and working with database source files like Excel, CSV, a...

...a local printer working and it may have disrupted the normal operation of the server. I am currently dealing with an issue where my centOS mail server has just gone offline. It seems to be a connection issue as the error message I am receiving is that connection is timing out. This issue started occurring right after some changes were made to the server configuration. Specifically, some settings were modified which seems to be the root of the problem. I need an expert who can swiftly and accurately identify the problematic changes and rectify them. Key Qualifications: - Strong knowledge on centOS mail server configurations - Experienced in troubleshooting and resolving mailserver issues - Expertise in server and network configurations - Previous e...

...this metadata to construct and manage API endpoints dynamically. 4. ORM Flexibility: Any ORM tool like Entity Framework, Dapper, or SQLkata can be utilized to facilitate database operations. The choice of ORM should align to optimize performance and simplify maintainability. 5. Advanced Data Handling: Column Selection: API users should be able to specify which columns to retrieve in the query. Filtering and Sorting: Support comprehensive filtering and sorting capabilities to navigate through data efficiently. Pagination: Implement pagination to handle large datasets effectively. Aggregation and References: Enable aggregation of data from child tables and retrieval of related data from master tables (e.g., retrieving a customer's name when querying...

For my current project, I require an expert who's proficient in DOMO Beast Mode and SQL. The tasks will primarily involve: - Producing calculated fields: You will need to execute both complex mathematical calculations, as well as intricate string manipulations. A good grasp of mathematical principles and string handling in SQL is a must. - Transforming data: This job will further entail the aggregation of data. Being adept in grouping and managing datasets of diverse sizes will be crucial. Your comfort in working with DOMO, SQL, and data manipulation will be the key to successfully accomplishing this task. If you routinely perform these tasks and understand the underlying processes, I would love to connect and discuss the project further.

Básicamente quiero que me ayuden a crear la base de datos para un gimnasio en SQL server

I require an expert proficient in Python, SQL, and Java to work on a Codility assessment. The assessment will be conducted at an intermediate level and will be inclusive of various tasks that I will be solving in the language of the question. Key Requirements: - Comprehensive Knowledge in Python, SQL, and Java - Proficiency in tackling Codility assessments - Understanding of the assessment's specific concepts and frameworks Remember to adhere to Codility's test format and code-writing guidelines. Your completion and success of this project will greatly depend on your ability to grasp and execute these particularities.

We are looking for a better solution than ordering shared hosting accounts for each domain. We have many woo-commerce webstores that all run off different domains on different servers. We want to move all websites to the same server, and still have them run at optimal speeds. We need someone to make proper suggestion (such as a dedi server) and have the ability to set it up, migrate websites, configure domains, etc. Please be sure to add WCMGRT1 to your bid or it will be considered spam, ignored and removed.

I need assistance to solve three coding tasks using Python, Java, and SQL. The challenge involves - Analytical problem-solving - Implementing quality checks - Code compilation The challenges require proficient skills in the aforementioned languages, while also ensuring code efficiency. Prior experience in problem-solving and understanding how to efficiently check and maintain the quality of code is a big plus.

Skills -core php, laravel, Codeigniter my sql database Min 1 to 5 year experience location - Mohali,Punjab, India

AWS to New cloud server migration-Django & Reactjs Server setup Code migration and setup SSL certificate - 1-year plan 50 /year

Title: Demystifying Bitcoin: A Comprehensive Guide to the World's Leading Cryptocurrency In the realm of digital currencies, Bitcoin stands as the pioneer, the trailblazer that sparked a global financial revolution. Born out of a white paper titled "Bitcoin: A Peer-to-Peer Electronic Cash System" published by the mysterious Satoshi Nakamoto in 2008, Bitcoin has evolved from a concept into a phenomenon that has reshaped the landscape of finance, technology, and beyond. Understanding Bitcoin: The Basics Bitcoin operates on a decentralized peer-to-peer network, utilizing blockchain technology to facilitate secure and transparent transactions without the need for intermediaries such as banks or governments. Unlike traditional currencies, which are controlled and regulat...

Title: Demystifying Bitcoin: A Comprehensive Guide to the World's Leading Cryptocurrency In the realm of digital currencies, Bitcoin stands as the pioneer, the trailblazer that sparked a global financial revolution. Born out of a white paper titled "Bitcoin: A Peer-to-Peer Electronic Cash System" published by the mysterious Satoshi Nakamoto in 2008, Bitcoin has evolved from a concept into a phenomenon that has reshaped the landscape of finance, technology, and beyond. Understanding Bitcoin: The Basics Bitcoin operates on a decentralized peer-to-peer network, utilizing blockchain technology to facilitate secure and transparent transactions without the need for intermediaries such as banks or governments. Unlike traditional currencies, which are controlled and regulat...

I'm looking for someone who has very good experience in Laravel's real world situation. What Queue drivers are available in Laravel? Will ignore any ...Queue drivers are available in Laravel? Will ignore any replies without answering to the above my question. Here is my problem now. We are using Laravel project and it's running on production. It's using Queue heavily and queue driver is database now. We are getting following issue. SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction (Connection: mysql, SQL: select * from `jobs` where `id` = 111111 limit 1 for update) Let me know how to fix this then I will hire you immediately and you can be employed in our project. Please don't waste my time if you don't know...

I'm in need of assistance with Codility assessments, specifically focusing on intermediate-level problem-solving tasks. Your work should encompass: - Expertise in SQL or Python. Familiarity with both languages is advantageous. - Proficiency in algorithmic programming, capable of thinking strategically to solve intermediate-level problems. - Ability to assist in solving three different task types in Codility, including: 1. Time complexity problems 2. Sorting and searching problems 3. Counting elements problems Ideal candidates would have experience preparing or mentoring for codility assessments and a strong background in programming. Your intricate knowledge of problem-solving within the realms of algorithmic programming would be highly beneficial. A methodical appro...

I urgently need an expert Laravel developer to collaborate on a web application development project. The specific features and ...an expert Laravel developer to collaborate on a web application development project. The specific features and functionalities of the project are yet to be defined, but a vast knowledge in Laravel is key. Key skills and Experience: - Proficiency in Laravel and PHP - Understanding of MVC design patterns - Knowledge of front-end technologies, such as JavaScript, HTML5, and CSS3 - Familiarity with SQL/NoSQL databases - Excellent problem-solving skills The timeline for this project is ASAP, so the ability to work under pressure is required. If you have experience in web applications, APIs, or both, it will be advantageous. Let's collaborate on this ex...

I need a pro that can explain me how server actions work I have already a boilerplate project and a task to put a user in a user group we will work over screen share as a consultant First trial hour price

I need a pro that can explain me how server actions work I have already a boilerplate project and a task to put a user in a user group we will work over screen share as a consultant

I'm currently facing an issue with high CPU usage affecting my server. This has led to a significant slowdown in my website's performance and I am needing an experienced Laravel developer to assist in resolving this. Key responsibilities will include: - Diagnosing the root of the high CPU usage - Implementing improvements to rectify the issue Regarding server load, I've not been able to identify the precise figures. This project does not involve working with any established caching mechanisms as none are currently being used. Essential skills and experience: - Proficiency in Laravel - In-depth understanding of server operations and CPU usage - Proven record of successful server optimizations - Familiarity with CyberPanel and OpenLiteS...

I need a simple form that will look good on a small screen iPhone and also a big screen iPad. The form will collect NAME EMAIL CITY PHONE NUMBER phone number will be a formatted 10 digit max, and email will need validation for properly formatted. This will take the data and post it to our existing base and ...then auto redirect to the form page. The form page will look neat and clean and also contain a couple lines of text and our logo. You will use the existing config file to connect to our base, instead of creating a new one. This project needs completed today and should only take an hour to complete. This is to be written in php 8.2 and connected to sql dbase. You will be paid $30 when it is complete and verified to be working on our server. Ping me if you can co...

...take part in my ongoing web development projects. The main goal of the project is to enhance an existing application. Requirements: - Proficiency in .NET for backend development - Strong experience with Angular for frontend development - Excellent understanding of SQL Server and MongoDB databases - Previous work with DevExpress is essential Your responsibilities will include: - Developing APIs using .NET for enhancing the application - Integrating Angular for improving the frontend - Ensuring seamless operation with SQL Server and potentially MongoDB Ideal candidates should have a strong understanding of web development and be able to contribute effectively to enhancing the current state of the application. The ability to work with a team, meet deadline...

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.