Sql aggregate functions työt

Change our current user and customer portal php project to laravel framework and make sure all functions work.

Usealla isolla yrityksellä on käytössään Suomessa eräänlainen heidän alansa ERP-paketti, joka on koodattu Visual Basicillä. Tarvitsisimme VB-osaajaa ylläpitämään ohjelmistossa mahdollisesti tehtäviä muutostöitä. Tekniikka lyhyesti: • Visual Basic -koodia noin 280-290 000 riviä • Integraatio taloushallintoon ja palkan maksuun • raporttipuolella n. 50 000 riviä • Crystal Reports • Microsoftin SQL Server -kanta Työmäärät vaihtelee, mutta keskimäärin 1-2 päivää/viikko. Välillä hiljaista.

Meillä on kaksi yritystä järjestelmässä, joilla on omat varastokirjanpidot ja osto-&myyntitilauksensa. Lokaalina serverinä toimii Windows 7 ympäristössä, visma Nova pro 9 (Windows sql server). Mikäli työn suoritus vaatii jonkin tietyn ympäristön niin kysele. Haluaisimme ajoitettuina tehtävinä ajaa allamainitut skriptit jotka muodostavat CSV tiedostot jotka on tarkoitus lähettää sähköpostina eteenpäin. Skriptin asetusten muokkaus skriptin alussa. Muuttujat ja funktiot kommentoituna. Lisätyönä voi tarjota näiden tiedostojen automaattista lähettämistä (Tiedosto liitteenä + leipätekstissä luettavasti muotoltuna). --------------...

Webservicen luominen sql tietokannalle. Perus toiminnot webservicelle ja kehitys ympäristön pystytys. Tarkempi speksi on saatavilla NDA:n kirjoituksen jälkeen. Kehitys mielellään Eclipse ympäristössä.

Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.

Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.

Excel Add-In joka hakee ja tallentaa taulukkomuodossa olevaa dataa Azure SQL-kannasta/-taan. Lisäksi ohjelmallista Excel muokkausta ja hallintaa C#-koodilla. Osaan Excel muokkauksista valmis VBA-script, joka muutettava C#-kielelle. Visual Studio 2015 alkukoodi, SQL Azure tietokanta ja kyselyt valmiina.

Java, J2EE, JDBC, SQL, java Threading,GWT,Html,CSS

Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)

Moi! Osaatko kuinka hyvin sql:n perusasiat? Onnistuuko asentaa tietokannan hallintajärjestelmä, luoda ja hallinnoida tietokantoja sekä käyttäjätilejä ŠŠ ,seurata ja optimoida tietokannan toimintaa. Jos perusasiat hoidossa niin ota yhteyttä :)

Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)

Käytössämme on WordPress teema, johon haluamme muuttaa ja lisätä muutamia toimintoja. Tehtävä ei vaadi lainkaan visuaalis...toimintoja. Tehtävä ei vaadi lainkaan visuaalista osaamista, vaan tehtävänäsi on parantaa/lisätä sivuston toimivuutta. Esimerkiksi: Hakukentän teko dropdowneilla ja checkboxeilla... Toimintomme sivustolla muistuttavat paljon :n toimintoja. Vaadittavat taidot: -WordPress -PHP -Javascript -jQuery We are currently using WordPress theme, and we would like to add and modify a few functions. Job doesn't require any visual expertice. Your job is only to improve/increase the website's functionality. For instance: Create a search box with dropdowns (Categories and Location) ...

...secondary functionality for flight tracking. The app should be able to link to flight schedules, write the time and date of a passenger's landing, and store it for the driver to ensure the accuracy of the pick-up time. The skills required for this job include: - Strong experience in app development, particularly in location-based services. - Proficiency in integrating GPS services, date and time functions, and camera functionalities. - An understanding of flight tracking systems and their integration into applications. As the user interface is of paramount importance, I'm looking for someone who can create an engaging and intuitive design. Your previous experience and expertise in this area will be key to the success of this project. Please include relevant experienc...

I'm looking for a skilled software developer to create a Windows application that focuses on generating data reports from a SQL database. Key Requirements: - The application must be compatible with the Windows platform - The main functionality of the application should be the generation of data reports. - The reports should be sourced from SQL database. Ideal Skills and Experience: - Proficiency in Windows application development - Strong knowledge and experience with SQL database and report generation - Previous experience with data reporting software would be a plus.

I'm in need of a Junior Full Stack Engineer who is proficient with Java, with beginner level experience. The primary task will be to work on implementing Go Live for an assigned project. Ideal skills for the job: - Understanding of Java programming language - Ability to work collaboratively on a team - JSON - XML - SQL - Data Mapping Some experience with project implementation is a plus. Dedicated beginners are also welcome to take their first steps in a real project.

