Sql server query työt

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

server optimisation

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 ;)

...You will be primarily responsible for backend development and Database management, but also need to handle some Frontend Development tasks. Key Responsibilities: - Backend Development: You should have a strong understanding of Node.js, and be able to build efficient, scalable, and secure backend systems. - Database Management: Proficiency in database management is crucial. Experience with both SQL and NoSQL databases will be a plus. - Frontend Development: While the primary focus is on backend, you should also have some experience with frontend technologies to assist with the development when needed. Ideal Skills: - Proficient in Node.js - Strong background in Backend Development - Experience with Database Management - Basic understanding of Frontend Development Please note t...

Want to setup one aws - subdomain for nodejs api to run - 2 public html domain website - install free ssl - provide proper ftp, putty access and ensure proper security to be taken care - Need to ensure no further issue come Only apply if you ok with 600 INR. and also in future ready to work on same price for 1 VPS setup work

I'm seeking an adept vb.net coder to design a desktop-based GST billing software that primarily integrates with SQL Server. While there aren't any specific features I've outlined, I'm hoping to work with someone who's knowledgeable about the typical functionalities of GST billing software. This expertise will be critical in shaping the software's development. Critical skills and experience required: - Strong proficiency in vb.net - Familiarity with SQL Server - Previous experience designing billing software - Understanding of GST's impact on invoice generation, tax calculation, and inventory management

I'm in need of expert assistance to establish my own SOCKS-based proxy servers, the main focus of which are to boost my network performance. Having an advanced understanding of proxy setup, I anticipate a seamless and efficient collaboration. Key Project elements: - Implementation of SOCKS protocol - Optimization for improved network performance Ideal candidates should possess: - Proficiency in setting up SOCKS-based proxy servers - Track record in network performance optimization - Ability to collaboratively work with advanced-level tech clients.

I require a Plesk specialist who can diligently perform server configuration tasks. Specifically, your role will involve fixing issues with connecting to an external FTP that is currently timing out. Knowledge and experience with Plesk, FTP and server configuration are critical for this project. Key tasks will be: - Troubleshooting external FTP timeout issues - Configuring server parameters as needed Please note that if you have experience integrating with cloud services, setting up email accounts, or configuring security settings, it may come in handy for potential future tasks.

I'm looking for an expert AWS/Ubuntu server administrator to troubleshoot and optimize my server's performance. I have a NodeJs app hosted on EC2 / Ubuntu server, it is working fine but sometime I see the sudden increase in Network in (bytes), Network out (bytes), CPU utilization (%), And memory. So my CPU goes from 2% to more then >60% Memory goes from 10% to more then >70% which triggered my server hang and then I will have to reboot my server to fix that issue. Since I am just alunching my web app, hence I dont have any traffic yet, hence I want to identify how my server resources utilization got increased. I need a person who can check and fix it, I am not really sure what is triggering this, and this Network in (bytes) increases for...

I'm seeking an expert in website migration, preferably proficient with Wordpress and Ubuntu server installations, creation of V-host, installation of LET's encrypt certificate and Test. The project in focus involves the migration of 3 Wordpress websites currently hosted on a VPS. Advance knowledge of eCommerce plugins, which are in use on these websites, is essential as these need to be properly migrated without loss of data or functionality. Specific Requirements include: 1. Migration Expertise: Proven experience in migrating Wordpress websites from VPS hosting to an Ubuntu server. 2. Plugin Knowledge: Must be well-acquainted with handling eCommerce plugins during the migration process. 3. Backup & Recovery: Unfortunately, there are no existing backups o...

DotNet developers required for "'Errors removal and Improvement work"' in thenafter Host on server. Developers should also have knowledge about Merger of sourcecode and database of his done-work with other developer's done-work on GitHub. Website Address - User emailid- @gmail.c Password- kaspersky Errors removal and Improvement work which has to be done is explained in below link-

Hi SERVEROK SOFTWARE, I noticed your profile and would like to offer you my project. We can discuss any details over chat. 2024-03-21 setup INR 200/- 2024-03-23 setup INR 200/- 2024-04-02 create zip and INR 200/- 2024-04-04 git pull error INR 100/- 2024-04-05 Ubuntu desktop setup INR 800/- INR 1500/- 2024-04-08 momachine install video INR 3000/- INR 4500/- 2024-05-03 git pull INR 100/- INR 4600/-

My project requires an experienced Java SpringBoot developer with a strong understanding of Kafka for asynchronous communication. The ideal candidate should also have: - Proficiency in building and managing REST APIs, focusing on CRUD operations - Ability to integrate with external APIs and service data repository calls - Expertise in crafting and handling SQL queries, preparing for moderate traffic and frequent daily queries - Competence in setting up batch schedulers - Proficiency in sending email notifications This project offers an excellent opportunity to apply and enhance your Java SpringBoot and Kafka skills.

