Sql 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

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

We are a training company and want to give our clients an impression about what we are doing in our trainings and what kind of information we provide. We want to show example lessons on YouTube and are looking for admins/trainers who can create these examples: - Veeam - Microsoft Windows Server 2019/2022, Azure, MS SQL Server - BigData - Veritas Software - McAfee and Trend Micro Trainings should be done in English or German language and should have subtitles in German and English. You can find our websites here:

I am looking for an expert in database management who can optimize price calculation for my portal .... Currently we have a basic setup which needs to optimize using BIGQUERY solution (Google Cloud Platform) or changing the entire algorithm... We are using SQL as our db and on the front end we use LARAVEL framework. More info will be shared with the right candidate who can provide us the right solution and has demonstrated skill set

MSHD is looking for PHP Developer, Someone who is fully delegated to programing and understand System requirements, is existing Site need to be modified, New Modules, Fix Exciting Bugs We are looking for php, SQL, JavaScript, Nodejs, J query, and more development tools that can help our platform to accelerate. Availability of developer is very important as this is ongoing project. Should you think you have what it takes and you specialize with PHP, MSHD would like to give you and opportunity to work closely with with us

We have an in-house WEB (Django) & Mobile (Kotlin) development team, and we need a senior developper with experience in the following stack in order help with code review, unit testing implementation, best practices, app optimization (loading times, caching etc....in-house WEB (Django) & Mobile (Kotlin) development team, and we need a senior developper with experience in the following stack in order help with code review, unit testing implementation, best practices, app optimization (loading times, caching etc..) : Mobile stack : - Android / Kotlin - Room database - Retrofit - Mapbox Back-end & Devops stack : - Django / Django Rest Framework - Postgres SQL - Docker - GIT If we can get Kotlin Developer that would be good too. Please attach CV for the both or atleast Dj...

...Required skills: More than 5 years of solid experience and knowledge in Java Experience with Angula, Javascript, SpringBoot, SpringBatch, Intellij, Hibernate / JPA, Maven, Tomcat, REST Knowledge of version control, ability to write tests, refactorize existing code and work with existing code bases Experience of all aspects of software development lifecycle and system integration Good knowledge of SQL Very good knowledge of data modeling, GIT / BitBucket, Jenkins, SonarQube, ELK, Docker Experience of working according to agile project method Knowledge of coding standards, security checks (OWASP), code review, source control management, testing and operation Knowledge and experience of AWS Excellent communication skills Ability to adapt to a dynamic work environment and make indep...

...5, C#, ASP.NET, T-SQL, C/C++, XLM. Experience with SharePoint Designer, InfoPath, Web Parts, and workflow creation. • Experience as a SharePoint Developer in the analysis, design, hands-on development and delivery of web-based applications. • Experience using jQuery, Client Object Model, and Service Oriented Architecture. • Experience with SharePoint’s application services framework including implementation, configuration, and usages of Search, Managed Metadata, and User Profile Services. • Microsoft MCPD 70-576, SharePoint 2010/2013 Designing and Developing Applications certification is a plus but not required. • Ability to write Stored Procedures, write complex SQL queries, and ability to analyse the SQLdata is desired. • Experience wi...

...be working with AWS cloud services ; -Embracing extensible design, meeting required performance, quality and compliance - Utilize best practices and industry standard in packaging, testing, deploying and monitoring our applications. Requirements: -At least 4 years of development experience in developing APIs and backend services; -Knowledge of Python; Perl; Ruby; PHP ; -Familiarity working with SQL databases; -Strong working experience with REST APIs(OpenAPI, JSON Schema); -Familiarity with Docker and containerization; -Experience with message queues( e.g. RabbitMQ, SQS, Cloud Tasks etc.) Nice-to-haves: - Experience working with Kubernetes, Helm and GitLab CI/CD ; - Familiarity with Elasticsearch engine ; - Familiarity with caching services (Memcached, Redis etc.) - Experience ...

Hello I have a dataset from which contains large content of hotels and the file format they have provided me is CSV which I need to convert into SQL I'm looking for someone to help me just to convert into SQL and send back to me thats it. need it asap so will hire anyone who has done such stuff before. note : need exact CSV columns to be converted into SQL Tables columns you may download and check the file from this link

Hi there, I am needing help fixing the below re-occuring error I am getting on my Wordpress site: WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '= 'wp_3_woocommerce_product_addons' AND column_name = 'sub_title'' at line 1 for query SELECT COLUMN_NAME FROM table_name = 'wp_3_woocommerce_product_addons' AND column_name = 'sub_title' made by require(''), require_once(''), require_once(''), require_once(''), do_action('after_setup_theme'), WP_Hook->do_action, WP_Hook->apply_filters, WC_Custom_Product_Admin::create_table

I need someone to resolve SQL and python problems

Necesitamos un programador con conocimiento en phyton aplicado a Odoo13, asi como la configuracion de odoo, ademas de manejar base de datos en posgress SQL. Manejar Linux, XML, JavaScript, para apoyarnos en modificaciones requerida por nuestro departamento de operaciones, para adaptar odoo al modelo de trabajo de la empresa.

I have a SQL Server .BAK backup file. I need somebody to restore it and extract the contents of five tables into tab-delimited files with headers. Then deliver those files to me.

I need a multi page website Requirements needed Php , sql ,mongo db ,apache host and Proxy chain

...(room) selected, pictures and payments will be listed at the bottom for that room. Here is the examples from demo: (when card selected grid data is refreshed) (I also want images to be refreshed when a card/room is selected) Pages I want: 1. Dashboard - I just want some calculated info from SQL Server as text. two dropdowns apartment and year. If user select 2019, then total income will be listed for 2019 and selected apartment. I will do the CSS for this page myself. Actually no need any css design for this project. I just want the same look with the demo. 2. Apartments - This is easy. This is also included in the demo. I just want a grid and able to add new/edit record. Example url:

About 40000 lines of source code of a vb.net wcf server. We need to convert it to c# and .net6.0. Existing project is using raw mysql queries that must be converted to entity framework

The table is given: CREATE TABLE salaries2 ( Employee_mark INT NOT NULL, an NUMBER (4) NOT NULL, luna number (2) NOT NULL, NUMBER (3), income base NUMBER (16.2), increase NUMBER (16.2), tax NUMBER (16.2), NUMBER retainers (16.2), CONSTRAINT pk_salaries PRIMAR...CONSTRAINT pk_salaries PRIMARY KEY (employee_brand, year, month), CONSTRAINT ck_salarii_an CHECK (an between 2001 and 2012), CONSTRAINT pk_salarii_luna CHECK (luna BETWEEN 1 and 12) ); Write a function that determines the net income of the employee with the registration number "employee_mark" (input parameter. Net income = Basic income * (bonuses / 100) - tax - withholdings). Give an example PL / SQL execution block that defines a cursor that changes the hourly wage by 10 percent more, if it is lower than the val...

We are seeking a freelancer who is interested in possibly a permanent position within our company to help us manage and develop new process flows within our SAGE ERP E3 Syracuse system. ▪︎ ERP Systems (Sage ERP X3) ▪︎ DBMS (Microsoft SQL PostgreSQL) ▪︎ Reporting (Crystal Reports Sage Intelligence, PowerBi)

need a report writer who knowledge of sql, python, data analysis, supply chain

If you have this AI and Biometric Device Project done just add in my project. Also you have done using AI, using AI (Face) User with AI(Face) User Face image and storing the data in table with some calculation 4.E sign pen saving 1. To capture and store finger print data to MS SQl, Login & Search with fingerprint. and storing the data in table in table with some calculation. Code scanner ,Searching qr id from the sql table and entry of date time. IN a page showing data removing the name of the person who scanned the id. My Budget is 50 USD. Thanks Happy Bidding

I have 3 small projects in one project about SQL and data Visualisation. Any one can finish it early and perfectly will be in my future work I would give at most 20$ For each project. The deadline 27 jan 12:00 AM Makkah time.

...The deliverable is the base of a multiplayer experience for Virtual Reality in an MMORPG style using UNITY as platform. We prefer the use of Photon for multiplayer purposes and the deliverable should contain the following scenes: Scene 1: Login Login, Password + forgot my password Screen for simple registration of users ( User, password, confirm password) The users should be registered in a SQL database, maintained with the application in an AWS server. - Scene 2: - Option to enter the main lobby ( a public multiplayer scene in MMO RPG style) - Option of creating private rooms ( send the nickname via chat to invite friends) - Chat includes text messages and audio (with a UI), that stores messages. Audio in .ogg or other forms of compression. - Data such as friends,...

I need someone who can dedicatedly work on my contract project as a full-time Java developer. this is the contract-based job and need to deliver the task as provided. Must have an engineering degree Experience with Java enterprise technology including JSF, EJB, JPA, JMS Experience in troubleshooting databases and queries using SQL and ORM frameworks such as Hibernate and Eclipse link

...here. So, I need experts in the following fields, 1. Electronics : Circuit design, testing & certification, 2. Electrical : Servo, PLC, loop control, micro devices, etc 3. Material: Selection of material, property analysis, behavioral study, etc 4. Bio-Electronics: Bio sensors, Bio detectors, medical instrumentation, etc 5. Software: Software developer- C++, Python, Tensor, VB, Micro-assembler, SQL, MySQL, etc 6. FEA/CFD Analysis: Abaqus, Openfoam, Cosmos, Fluical, Matlab, etc. in mechanical, magnetic, electrical field Interested candidates should show their interests with field of expertise. I need only the following people to show their interest: - Passionate & crazy in their working field - Wants to show what they can do to the world - Believe in himself/herself at t...

Migrate an access database (about 30 very simple tables with little data) to SQL Server. Migrate structure, relations and data.

Want to migrate a number of single pay as you go SQL Azure databases into a single Elastic pool. Calculate the size of Elastic pool required, create a move single pay as you go SQL databases into the Elastic Pool.

I am looking for Web Developer for ASP.NET, C# Web Development and MS SQL Server with strong development experience for long term assignments

Short Analysis of a network. Capabilities needed: Qgis, Excel, R o python. Use of the Google API to find places. maybe some SQL. 10 mins conversation. 1 to 3 hrs of work for today.

I have many years experience in C# and Azure. I'm starting a new piece of work next week where I need to develop an ETL job in NodeJS to be hosted in a Amazon Lambda function. This job will pull data from an Microsoft SQL Server Database (I have one setup in Azure) and post to a REST API. I'm looking for someone to pair with starting Sunday 23rd Jan UK time. I think 2 hours should be sufficient for initial session. I expect there will then be ongoing development for the following 6 weeks. Candidate must have recent experience of AWS Lambda (test and devops processes) and NodeJS. They must also be fluent in spoken English.

We are a training company and want to give our clients an impression about what we are doing in our trainings and what kind of information we provide. We want to show example lessons on YouTube and are looking for admins/trainers who can create these examples: - Veeam - Microsoft Windows Server 2019/2022, Azure, MS SQL Server - BigData - Veritas Software - McAfee and Trend Micro Trainings should be done in English or German language and should have subtitles in German and English. You can find our websites here:

Hi, I am looking for dotnet has good experience in Asp.net Webforms,Asp Net MVC Core,Web api,C# and Sql Server. Looking for long term relationship to work on my application. Will give fixed payment for monthly.

Richiesta residenza vicino a Milano. Le principali competenze richieste sono: - Conoscenza Microsoft .NET Framework 3.5-4.5 e ambiente MS Visual Studio - Conoscenza del linguaggio C,C++,C#, librerie QT - Conoscenza database Mysql e SQL - Conoscenza dei linguaggi/framework web client side: Javascript, jQuery, json... - Conoscenza HTML e CSS Gradita esperienza pregressa nello sviluppo di applicativi di imaging medicale, moduli driver per device di acquisizione immagini.

We are looking for a remote server which employees can login to each day to work on code, .net (visual studio and sql). We don’t want any developer to be able to download the source code and/or copy the database. We currently are using AWS to host our Windows server, so it may be better to use AWS if deployment is much easier from one instance to another. Also, we are up for any other options but security is a priory. Please go through the attached file and answer each question. Based on your answers we will move forward

Write PostgreSQL queries on a dataset of trains. total queries - 11

Must have Skills: Main must have skill Sets for a FullStack Developer: - Asp.net - C# - Very good experiencing in refactoring - Knowledge and experience in Solid principles and also ideally clean code principles - .Net Core 2+ - MS SQL Server - Unit testing, Integration testing - Patterns

We are looking for a remote server which employees can login to each day to work on code, .net (visual studio and sql). We don’t want any developer to be able to download the source code and/or copy the database. We currently are using AWS to host our Windows server, so it may be better to use AWS if deployment is much easier from one instance to another. Also, we are up for any other options but security is a priory. Please go through the attached file and answer each question. Based on your answers we will move forward

Introduction Astral Tech is a rapidly growing Enterprise SaaS provid...self-serve, broker self-serve, customer service platform, with data warehouse and analytics. It’s built on a Microsoft stack running in pure Azure. We are looking for talented developers to join our growing team. The candidate needs to work US hours and is based in a US time-zone, including Canada and South America. Full Stack Developer • .net & .net Core • Class Design • Visual Studio • APIs • SQL Service • Stored Procedures • Entity framework • HTML • Bootstrap • MVC • JS • Knockout • Microservices • Good communicator • Good problem solver • Github Ability to problem solve and find out how to do things they've never...

We are migrating our site from a Centos 6 Server to a Centos 7 server and have setup a Test environment in our office. The current Live site is running on CentOS 6 Server which is running PHP 5.3.3 and MySQL database version 5.5.61 The new CentOS 7 Test environment is running on PHP version 5.6 and My SQL is 5.5.62. The website data has been uploaded and we are getting a 404 message on Test Centos 7 server We are looking for a developer / team who can work on fixing the 404 issue caused due to new CentOS 7 setup including a different PHP version. The project will require the work on our Virtual Box Test server which is setup on a Windows machine which can be accessed remotely via AnyDesk / Team Viewer. Please read the attached PDF for Error message and additional details.

Hi I am looking for Azure Data Engineer with following skills. Please bid if you have following skills. • Extensive hands-on experience implementing data migration and data processing using Azure services: ADLS, Azure Data Factory, Azure Functions, Synapse/DW, Azure SQL DB, Databricks Azure Data Catalog, Cosmo Db etc. • Hands on experience in programming like python, Scala • Well versed in DevOps and CI/CD deployments • Must have hands on experience in SQL and procedural SQL languages • Strong analytical skills and enjoys solving complex technical problems

... login with Password567 As the present portal is built in asp.net webforms I'd like to keep it that way and just adjust the css and bootstrap. You'll need to modify the master page and the CSS. At a minimum get the menus working and get the application page responsive and if possible fix the signature box (super signature) so that it works on mobile. You'll need SQL Server and the latest visual studio - I can send you a stripped down version of the database and ASP.NET application. I can't vouch for the overall quality of the existing CSS... It will take a day or so to organize that and get that over to you. Would not hurt to download telerik ajax suite (demo) as those controls are referenced in the project. You don't need to modify the func...

I have to create a booking tee time site with many use cases/ pages. I am using ASP.NET Razor Pages and SQL. I need help with: SQL Tables and Store Procedures Razor Pages and the code behind it. For example submitting a form. Validation. Accepting Payments. Login Page, Create Reservation Page, FindReservation, AddMember, FindMember, FindReservation, etc.