I'm having an issue with the cookie bar on my landing page. It functions perfectly upon my primary website, but fails to operate as expected on my subdomain, specifically my landing page. I am using the exact same JavaScript and CSS script for both the website and landing page. All is built on custom HTML. Ideal skills for this job: - Expertise in JavaScript and CSS - Vast experience in handling cookie bars and similar web components - Ability to diagnose issues affecting custom HTML websites The selected freelancer will be tasked with: - Understanding the functionality of the cookie bar on my main website - Translating the same functionality to the landing page - Uncover and solve any underlying issues or differences causing the functionality mishap Please note that I'...

Hello, I have a dating app that was developed 4 years ago and is published on Google Play. It was made in JAVA, but now the version is depreciated on the market. What I want for this app is to rewrite the code using Kotlin or Flutter, because this app was made in Java 4 years ago. Within the app it has many functions. Apply for this project and tell me the price at which you would do it. and The estimated time. - Implement in the app (Membership - payment plan with Google)

I have a private football...private football manager game online. Written in PHP and TWIG. The script has already been adapted to PHP 7 (from PHP 5). 1. Now it has been noticed that 1 function, 1 module does not work properly under PHP 7. This module needs to be adjusted. 2. I need a few minor adjustments and functions in the game and in the admin area. 3. Then I would like to have a new module. A calendar where you can see the days and what matches you have on those days. (Read from the existing database and display). And with some functions. You have to know that every extension to this script will be written in modules. These are then copied into the directories and taken over by the main script. Who can help? Further information and sample images if you are intereste...

Looking for a Google Cloud Platform (GCP) expert who can assist with Cloud Functions and Vision API integration and deploy function on google cloud - Your main focus will be integrating Vision API for images batch processing and setting up Cloud Functions. The urls of images will be in excel file in google cloud. The parse result to be placed in columns next to url column. - The data primarily processed with text detection. Ideal Candidate: - Proficient in GCP services, specifically Cloud Functions and Vision API. - Experienced in setting up GCP services for one function. - Skilled in implementing Vision API for image processing. - Strong understanding of data processing in GCP.

I am looking for a skilled and experienced Full stack developer with Hands-on experience in Java Hands-on experience in Angular/ REACT Hands on experience on AWS RDS/AWS S3/Oracle/AWS Athena/ SQL In-depth knowledge in Core Java, Spring framework and RESTful API Services, Apache Camel, CI/CD Jenkins, Containerization Experience with AWS Cloud and its services like EC2, Athena, Lambda, S3, SQS and Cloud Formation Experience in writing JUnit test cases Problem-solving abilities

...5 high-quality photos of the product that showcase its features and benefits, ultimately encouraging potential customers to make a purchase. - Develop a product demonstration video that highlights the key attributes of the product in an engaging and informative way. - The photos and video should be designed to enhance the listing's conversion rate, by effectively demonstrating how the product functions and why it's a worthy purchase. Ideal Skills and Experience: - Proven experience in creating Amazon product listings, particularly with a focus on increasing sales conversion. - Proficiency in product photography and videography, with a strong portfolio to match. - An understanding of e-commerce and the triggers that influence customer purchasing decisions. - Creative th...

I'm searching for a professional well versed in Excel to help with lookup functions. I'm struggling with finding matching values and retrieving data from different worksheets in a text-based file. Key parts of this project: - Locating matching values across two worksheets - Retrieving needed text data from another worksheet The ideal candidate will have: - Strong proficiency in Excel lookup functions - Experience dealing with data across multiple worksheets - Understanding of text-based data within Excel

...frame. #Requirements: - Extensive experience as a Data Engineer, Database Architect, or similar role with a strong focus on rapid project execution. - Expertise in handling tight deadlines and delivering complex projects quickly. - Strong understanding of API integrations and experience with RESTful services. - Proficient in relational database design and development, preferably with experience in SQL and NoSQL databases. - Experience with ETL tools and processes under strict time constraints. - Familiarity with CRM and MAP platforms like Salesforce and HubSpot. - Capable of creating detailed entity-relationship diagrams and data flow diagrams quickly. - Excellent problem-solving skills and ability to work independently in a fast-paced environment. - Fluent in English with outst...