I am in need of a Programmer who is experienced in Python, Machine Learning , SQL and have working knowledge of full stack development. We need someone who can help us training a LLM coding assistant. You would not be working on coding side of LLM, you would be working mainly on creating conversations for a programming problem to train LLM. Ideal Skills and Experience: - Proven expertise in Python programming and Django framework - Hands-on experience with Scikit-learn library for model training - Demonstrated knowledge and experience in Machine Learning and AI Model Training - Working knowledge of ReactJS & NodeJS If you think that you fulfill above criteria. I would be more than happy to talk to you.

I'm urgently seeking a professional who can install and configure Metin 2 game server files on a BSD system. The successful completion of this task will involve the integration of various features including: - User Account Management: The system should have a robust user account management system that ensures player data is securely saved. - In-Game Purchase System: I need an in-game purchase system that allows players to buy items and upgrades within the game. - Leaderboard Integration: A competitive aspect is essential for player engagement. I need the freelancer to set up a leaderboard system within the game. I'm expecting the project to be completed as soon as possible, hence the need for a freelancer with experience in setting up similar game servers and systems qui...

dns of your domain doesnt point to this server or you have htaccess rstricyions, also The IP address sending this message does not have a 550-5.7.25 PTR record setup

I will need a voip server for my call center, I need it to be created in magnusBilling in a VPSand for my clients to be able to change the caller ID directly from a softphone using a code, I also need my clients to be able to play hold music, Will like to find someone want to work long term for the maintenance of the server

I'm seeking a highly skilled fullstack developer who is proficient in PHP, .NET, and especially SQL for diverse web application projects. Your primary role will be equal focus on both front-end and back-end development on multiple platforms, including WordPress and PHP. Mandated Features: * Database Integration - Structuring, optimizing, and ensuring smooth functioning of databases within applications. * API Integration - Implementing third-party APIs comprehensively. Ideal Skills and Experience: * Proficient in PHP, .NET, and SQL. * Strong experience with WordPress. * Proven full-stack capabilities. * Expertise in Database and API integration. * Good problem-solving abilities and attention to detail. We're expecting high quality work with minimal supervision....

...automatique avec vos comptes clients, généraux, et sections analytiques. Paramétrage personnalisé : ce module va permet un paramétrage sur mesure, incluant la correspondance en fonction du numéro de facture, facilitant ainsi la concordance avec les comptes clients spécifiques. Intégration et lettrage directs : Une fois les extraits traités, le module intègre les données directement dans la base SQL, générant des références de rapprochement et facilitant le lettrage. 1- Intégrer le fichier à traiter : • Récupération automatique des extrait bancaires déjà reconnus dans sage à partir de son paramétrage • Dans ...

I have an Ubuntu server on which i need to be able to make snapshots of the server then to restore when i need - task is to install the correct libraries so i can make/restore snapshot - commands to make the conf should be written in a quick txt file so i can then reproduce if needed

I need a skilled Power BI developer to support me with key aspects of my project. Your tasks will include: - Data modeling and visualization - Creating insightful dashboards - Generating detailed reports You'll need to connect and work with data from Excel spreadsheets and SQL databases. So, competency and experience with these data sources is crucial for this project. I'm looking for an intermediate Power BI developer. You should have a solid understanding of Power BI functionalities and the ability to translate data into clear visual insights.

...Learning Specialization | - View Credential SKILLS Programming: Python, JavaScript, RUST, Golang, C, C++ Frontend Development: HTML, CSS, JavaScript, ReactJs Responsive design, Cross-browser compatibility Web performance optimization Backend Development: , Flask, RESTful API Microservices, Websockets, OAuth Nginx server management, Kubernetes, Kafka CI/CD integration Databases: RDBMS (MySQL, PostgreSQL) NoSQL (MongoDB) Query optimization, ORM/ODM (SQLAlchemy, Mongoose) Data warehousing, Distributed systems Machine Learning: Deployment Pipelines, Production management Data and Model Pipelines Neural Networks, Deep Learning, Algorithms Applied ML, Network Models Cybersecurity: IDS, SIEM tools, Network Security Linux, Cloud Computing, Cryptography Risk and Incident

We are in urgent need of an OVH Server Security Specialist to address recurring security issues with our server. Our server has been frequently compromised by viruses, resulting in the creation of malicious files and folders across directories. Additionally, these viruses have been generating .htaccess files that block access to internal pages of our websites. We are seeking an experienced professional who specializes in OVH server security to configure and implement optimal security measures. The ideal candidate will have a proven track record of effectively securing OVH servers against various threats and vulnerabilities. Key Responsibilities: 1- Conduct a comprehensive audit of our OVH server to identify existing security vulnerabilities and compromi...

