Xml sql stored proceedure 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 ;)
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
We require a programmer for a large MS Access/SQL Server project for 2-3 months. Please write me, if you are an experinced MS Access and MS SQL Server developer.
...to their Mobile Money Wallet. Customer experience is a key part of this application as we want to avoid making the browser go to many pages. Application will use separate exchange rates for converting from Currency A to Currency B and converting from Currency B to Currency A all set by the System Staff / Administrator. Customer depositing money from a particular currency means the funds will be stored in that currency wallet on the platform. All currency conversions can only happen on the customer wallets in the web application. Customer can only withdraw funds if their wallet(s) is funded. In the case that a customer wants to withdraw money but does not have up to that amount in another currency, the application will prompt them that the funds will be converted showing the to be...
...to their Mobile Money Wallet. Customer experience is a key part of this application as we want to avoid making the browser go to many pages. Application will use separate exchange rates for converting from Currency A to Currency B and converting from Currency B to Currency A all set by the System Staff / Administrator. Customer depositing money from a particular currency means the funds will be stored in that currency wallet on the platform. All currency conversions can only happen on the customer wallets in the web application. Customer can only withdraw funds if their wallet(s) is funded. In the case that a customer wants to withdraw money but does not have up to that amount in another currency, the application will prompt them that the funds will be converted showing the to be...
Need a python programmer for $15/hr, 15 hours per week work or less. Working hours are negotiable. Contract is 1 year. But first programmer has to crack the code and pass online coding exam. Sql will be plus.
Hola, necesito ayuda para aprender a trabajar con Json para consumir WS enviando facturas y luego consultar su estado. Además, aprender a leer XML para extraer la información y grabarlo en mi base de datos SQL Server
Looking for someone to use a bootstrap theme (I have the theme already) to create a web app. We will add features in phases, but the first feature / phase is having the ability to log in and submit a form. The information from this form should be stored in the web app and easily retrieved, and an email should be sent using SendGrid.
You have to write some queries for a given question which will be provided to you on offer, it will be 4-5 queries at max, just extracting some data. Player who had given checkmate with Pawn. Note: Consider all events for this query Result attributes: player_name Final result will have only one row
FrontEnd : React BackEnd : Node DB : MSSQL At this moment, only 1 page, like dashboard page, no need data entry, only retrieve & show on page respectively as charts currently, already have the mockup code need to replace actual value from DB using queries, stored procedure ... * Payment only SGD
...remotely turn on a car wash via a URL or app. Using a Click PLUS Plc. But I understand the program is written in simple ladder logic. (stackable_micro_modular)/cpus/c2-03cpu 1. Customer pulls up, opens APP or URL and scans QR code adjacent to the car wash’s pay station. 2. APP sends a xml message based on customer’s subscription type onto server with only a single number wash numbers 2, 3 or 4. 3. PLC receives the number and activates the corresponding wash output 2, 3 or 4. (We do the wiring inside the pay station and wire from the outputs to the terminals.) 4. Then, 2 seconds after any wash number is received 2,3 or 4, output #1 (the TOKEN signal) turns on for 1 second. (Activating
...different subject matters. For example, if I enter a question about pneumonia, I would tag it with "pulmonary" and "infectious disease". The user could then filter questions in the question bank via tags. I have all the questions in PDF format and I plan to copy and past them into the site via text so that the storage requirements would be minimal. (Obviously hundreds or thousands of PDF questions stored via an image would take a lot of space). The questions would have multiple choice answers and the software should be able to grade the user's responses. Ideally, a question would be presented and then allow the user to select an answer via multiple choice. Once the answer is selected then the answer would appear below the question with an explanation. ...
I want to create a family tree structure (like you get with Ancestry/FindmyPast) on an existing web site, but using records I have on my large Excel Database. I have an existing site which I have programed myself, but this uses pdf fi...create a family tree structure (like you get with Ancestry/FindmyPast) on an existing web site, but using records I have on my large Excel Database. I have an existing site which I have programed myself, but this uses pdf files to show the individual family history. The problem with this is that if I get an amendment I have to change the pdf records. As all the information is stored on an excel database what I hope to achieve is to change the excel record and that will automatically change the web page. Is this doable???
See attached picture of the problem. I need help writing a query that will be able to return this output. The input is shown in green table, only has 2 columns. I want a list of all the IDs and the original ID if that makes sense. Please see attached example. The green table is a transactional table where one record is linked to the previous ID. Please note, there could be hundreds unknown amount of links to previous records so need to think of an iterative or procedural way not just 3 nested select statements or something like that. Please start your offer with the word purple so I know you have read this project description. Thanks for your time and understanding.
need to build a demon that watch a certain folder, "Waiting", and looks for new content, xml files, every XX seconds. every new files that detected moved to "working" folder. every file that pass the manipulation goes to "Done" folder. files for manipulation & resulted files have constant structure. "one to one" mapping between tags in source file and resulting file will be provided is a sample for source file is a sample for resulting file.
I want to create a small web application for my internal use. Mainly a series of pages to pull and display data from SQL with some calculation of results along the way. But instead of you just doing it for me, I'd like you to teach me how to add fields to the form and link them up to SQL. You'll need - A solid understanding of C# - A solid understanding of Visual Studio and .net - A solid grasp of the spoken English language - The tools/gear to engage remotely (decent connection, mic, dual screens) - Verify that you took the tiem to read these instructions by putting my spelling mistake in the first line of your proposal. All time and work involved will be via remote desktop (Zoom) so if your connection can't support stable sessions, don't inquire. ...
Hi. I need a poc. We have gnss survey data in xml format. We need to plot a mesh and also add a moving object to that view from a separate cordinade xml file. We have a solution that reads and paints dots.
Hello, I am looking for a Developer who can build API's for me on AWS. I have an existing AWS API environment that the developer will need to work within. The API layer is responsible for business logic. Data Accessing will be through Stored Procedures that have already been created. These API's will be the backbone for a platform that we are building. The API's will have the additional features in scope: 1) Push Notifications Leveraging Amazon Pinpoint 2) Amazon Cognito, 3) Google Maps Places, and 3) S3 Buckets/Folders. The selected developer will be provided access to detailed API design processes with logic. The developer will need to pay close attention to detail, as well as, recommend best practices while understanding the goals of the API. I currently have 1...
...uses the conventional XML Web service (SOAP). Since the amount of data is large with XML, convert the API to JSON I would like to improve. This may be helpful. 82%92%E8%BF%94%E3%81%97%E3%81%9F%E3%81%84%E3%81%8Cxml%E5%BD%A2%E5%BC%8F%E3%81% AB%E3%81%AA%E3%81%A3%E3%81%A6%E3%81%97%E3%81%BE%E3%81%86 as a sense of volume The existing API has 25 methods (many are unused) The smartphone app side basically calls the API at startup Because the data is cached in the app Approximately the number of methods = the number of calls. Request items are changes on the API side, changes on the calling side Xamarin to development and testing If you have experience with Xamarin and XML web services, please
I'm learning VB.NEt and need tutorial help with the berst ways to work VB.NEt and sql. I need someone who has a thourough knlowege of the subject and will respond to my messages asking for advice in a short time.
Necesito crear una serie de microservicios en aspnet core 6 y sql server
TWO parts to this project for dev's with 4.7 stars or more 1/ Refactor (Refactoring is the process of restructuring code, while not changing its original functionality) the existing FLUTTER code. The app is c...both the IOS and Android stores but due to inefficiencies is now running extremely slow. You will be responsible for successfully getting the app onto both stores. 2/ Add push notifications from my (Windows server) in Azure. I would imagine it incorporates FCM. It needs to run efficiently and from on the server. There are apis to the relevant queries but you can create your own from the SQL server. You will need to demonstrate previously successful deliveries from freelancer for me to follow-up and have previous experience with FCM. Looking forward to hearing fr...
Building an ETL process to load data from Source system to a SQL datawarehouse. You must have experience building ETL process using SQL scripts, Stored procedure or SSIS. Experience in Datawarehouse design and setting dimension and fact tables.
We need to add subscription functionality on our website. The design will be provided and the development will be custom coded. Please read the requirements: Requirements: - Login/Sign-Up page or modal. After logging in, redirect to the My Plan page. After signing up, redirect to Choose Plan page. - Choose the Plan page. After a user signs up, ta...plan. - Backend work includes signing up and charging subscriptions (payment gateway integration). - After a user signs up, they can choose the free trial or a paid subscription plan. - After a user logs in, they can access the My Plan page. Users here can downgrade/upgrade/cancel plans and update billing information. - Sign-ups and changes to the plan must be stored so that the app has access to that information. Their data is st...
I'm looking for a tech support who can help me in my job. Tech Stack: Azure Synapse Power BI SQL Server Pyspark
I would need somebody who will import around 30 different JSON results (sport related) from an API into SQL tables on my server. The SQL tables need to update itself with new values from the JSON result after a defined time setting or on request.
FrontEnd : React BackEnd : Node DB : MSSQL At this moment, only 1 page, like dashboard page, no need data entry, only retrieve & show on page respectively as charts currently, already have the mockup code need to replace actual value from DB using queries, stored procedure ... * Payment only SGD
I need to write an apex class that calls a url. The url returns a response in xml. I need to retrieve some values from this return so I can use as an output. I have never worked with xml and only json. I can provide a sample xml response. I need to get this done in one day! Very quick turn around. Ideally my budget for this is $100
CMS Laravel Project Project Background: We have a need to continue the development of CMS Laravel Project. Project source code managed in Gitlab. Project Requires long term support and development. Requirements to the freelancer: 1. CMS Laravel Project based development experience 2. MariaDB/ My SQL knowledge 3. Gitlab source code management experience Ask for Task document! Note: Team will be given long term support opportunity . Note: Freelancers with less than 40 reviews DO NOT bid!
Предприятие торгующее множеством китайских безделушек, требуется создание базы данных с отстатками, ценами и автоматическим расчетом прибыли.
I need a power app done for staff claim with matching excel columns and rows and then sent for approval once user submits and then emails back the user. The information is also getting stored in sharepoint in different folder with each claim submitted.
Hi, I am looking for mobile database app for work order management. App will have following parts 1. Accepting orders in prescribed format for 6 different types of items. A. 6 Different format 6 different types B. 21 fix raw material selection dropdown an...order is punched data need to be sorted based on 1. Party 2. Raw material in pending order section. 3. Need Separate section for pending orders & completed orders. 4. In Pending order page need option to review order / edit order / mark as pending or in process or complete order. 5. In complete order section need option to review order / delete order. I also want to know where this data will be stored and also want right to allow which mobile user to have data access. app need to work on both android and i phone My budget ...
There are graphic corrections to be made for good html5 formatting and bootstrap to display correctly on smartphones. In ... In practice, some pages must be integrated with the C # sharp code of the aspx pages created in visual studio, as databases they use sql compact 4.0 c # (use database single file : this file is sql compact 4). Ci sono correzioni grafiche da apportare per una buona formattazione html5 e bootstrap da visualizzare correttamente sugli smartphone. In pratica alcune pagine devono essere integrate con il codice C# sharp delle pagine aspx create in visual studio, in quanto database usano sql compact 4.0 c# (usa database single file : questo file è sql compact 4).
Integrate SQL Server monitoring solution at and and have it monitor multiple servers and send email notifications The integration should also be able to use PowerBI to publish the findings and show dashboards. these tools exist today, but I need them to work as one and have a simple deployment. Also they need to work with future updates to the open-source projects DATABASE ADMIN, SQL SERVER, POWERSHELL & POWERBI SKILLS ARE IMPORTANT, PLS SHARE YOUR PORTFILIO OF SIMILAR PROJECTS
I have a script in PHP and SQL that i would like to run as a cron job at a certain time of the day. I would like someone to set this up for me.
...will be embedded with payment gateway for necessary online transaction. SECURITY, AUTHENTICATION AND PERSONALISATION Two Level Security 1. Initial Signup process 2. Checking User Id and Password while Logging 3. After clearing userid and password, a user need to confirm identity through Email Notification or Mobile OTP SOFTWARE TO BE USED TO DEVELOP • HTML5 • XML • Bootstarp • Javascript • PHP or Server Side Scripting • MySql Database Note: The project should not be on any CMS technology like WORDPRESS, JOOMLA etc.. It should be strictly on coding. Any team or individual from india having experience can apply for the project. We are open to pricing, please quote the price that you feel will cost you. But pric...
Design, develop and maintain BI Solution using Redshift, Tableau & Alteryx Optimize Redshift Data warehouse by implementing workload management, sort keys & distribution keys Required Skills: 4+ years of experience using databases such as Oracle, MS SQL Server 1+ Must have hands on experience of Amazon Redshift Architecture. 1+ AWS Pipeline knowledge to develop ETL preferably using AWS Glue for data movement to Redshift Strong knowledge on AWS environment and Service knowledge with S3 storage understanding Strong knowledge multiple cloud technologies including VPC, EC2, S3, Amazon API Gateway, DynamoDB, SimpleDB, AWS Route 53 Should understand nuances of moving data from RDBMS sources to Columnar DB (Redshift) Hands on experience in Data Warehouse (DW) and ...
Abstract: The objective is to implement the Frequency Domain Adaptive Filtering (FDAF) and perform a system identification of a real acoustical impulse response. Measurements of real acoustical signals have been performed and are stored in the project folder. Outline: There are multiple tasks to fullfill that includes programming in Matlab and most important writing a report for the obtained results. Please read the project pdf file before answering me. Reward: 40 euro for the code, 60 euro for the report (2 milestones, each one will be released after the corresponding task is finished and satifies the requirements. In the report please include the most important plots and describe all the results in detail (VERY IMPORTANT). Deadline: 21th August 2022, 2 p.m.
...projects on AWS and database platforms (RedShift, Athena, Aurora). 3) Experience In AWS service like S3,IAM,EMR,EC2,AWS Glue, EMR 4) Experience in Azure service 5) Experience in Kafka,and steaming processes and real time jobs. 6) Experience work with cliets and requirement gatering in agile way. 7) Experience Airflow and control-M job shedule. 8) Good working experience with different databases like MS SQL Server/Oracle/MySQL. 9) Experince in NoSQL databases will added avantages. 10)Experience working with GIT,Bitbucket and CICD Pipeline. for more detail you can share your updated resume with mention below detail Total Exp:- Rel Exp:- Current Salary:- Expected salary:- Current company:- How soon you can join:- Current location:- Preferred Location:- Reason for job change:- T...
I have excel sheet data , you have write sql queries according to questions, and give me output in excel
To use existing SQL database to create a dashboard that updates automatically in a website Use the existing MySQL database (login details will be supplied) to create a dashboard on a mobile responsive website page (as per pictures below) that updates automatically. The dashboard will be in the for of bar graphs as per photo illustration. There are 4 dashboards required , each with 7 graphs.