...tablet. - requires the user to make an account with the website before its use. I am currently designing the website, and looking for this program to be created externally on wordpress or whichever way will fit in the budget. Important: Please only consider this project if you will are okay with the budget, and have read through the project outline. Thank you. Project details: basic functions: (the main function is to show what time the user has to work on their goals, and generate a schedule for them to use, factoring in all their tasks in their daily lives) - asks for users input on 'how disciplined are you, what are your goals, tasks needed to complete the goal, what time do you want to get up in the morning, what are your unavoidable duties, how many hours of s...

I'm reaching out through this...which currently exists as a WhatsApp group, to have access to profiles where they can comment on products, engage in forums, and build communities. The functionality required is as follows: An internal client area providing information about the user's account (already created on () but requiring additional information specific to this platform). Image galleries and sliders. Social functions such as social media sharing buttons, activity feeds, or real-time comments. This will be a section within their own website, available in both Spanish and English. They have their own CRM system where any forms or information needed will be connected. They have a server hosting the current website, and this community platform will also be hosted on th...

As part of my project, I need an expert in Excel to type data from various digital files into a spreadsheet, e...data will be utilized for basic data analysis purposes, so it's important that the freelancer is comfortable with working on this type of data. Key Requirements: - Converting data from various digital files (PDF, Word, etc.) into an Excel sheet. - Proficient in using basic Excel formulas and functions to manipulate data for analysis. - Attention to detail and accuracy are critical for this task. Ideal Skills and Experience: - Proficiency in Excel - should be able to work with basic formulas and functions. - Prior experience in data entry or data analysis is a plus. - Strong attention to detail to ensure accurate data entry. - Ability to work efficiently to m...

I'm looking for a skilled mobile app developer to create a versatile and user-friendly invitation app that can be used across multiple occasions including weddings, birthdays, and more. Primary Functions: - Sending digital invitations - Managing RSVPs Key Features: - Compatibility with both iOS and Android - Advanced level of customization for the invitations (custom designs and layout) Ideal Skills: - Proficiency in mobile app development for both iOS and Android platforms - Experience in developing apps with complex user interfaces for high customization - Knowledge of managing user data and RSVP systems - UI/UX design experience to ensure a seamless user experience - A keen eye for detail and the ability to achieve a polished final product If you have the required skill...

I'm looking for a seasoned app developer to create a mobile application that functions similar to Instagram. The app should be compatible with both Android and iOS systems. Key features of the project should include: - Video sharing capabilities - Creation of user profiles - Various filters and editing tools for enhanced media uploading experience - Seamless social media integration for easy login and registration and Data fetching As for the user interactions, I'd like a direct messaging system for the users to communicate and an option for them to save their favorite posts. People should also be able to view posts they've liked in the past. The ideal person for this job should have extensive experience in mobile app development, particularly with social media a...

I'm seeking an experienced .NET developer with over 4 years of expertise in C# programming and SQL databases. Key Responsibilities: - Enhancing existing software application - Adding new functionalities The ideal candidate should possess: - Strong experience in C# programming - Solid knowledge and practical experience with SQL databases Be ready to dive into the project and help us bring significant functionality enhancements to our existing software. Your experience and skills in C# and SQL will be invaluable in this task.

I need a talented VB.net developer with a strong background in SQL Server. Key Responsibilities: - Develop software applications using VB.net - Efficiently manage databases - Designing, coding, testing, and debugging software applications using VB.NET. - Calling third-party API - Payment gateway integration - Stored Procedure Ideal Candidate: - Proven experience in VB.net development - Strong familiarity with SQL Server - Good problem-solving skills - Ability to work independently and meet deadlines. Please provide relevant work samples in VB.net development and describe your experience with SQL Server.

I need a proficient Matlab coder to assist with debugging my existing Matlab code which is currently undergoing some issues. Here's what needs to be accomplished: - Debugging: The code needs to be thoroughly examined for bugs and the cause of the malfunctions need to be rectified. - Adding New Functionality: Progressive functions need to be infused into the existing code to improve its overall productivity. - Optimization: In order to expedite the execution process, the overall performance of the code needs to be enhanced. The ideal candidate should not only possess substantial experience in Matlab coding, but must also be dexterous in debugging and optimizing for performance improvement. Prior experience in adding new functionalities will be highly advantageous.

I need a detail-oriented professional to help with my bookkeeping and prepare financial statements using Excel. Key Responsibilities: - Regularly update my Excel spreadsheets with day-to-day transactions - Prepare monthly financial statements for my business Ideal Skills & Experience: - Strong Excel skills, including advanced functions and formulas - Experience in bookkeeping and financial statement preparation - Attention to detail and a good understanding of accounting principles Please note: - The role is likely to require around 10 hours of work per month - I may consider transitioning to a more robust accounting software in the future, so experience with QuickBooks or Xero would be a plus.