...will be essential to provide a comprehensive analysis. - Data Visualization & Reporting: Building a robust reporting system will be necessary for clear, concise insights. - Automation & Migration: Implement RPA to automate repetitive tasks and ensure a smooth transition from PowerBI to Tableau. Skills Required: - Proficiency in PowerBI, Tableau, MicroStrategy, Excel, RPA, Data Bricks, Postgres SQL, and Python. - Experience in automating business analytics workflows. - Strong understanding of data cleaning, integration, and visualization. - Proven track record in successful migrations between data visualization platforms. I'm looking for someone who can take ownership of this project and deliver it with high precision and efficiency. A proactive approach to proble...

I'm in search of a seasoned DevOps consultant with strong expertise in Kafka and Akka. The role centers around the design, implementation, and monitoring of our cloud-based infrastructure on AWS. Strong scala programming skills and experience with Scala frameworks such as Akka. Efficient in designing and developing REST API’s. Experience with SQL and NoSQL databases. Proficiency in software design patterns and principles. Experience with version control tools such as Git. Good understanding of Agile methodologies and a collaborative mindset. Excellent problem- solving and analytical skills. Experience in unit testing (eg. JUnit/ Mockito). Experience in cloud- based environments such as AWS or Azure. Experience with Kafka and Elasticsearch. Experience : 5+ years only

...must have experience in developing RESTful APIs. You should be able to design and implement API endpoints that are efficient and scalable. - Integrating SQL Databases: In this specific project, we're focusing on SQL databases - MySQL and PostgreSQL. Your expertise in database integration should be strong. You should be able to design database schemas that align with the overall structure of the project and implement effective data retrieval and storage mechanisms. The ideal candidate for this position should have: - Proven experience working with Java Spring Boot - A solid understanding of RESTful API development - Extensive experience with SQL databases, particularly MySQL and PostgreSQL - Strong communication skills, as you'll be required to assist and...

I am seeking a skilled individual for data entry into an SQL Database. This project involves: - Converting digital non-structured data into SQL format - Inputting the converted information into an SQL Database accurately The ideal freelancer will: - Have SQL Database knowledge and expertise - Show proficiency in handling non-structured data - Demonstrate attention to detail and accuracy Experience in data entry, particularly into SQL Databases, would be greatly beneficial for this role. Your responsibilities will not only include converting and entering data but also ensuring its accuracy and consistency. I expect a high degree of meticulousness and precision from you.

...recurring problem with my Linux web hosting server. The issue essentially revolves around the Apache service, which keeps turning itself off and on sporadically. This continuous fluctuation is causing disruptions in the operation of my hosted websites. The primary goal of my project is to address and resolve this persistent Apache service problem. I need a skilled server administrator or a Linux system expert to investigate the root cause of the Apache's erratic behavior and implement a permanent fix for the issue. Key Requirements: - Proficient in Linux server administration - Expertise in Apache server configuration and troubleshooting - Experience with identifying and resolving service disruption problems - Ability to work remotely and access ser...

...accomplish With our team always here to help Ability to communicate and solve exciting tasks will be essential. We all collaborate together closely, work at same time with real time communication very important Experience: 1. PHP and related such as CodeIgniter, Laravel, .. 2. JavaScript and other front end technologies 3. Mobile App Cross Platform is plus for upcoming challenge 4. PostgreSQL, My SQL, etc. Work Requirements: 1. One Dedicated Programmer working on project 2. Agreed upon start finish each day to work at same time as our team 3. In addition to this site time tracker, Live Screen Sharing when paid hourly In your response: 1. Confirm agreed to above work requirements 2. Resume, Skill Listing, Example work 3. What days and times can you work in your time zone ? 4....

...software engineer with specialization in Artificial Intelligence, Machine Learning, MS Copilot, Cloud Computing (Azure), MS Power Platform, SQL Server, iOS, Android, and comprehensive Microsoft technologies. Preference will be given to candidates in the USA time zone. Key Details: - Main Objective: The main goal of this project is to develop a new software application. - Platforms: The application will be developed for Web, iOS and Android. Ideal Skills & Experience: - Proficient in Artificial Intelligence and Machine Learning with a proven track record in similar projects. - Expertise in MS Copilot, Cloud Computing (Azure), MS Power Platform, SQL Server, iOS, Android, and Microsoft technologies. - Prior experience in developing cross-platform applicat...

I'm looking for a professional with a deep understanding of SQL injection to help me identify vulnerabilities in a MySQL database. If you're experienced in this area, I'd be glad to work with you. Key Expectations: - Identify vulnerabilities: Your primary task will be to thoroughly test the database for potential vulnerabilities, considering various injection techniques. - No access: Since I don't have any access to this database, I'm looking for someone who can perform this task remotely. You'll be expected to provide a detailed report on the vulnerabilities identified, so I can address them with my database administrator. - Change database values: Additionally, I'd like you to demonstrate the ability to change database values, as a proof of con...