I need a specialised web developer with experience in creating business websites. The main target audience for my website will be the general public. The chief functions my website should include are: - Thorough presentation of product/service information Skills required for this project include a sound understanding of user-friendly interface designing, knowledge related to e-commerce business models, and experience with SEO to optimize browsing. Experience creating business websites will be well-regarded. Availability for continuous site maintenance and updates would be a bonus.

I'm looking for a skilled Graphic Designer to crea...on Google Play Store. The project involves designing 6-10 graphics in a clean and professional style. Key requirements include: - Experience in graphic design for digital products, particularly for mobile apps and the Google Play Store. - A strong portfolio showcasing your ability to create clean and professional graphic designs. - Expertise in understanding and visualizing the features and functions of an app to create compelling graphics. - A knack for providing guidance on the most effective content for these graphics, as copywriting assistance will be required. Your role will be crucial in making our app stand out on the Google Play Store, so your ability to create captivating, professional, and informative graphics wil...

I'm searching urgently for an experienced PHP architect who can const...items. - Integrating an 'Add to cart and checkout' feature ensuring a simple and smooth transaction process. - Developing order management and inventory tracking system within the admin panel to help me keep track of orders and product stocks. Skills and Experience Required: - Proficient in PHP programming - Experience in developing e-commerce websites - Solid understanding of databases and SQL - Familiarity with different payment solutions Although there is no specific requirement for payment method integration at the moment, the ability to seamlessly add these in the future is essential. My project requires immediate attention and the chosen freelancer needs to be able to commit and delive...

I am looking for a talented developer to create an AI Resume builder that can support multiple formats and boasts several features. Specifications: - The program should support PDF and Word file formats. - The AI technology should be able to provide several functions: Selecting templates, generating content, and optimizing keywords. - The design of the generated resume should exude a creative flair. Ideal Candidate: - Strong knowledge in Artificial Intelligence. - Proven skills in software development, particularly in building tools with creative designs. - Experience with resume building is a big plus! Together we can empower individuals to create eye-catching resumes that stand out. Let's give job hunters the creative edge they need in their job search!

I am in need of a professional who can promptly install and customize a PHP script for me. The PHP script I need to be installed is purchased through codecanyon. You will install, test all functions and activate license on our server. Being somewhat urgent, my requested completion for this project is ASAP. I value efficiency and swift, quality work. Thank you

I am in need of a skilled developer who can build a customized matchmaking database for my internal use. The database will primarily focus on matching investors to investment opportunities. Key Features: - Stor...and limited to specific staff members. No external user authentication is required. - Search Criteria: The database should have search functionality based on the geographic location. Ideal Skills: - Proficiency in database management and development - Experience in creating matchmaking algorithms - Understanding of security protocols for internal databases - Ability to implement search functions based on specific criteria Please note that this project requires a high level of security and confidentiality, so a strong track record in handling sensitive data i...