As someone requiring a Linux Server Administrator with AWS expertise, I require specific support with server maintenance and updates - specifically involving an Apache environment. Your role will entail ensuring optimal performance and uptime. A diverse skill set including the following is vital: - Proficiency in Linux server administration, particularly within an Apache environment - Knowledge on server maintenance and updates - Capability to handle AWS resources management and environment We are looking for a Linux server administrator with expertise in AWS to manage our server infrastructure. The responsibilities include ensuring the smooth operation of the servers and addressing any issues that may arise within our custom-built system. We wi...

...structures. ......" ] } 1 1 (b) s2/s2 : All the 100 queries. Each query has 2 fields: i. qid: The unique id of the query ii. query: The text of the query Some query entries from the file are: { "qid": "1", "query": "deep learning" }, { "qid": "2", "query": "artificial intelligence" }, { "qid": "3", "query": "information retrieval" }, . . . (c) s2/: The relevance values of research papers for each query is given in this file. The columns are: i. qid: id of the query for which the relevance value is marked ii. docno: document id of the research paper for which the relevance is marked iii. relevanc...

This error has been traced back to the Apache webserver, it is a PHP and WordPress error "Please check that the mysqli PHP extension is installed and enabled." Key tasks for this project include: - Identifying the root cause of the 'Internal Server Error' message - Resolving the issue promptly to restore the website's functionality Ideal Skills and Experience: - Proficiency in PHP and Apache webserver - Strong experience in debugging and resolving 'Internal Server Error' issues - Excellent problem-solving and communication skills

Google big query - for writing sql queries for the complex data

I'm currently experiencing several issues that strongly suggest a malware issue on my apache server. My website's performance has seriously declined, and much to my disturbance, Google has flagged my site as dangerous. I haven't taken any steps yet to resolve these issues so now I'm seeking professional help. To be successful in this project, you will need: - Expert knowledge of Apache servers - Strong experience in malware removal techniques - Excellent understanding of domain whitelisting - Safety assurance to recover my domain status on Google I'm looking forward to making my website perform faster and being flagged safe on Google and other antivirus platforms.

...shared hosting server, which currently manages to support up to 100,000 concurrent users. As my requirement increases, there's a need to further improve its ability to handle more. My server largely deals with devices on the ground, transmitting continuous data back to the server, and the sheer volume of synced devices can lead to server strain. I require a professional who has: - Expertise in server management and optimization - Proven experience with scaling shared hosting servers - Knowledge related to server load balancing - Proficiency in data flow optimization Your task would include the analysis of the current setup, troubleshooting potential bottlenecks, and implementing successful changes to increase concurrent users. Please hav...

Hi Ganesh D., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

I'm in need of a freelance Node.JS expert to help me with my Node.JS server setup. - Ideal candidate should have extensive experience in setting up and configuring Node.JS servers. - Knowledge of web and mobile application architecture is a plus. - Preference will be given to those with previous experience in API backend development.

Hi, we require an SQL macro that we need to be able to delete EAN codes that have less than 8 numbers from the import. So EAN codes that have between 1 and 7 digits must be removed from the import. We use a software called StoreManager that uses SQL. The formulas entered in the software look like this IF([CSV_COL(16)]=0 OR[CSV_COL(16)]=‘’ OR[CSV_COL(16)]<0,‘’,[CSV_COL(16)]) Payment and/or Milestone after the problem has been solved.

...functionality. Key Responsibilities: - Enhancing the existing dashboard by adding new features and functionalities. - Ensuring that the dashboard has real-time data update and interactive capabilities. Data Sources: - The data sources for this project include databases (SQL, NoSQL) and local files (CSV, Excel). Ideal Candidate: - Proficient in Tableau with a proven track record of developing and enhancing dashboards. - Experience working with real-time data sources and interactive dashboard elements. - Understanding of SQL and/or NoSQL databases. - Familiarity with data visualization best practices. I am looking for a professional who is not only skilled in Tableau but also understands the importance of user experience in data visualization. Please pr...

...you passionate about programming languages and eager to make your mark in the IT industry? Look no further! We’re hiring talented individuals to join our dynamic team. Position: Software Engineer Domain: Finacle (Banking) Location: Major cities in India and international locations Why Choose Us? Comprehensive end-to-end training in Unix/Linux, JSP, HTML, Core Java, Node JS, Node red, Oracle SQL, and PLSQL. Exciting projects in the banking domain Opportunities for growth and career advancement Terms and Conditions: Commitment: Minimum 3 years with us Training: First month (free accommodation), followed by competitive salary Performance-based increments from the second year onward Global travel opportunities Qualifications: - While we do not have any specific certificat...