...Your tasks also include extending Codecanyon scripts by adding extra functionalities, ensuring consistent, flawless operation , implementing APIs and adding the functionalities in the existing flutter app, testing, fixing any bugs to ensure smooth operations of the system. Pay : 1. INR1200/day or fixed amount as decided by our project managers, for 8 hours of work on anydesk/github for adding functions 2. INR 2000/project for rebranding+testing+fixing 2 Apps systems of codecanyon like professional apps. 3. INR3000/project for rebranding+testing+fixing 3 Apps system of codecanyon like food and grocery. 4. We work from 6PM till 4AM in the morning in IST, so devs can join us after their regular working hours. We are seeking professional, only individual devs (no teams, no gro...

<Overview> Please collect product information on a vehicle control device that have or will have the technologies described in the “Technology Description” section below. <Technology Description> This technology arbitrates between control commands acquired from driving support applications that respectively implements driving support functions, outputs instructions based on a control command after arbitration to a processor that is able to control at least one of a brake actuator or a drive actuator. This technology also acquires a steering angle and a yaw rate as the control commands from the driving support applications. Please search for this technology in this contest. <<NOTICE>> The target car brands in this search are limited to US, Europ...

I'm looking for an expert programmer proficient in Node, The bot was created to scrape coins from my Telegram group via API integration but currently, it isn't purchasing as expected. Specifically, I'd require someone who could: - Identify and fi...bot interacts properly with the Latoken cryptocurrency exchange. This task would suit someone with a strong background in bot programming, API operations, web scraping, and experience dealing with cryptocurrency exchanges, particularly Latoken. Knowledge of crypto trading bots' operational peculiarities would be a major plus. Your task would be to get it back to working condition, ensuring all functions operate as they should. This job will evolve into continuous maintenance and development of bot's features. T...

I'm looking for an expert programmer proficient in Node, The bot was created to scrape coins from my Telegram group via API integration but currently, it isn't purchasing as expected. Specifically, I'd require someone who could: - Identify and fi...bot interacts properly with the Latoken cryptocurrency exchange. This task would suit someone with a strong background in bot programming, API operations, web scraping, and experience dealing with cryptocurrency exchanges, particularly Latoken. Knowledge of crypto trading bots' operational peculiarities would be a major plus. Your task would be to get it back to working condition, ensuring all functions operate as they should. This job will evolve into continuous maintenance and development of bot's features. T...

For my festival, I'm seeking a skilled web developer who is proficient in Bootstrap to create a website similar to the Festy Template. The primary functions of the website are to: - Promote the festival - Provide comprehensive information about the festival - Offer vendor signup with a contact form - Provide schedule and performer signup The project scope includes the development of less than 5 webpages with: - Textual content - Images - Videos A successful freelance web developer for this project should be experienced in Bootstrap and have a strong understanding of creating effective and engaging festival or event website pages. They should also be adept at incorporating various types of content, including text, images, and videos into their designs.

...and submission of grant proposals to the Ontario/Canadian Federal Government. Primary responsibilities include preparation of proposals and grant applications, and performance of responsible professional and administrative work in researching, identifying, developing and responding to Ontario/Canadian grant opportunities in areas that support IT, Digital Marketing & SEO programs. Essential Functions * Understand the history, structure, objectives, programs and financial needs of our organization. * Research grant opportunities from Ontario/Canadian government agencies. * Draft grant proposals and supporting documents based on the funding requirements of the organization. * Submit proposals to grant coordinators for approval. * Respond to internal and external queries on dr...

I am looking for an expert in RFID technology and .NET programming to integrate the RFID into our current weighbridge system. Key Details: - 3rd Party System was developed using .NET and it does support API or external interface connections. - The task will involve programming to fully integrate the system with RFID technology. Skills and Experience: - Proficiency in .NET programming & SQL Database - Previous experience with RFID technology - Knowledge of API integration - Experience with weighbridge systems would be a huge advantage. Your role will be to ensure the smooth functioning of the weighbridge system post-integration and provide us with a user-friendly, effective RFID solution.

I need an expert to implement and de...categories within the subscriptions page like Listivo dose on the packages page. - Implement the categorization within the Listivo interface You will see in the first attachment circled in blue in on Packages page , I need the same on Subscription page the other photo. Ideal Freelancer: - Exceptional experience in subscription system creation and development - Prior experience with Listivo and its functions - An eye for detail and organisation, ensuring a simplified and efficient user experience The freelancer will not need to establish functionalities for each subscription category in this phase of the project. However, a foundational understanding of such features could help guide their approach to the categorizati...

...Experienced using SQL Advanced experience developing test metrics and reports Experience with Automated Testing Five (5) • years of Testing experience in a Software Development Lifecycle environment Five (5) • SQL and PLSQL Programming in SQL Server ETL and Data warehouse process Informatica 10 • 20 Informatica Data Quality Profiles , Score Cards SQL Server RDBMS SQL Server Analytics Services SSAS SQL Server Reporting Services SSRS Tableau Reporting BMC Control M Scheduler Tool Data Analysis Data Profiling Application Life Cycle Management Complete Testing process SDLC, Agile Process, SAFE and Kanban methodologies, TFS Tool Good Communication Skills and Quick Learner Selenium Automation Unix Finance Domain Knowledge Automation Scr...

I need to create new functions in a system based on React.JS, Java Script

I'm in immediate need of a cloud-based stock management software with barcode generation, scanning, stock quantity tracking, and weight measurement functions. The system should enable me to: - Generate and scan barcodes for every product in my stock - Track the quantity of each item I have in stock - Measure the weight of my stock in grams I prefer a cloud-based solution that can be accessed and updated from any internet-connected device. The software should have an easy to use interface and be able to: - Enable manual entry of stock data - Support updating stock information by scanning barcodes - Automatically update stock data from my sales records The software could be developed in Excel, as long as it's accessible online. As a freelancer, you should have experience...

More details: What is the intended purpose of the device? Power automation What specific functions or tasks should the device be able to automate? power grid line control Do you have any specific requirements or features in mind for the power grid line control functionality? Real-time monitoring, Remote control. Develop a hardware prototype for detecting illegal electrical current tapping and automatically shutting off power to prevent hazards.